|
·ÖÀർº½ |
 |
|
|
|
|
×ÊÔ´´óС£º12.78 KB |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 0 |
|
|
|
×ÊÔ´½éÉÜ |
|
Ò»¡¢ ¹ºÔö
1¡¢ É豸¹ºÔö
1£©¹ºÔö
É豸Ãû³Æ£ºTagSql = 419 £¬±ísb_zd_equipname
·ÖÀࣺ±ísb_zd_class
µ¥Î»£º±ísb_zd_unit
¼ÆÁ¿£º±ísb_zd_measure_type
Éú²ú³§¼Ò£º±ísb_zd_manufacture
ÕÛ¾ÉÀàÐÍ£º±ísb_zd_depreciation_type
Èë¿âÐòÁкţºselect in_series from sb_configure where kzh_no = '01' ¶ÔÓ¦sb_in_detl.in_series
Èë¿âµ¥¾ÝºÅ£ºselect in_docu_no from sb_configure where kzh_no = '01'¶ÔÓ¦sb_in_detl.in_docu_no
Èë³öÀàÐÍ£ºSELECT * FROM sb_zd_in_out_type WHERE (in_out_flag = 'IN') AND (kind = 1)
¹©Ó¦ÉÌ£º±ísb_zd_supplyer
Èç¹ûÈë³öÀàÐÍΪ£º¹ºÈ룬Ôò±£´æÊ±Ð´Èësb_in_detl[Èë¿âÃ÷ϸ±í]£¬Í¬Ê±Ð´Èësb_main_equipment[Ö÷É豸±í]
Á½±í¹ØÁªÓÃkzh_noºÍin_series£»sb_main_equipment.state=¡¯02¡¯ ÔÚ¿â״̬£¬Æä×Ö¶ÎÖµÀ´Ô´ÓÚsb_zd_state
Èç¹ûÈë³öÀàÐÍΪ£ºÈë¾ÉÕÊÒ³£¬Í¬Ê±Ð´Èësb_move_detl[³ö¿âÃ÷ϸ±í]£¬¶øsb_main_equipment.state=¡¯04¡¯ ÔÚÓÃ״̬
Sb_move_detlºÍsb_main_equipmentÁ½±íÓÃequip_id¹ØÁª¡£
Èç¹ûÒ»ÖÖÉ豸£¬ÊýÁ¿n¸ö£¬Ò»´ÎÈë¿â¡£Ôòsb_in_detlÖÐÒ»Ìõ¼Ç¼£¬¶øsb_main_equipmentÓÐnÌõ¼Ç¼£¬In_seriesÏàͬequip_id²»Í¬¡£
2£©ÍË»õ
Sb_in_detlÖÐдÈëÒ»Ìõ¼Ç¼£¬in_seriesΪÔÈë¿â¼Ç¼µÄin_seriesµÄ¸ºÖµ
Sb_main_equipment.state=¡¯03¡¯ ÍË»õ״̬
2¡¢ É豸ÐÅÏ¢
ÂÔ
3¡¢ ¸½¼þ¹ºÔö
1£©Èë¿âµ¥¾ÝºÅ£ºselect appendix_in_docu_no from sb_configure where kzh_no = '01'
2£©Update sb_main_equipment set appendix_flag = '1' where equip_id = '00005605'
¸ü¸ÄÖ÷É豸ÐÅÏ¢±íµÄ¸½¼þ±êÖ¾appendix_flag
3) sb_appendix[É豸¸½¼þ±í]ÖвåÈë¼Ç¼ sb_appendixºÍsb_main_equipmentÓÃequip_id¹ØÁª
ϵͳ³õʼ»¯ÖУº¸½¼þ¼ÛÖµÖ±½ÓÔö¼Óµ½Ö÷É豸ÉÏ £¬ÎÞЧ£¿[sb_configure.add_appendix_to_equip]
4¡¢ ·ÖÆÚ¸¶¿î
1£©É豸Ãû³Æ£ºTagSql=429 £¬²éÕÒsb_in_detl.first_pay_value
µÄ¼Ç¼¡£ ´ËÔʼ¼Ç¼µÄΪÔÚÉ豸¹ºÔöµÄʱºò£¬Êµ¸¶½ð¶îÊÖ¹¤¸Ä¶¯µÄ¼Ç¼¡£
2£©¸¶¿îµ¥¾ÝºÅ£ºselect pay_docu_no from sb_configure where kzh_no = '01'
3£©¼Ç¼±£´æÔÚ±í£ºsb_pay_detl[·ÖÆÚ¸¶¿îÃ÷ϸ±í] Óësb_in_detlÓÃkzh_noºÍin_series¹ØÁª¡£Sb_pay_detl.sum_pay_valueΪÿ´Î¸¶¿îºóµÄ¸¶¿î×ܽð¶î£¬Èç¹û´óÓÚsb_in_detl.buy_price * sb_in_detl.buy_amountÔò²»Äܱ£´æ¡£
5¡¢ É豸Ôö±áÖµ
1£© É豸Ãû³ÆTagSql=424
2£© ÔöÖ³£ºupdate sb_main_equipment set depre_price = 150300,remain_value = remain_value + 300 where equip_id = '00001069' ¸ü¸ÄÉ豸ÔÖµºÍ²ÐÖµ£¨¼Ó£©£¬¼Ç¼±£´æÔÚ±í£ºsb_value_increment
3£© ±áÖµ£ºupdate sb_main_equipment set depre_price = 1900,remain_value = remain_value + -50 where equip_id = '00002042'¸ü¸ÄÉ豸ÔÖµºÍ²ÐÖµ£¨¼õ£©, ¼Ç¼±£´æÔÚ±í£ºsb_value_increment ,×Ö¶Îincre_valueΪ¸ºÊý
¶þ¡¢ ʹÓÃ
1¡¢ ³ö¿âµ÷Åä
³ö¿âÀàÐÍ£ºselect * from sb_zd_in_out_type where kind like '2' and in_out_flag like '%' and deleted_flag like '0'
ÓÃ;£ºselect * from sb_zd_usage
ÔÒò£ºselect * from sb_zd_move_cause
¿ÆÊҵصãµÄTagSql=2
±£´æ£º
1)¸ü¸Ä³ö¿âµ¥ºÅ
Update sb_configure set move_docu_no=SubString(('000'+Convert(char(4),move_docu_no+1)),len('000'+Convert(Char(4),move_docu_no+1))-3,4) where kzh_no = '01'
2£©¸ü¸ÄÖ÷É豸ÐÅÏ¢±í
update sb_main_equipment set state = '04', usage = '01', inner_acct_no = '1010109', place_dept = '1010109', keep_oper = '', contact_oper = '', allo_unit = Null where equip_id = '00005660'
update sb_main_equipment set use_date ='2007-11-26' where equip_id = '00005660' and use_date is null
3£©³ö¿â¼Ç¼Ã÷ϸ±íдÈë
sb_move_detl
2¡¢ É豸Ïú¼õ
ÒµÎñÀàÐÍ£ºselect * from sb_zd_in_out_type where kind like '3' and in_out_flag like '%' and deleted_flag like '0'
Ïú¼õÔÒò£ºselect * from sb_zd_move_cause
±£´æ£º
1£© Ïú¼õÃ÷ϸдÈ룺sb_waste
2£© ¸ü¸ÄÖ÷É豸±íµÄ״̬£ºupdate sb_main_equipment set state = '07' where equip_id = '00005591' and state = '04'
3¡¢ ¸½¼þºÄÓÃ
Èë³öÀà±ð£ºselect * from sb_zd_in_out_type where kind like '3' and in_out_flag like '%' and deleted_flag like '0'
±£´æ
1£©¸ü¸ÄÉ豸¸½¼þ±íµÄµ±Ç°ÊýÁ¿
update sb_appendix set curr_amount = curr_amount - 1 where equip_id = '00001069' and appendix_series = 1
2£©¸½¼þºÄÓÃÃ÷ϸ¼Ç¼дÈë
sb_appendix_use
4¡¢ ³É±¾Ð§Òæ
±£´æÔÚ±í£ºsb_cost_benefit
Èý¡¢ άÐÞ
1¡¢ άÐ޵ǼÇ
±£´æÔÚ±í£ºsb_maintenance_record
ËÄ¡¢ ¼ÆÁ¿
1¡¢ ¼ÆÁ¿µÇ¼Ç
±£´æÔÚ±í£ºsb_measure_record
Îå¡¢ ²ÆÎñ
1¡¢ Ô½á
µ÷ÓÃ7074ºÅ±¨±í
exec sp_executesql N'exec sb_month_report_wj @P1,@P2,@P3,@P4,@P5
', N'@P1 datetime,@P2 datetime,@P3 varchar(2),@P4 datetime,@P5 varchar(10)', '10 26 2007 12:00AM', '11 26 2007 12:00AM', '01', '10 26 2007 12:00AM', 'ȫԺ'
±£´æ£º
1£© »ã×ܼǼдÔÚ£ºsb_report
2£© ¸ü¸ÄÈë¿âÃ÷ϸ±íµÄreport_date
exec sp_executesql N'update sb_in_detl set specification = @P1, invoice_name = @P2, report_date = @P3
where in_series = @P4 and kzh_no = @P5 and input_date = @P6
', N'@P1 varchar(32),@P2 varchar(50),@P3 datetime,@P4 int,@P5 char(2),@P6 datetime', 'TX100LA', '¶àÆÕÀÕÌ¥Ðļ໤ÒÇ', '11 26 2007 7:10PM', 900, '01', '06 26 2007 3:30PM'
3£© ¸ü¸Ä³ö¿âÃ÷ϸ±ísb_move_detlµÄreport_date
2¡¢ É豸ÕÛ¾É
Ô¤ÀÀµ÷ÓÃ6052ºÅ±¨±í£¬Ö´ÐÐ
exec sp_executesql N'exec sb_depreciation_preview @P1, @P2,@P3,@P4
', N'@P1 datetime,@P2 datetime,@P3 varchar(2),@P4 varchar(5)', '11 28 2007 12:00AM', '11 28 2007 12:00AM', '01', '00000'
±£´æÖ´Ðд洢¹ý³Ì£º
exec sb_depreciation '11 28 2007 12:00AM', '11 28 2007 12:00AM', '01', '00000'
3¡¢ ¹©Ó¦É̽á¿î
Ô¤½á£ºµ÷ÓÃ7105ºÅ±¨±í
½á¿î£º
exec sp_executesql N'update sb_in_detl set
acct_date = @P1,
acct_docu_no = @P2,
acct_oper = @P3
where
input_date = @P4 and
in_docu_no = @P5 and
supplyer_code = @P6 and
in_series = @P7 and
acct_date is null and
acct_docu_no is null and
buy_price = @P8 and
kzh_no = @P9 and
acct_oper is null
', N'@P1 datetime,@P2 char(12),@P3 char(5),@P4 datetime,@P5 char(12),@P6 char(6),@P7 int,@P8 float,@P9 char(2)', '11 26 2007 7:26PM', '200711260001', '00000', '11 26 2007 6:34PM', '200711261704', '000002', 2161, 1.200000000000000e+004, '01'
4¡¢ Õ۾ɱä¸ü
Áù¡¢ ±¨±í
1¡¢ Ã÷ϸ²éѯ
2¡¢ ²éѯͳ¼Æ
3¡¢ É豸¿¨Æ¬
Æß¡¢ ×Öµä
1¡¢ É豸Ãû³Æ
2¡¢ É豸·ÖÀà
3¡¢ ÕÛ¾ÉÀàÐÍ
4¡¢ »ù±¾×Öµä
5¡¢ ÍùÀ´µ¥Î»
6¡¢ ¿âÕʺÅ
7¡¢ ÄÚ²¿ÕʺÅ
8¡¢ ¹ú±ê·ÖÀà
°Ë¡¢ ϵͳ
1¡¢ ³õʼ»¯
2¡¢ Óû§¹ÜÀí
|
|
ÏÂÔØµØÖ· |
|
|
|
|
|