case JSType.SendPrepay:
//支出
sqlis1 =
"update T_COMPACT_INFO set ci_prepay_is=1,ci_prepay_date=convert(varchar,getdate(),120),ci_prepay_man='" + UserInfo.USER_NAME +
"',ci_prepay_bank=" + (comBank.SelectedValue ??
"0") +
",ci_prepay_note='" + txtRemark.Text.Trim() +
"' where isnull(ci_prepay_is,0)=0 and ci_id=" +
fi_id;
sqlnot1 =
"update T_COMPACT_INFO set ci_prepay_is=0,ci_prepay_date=null,ci_prepay_man=null,ci_prepay_bank=null,ci_prepay_note=null where ci_prepay_is=1 and ci_id=" +
fi_id;
delType =
"发车现付";
sqlisF1 =
@"insert t_finance ([fn_kind]
,[fn_code_in]
,[fn_code_out]
,[fn_operator]
,[fn_item]
,[fn_item_son]
,[fn_price_add]
,[fn_price_sub]
,[fn_remark]
,[fn_bank_id]
,[fn_group]
,[fn_group_from]
,[fn_group_to],fn_from_id)
VALUES ('配载','','" +
this.delCode +
"','" + UserInfo.USER_NAME +
"','" +
this.delType +
"','',0,convert(numeric(18,2)," + MyControl.Text.TextToNumber(txtMoney.Text.Trim()).ToString() +
"),'" + txtRemark.Text.Trim() +
"'," + BankID +
"," + UserInfo.GROUP_ID +
"," + (
string.IsNullOrEmpty(GroupFrom) ?
"null" : GroupFrom) +
"," + (
string.IsNullOrEmpty(GroupTo) ?
"null" : GroupTo) +
"," + fi_id +
")";
sqlnotF1 =
@"insert t_finance ([fn_kind]
,[fn_code_in]
,[fn_code_out]
,[fn_operator]
,[fn_item]
,[fn_item_son]
,[fn_price_add]
,[fn_price_sub]
,[fn_delete]
,[fn_delete_remark]
,[fn_bank_id]
,[fn_group]
,[fn_group_from]
,[fn_group_to],fn_from_id)
VALUES ('配载','','" +
this.delCode +
"','" + UserInfo.USER_NAME +
"','" +
this.delType +
"','',0,convert(numeric(18,2),-" + MyControl.Text.TextToNumber(txtMoney.Text.Trim()).ToString() +
"),1,'" + txtDel.Text.Trim() +
"'," + BankID +
"," + UserInfo.GROUP_ID +
"," + (
string.IsNullOrEmpty(GroupFrom) ?
"null" : GroupFrom) +
"," + (
string.IsNullOrEmpty(GroupTo) ?
"null" : GroupTo) +
"," + fi_id +
")";
break;
case JSType.SendPrepay2:
//支出
sqlis1 =
"update T_COMPACT_INFO set ci_prepay_is=1,ci_prepay_date=convert(varchar,getdate(),120),ci_prepay_man='" + UserInfo.USER_NAME +
"',ci_prepay_bank=" + (comBank.SelectedValue ??
"0") +
",ci_prepay_note='" + txtRemark.Text.Trim() +
"' where isnull(ci_prepay_is,0)=0 and ci_id=" +
fi_id;
sqlnot1 =
"update T_COMPACT_INFO set ci_prepay_is=0,ci_prepay_date=null,ci_prepay_man=null,ci_prepay_bank=null,ci_prepay_note=null where ci_prepay_is=1 and ci_id=" +
fi_id;
delType =
"发车已付";
sqlisF1 =
@"insert t_finance ([fn_kind]
,[fn_code_in]
,[fn_code_out]
,[fn_operator]
,[fn_item]
,[fn_item_son]
,[fn_price_add]
,[fn_price_sub]
,[fn_remark]
,[fn_bank_id]
,[fn_group]
,[fn_group_from]
,[fn_group_to],fn_from_id)
VALUES ('同行发货','','" +
this.delCode +
"','" + UserInfo.USER_NAME +
"','" +
this.delType +
"','',0,convert(numeric(18,2)," + MyControl.Text.TextToNumber(txtMoney.Text.Trim()).ToString() +
"),'" + txtRemark.Text.Trim() +
"'," + BankID +
"," + UserInfo.GROUP_ID +
"," + (
string.IsNullOrEmpty(GroupFrom) ?
"null" : GroupFrom) +
"," + (
string.IsNullOrEmpty(GroupTo) ?
"null" : GroupTo) +
"," + fi_id +
")";
sqlnotF1 =
@"insert t_finance ([fn_kind]
,[fn_code_in]
,[fn_code_out]
,[fn_operator]
,[fn_item]
,[fn_item_son]
,[fn_price_add]
,[fn_price_sub]
,[fn_delete]
,[fn_delete_remark]
,[fn_bank_id]
,[fn_group]
,[fn_group_from]
,[fn_group_to],fn_from_id)
VALUES ('同行发货','','" +
this.delCode +
"','" + UserInfo.USER_NAME +
"','" +
this.delType +
"','',0,convert(numeric(18,2),-" + MyControl.Text.TextToNumber(txtMoney.Text.Trim()).ToString() +
"),1,'" + txtDel.Text.Trim() +
"'," + BankID +
"," + UserInfo.GROUP_ID +
"," + (
string.IsNullOrEmpty(GroupFrom) ?
"null" : GroupFrom) +
"," + (
string.IsNullOrEmpty(GroupTo) ?
"null" : GroupTo) +
"," + fi_id +
")";
break;
转载于:https://www.cnblogs.com/goto/archive/2012/04/12/2443668.html
相关资源：数据结构—成绩单生成器
