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;