/// <summary>
/// 增加一条数据
/// </summary>
public string Add(TH.clsU8.Model.Ap_CloseBill model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.cVouchType != null)
{
strSql1.Append("cVouchType,");
strSql2.Append("'" + model.cVouchType + "',");
}
if (model.cVouchID != null)
{
strSql1.Append("cVouchID,");
strSql2.Append("'" + model.cVouchID + "',");
}
if (model.dVouchDate != null)
{
strSql1.Append("dVouchDate,");
strSql2.Append("'" + model.dVouchDate + "',");
}
if (model.iPeriod != null)
{
strSql1.Append("iPeriod,");
strSql2.Append("" + model.iPeriod + ",");
}
if (model.cDwCode != null)
{
strSql1.Append("cDwCode,");
strSql2.Append("'" + model.cDwCode + "',");
}
if (model.cDeptCode != null)
{
strSql1.Append("cDeptCode,");
strSql2.Append("'" + model.cDeptCode + "',");
}
if (model.cPerson != null)
{
strSql1.Append("cPerson,");
strSql2.Append("'" + model.cPerson + "',");
}
if (model.cItem_Class != null)
{
strSql1.Append("cItem_Class,");
strSql2.Append("'" + model.cItem_Class + "',");
}
if (model.cItemCode != null)
{
strSql1.Append("cItemCode,");
strSql2.Append("'" + model.cItemCode + "',");
}
if (model.cSSCode != null)
{
strSql1.Append("cSSCode,");
strSql2.Append("'" + model.cSSCode + "',");
}
if (model.cNoteNo != null)
{
strSql1.Append("cNoteNo,");
strSql2.Append("'" + model.cNoteNo + "',");
}
if (model.cCoVouchType != null)
{
strSql1.Append("cCoVouchType,");
strSql2.Append("'" + model.cCoVouchType + "',");
}
if (model.cCoVouchID != null)
{
strSql1.Append("cCoVouchID,");
strSql2.Append("'" + model.cCoVouchID + "',");
}
if (model.cDigest != null)
{
strSql1.Append("cDigest,");
strSql2.Append("'" + model.cDigest + "',");
}
if (model.cBankAccount != null)
{
strSql1.Append("cBankAccount,");
strSql2.Append("'" + model.cBankAccount + "',");
}
if (model.cexch_name != null)
{
strSql1.Append("cexch_name,");
strSql2.Append("'" + model.cexch_name + "',");
}
if (model.iExchRate != null)
{
strSql1.Append("iExchRate,");
strSql2.Append("" + model.iExchRate + ",");
}
if (model.iAmount != null)
{
strSql1.Append("iAmount,");
strSql2.Append("" + model.iAmount + ",");
}
if (model.iAmount_f != null)
{
strSql1.Append("iAmount_f,");
strSql2.Append("" + model.iAmount_f + ",");
}
if (model.iRAmount != null)
{
strSql1.Append("iRAmount,");
strSql2.Append("" + model.iRAmount + ",");
}
if (model.iRAmount_f != null)
{
strSql1.Append("iRAmount_f,");
strSql2.Append("" + model.iRAmount_f + ",");
}
if (model.cOperator != null)
{
strSql1.Append("cOperator,");
strSql2.Append("'" + model.cOperator + "',");
}
if (model.cCancelMan != null)
{
strSql1.Append("cCancelMan,");
strSql2.Append("'" + model.cCancelMan + "',");
}
if (model.cRPMan != null)
{
strSql1.Append("cRPMan,");
strSql2.Append("'" + model.cRPMan + "',");
}
if (model.bPrePay != null)
{
strSql1.Append("bPrePay,");
strSql2.Append("" + (model.bPrePay ? 1 : 0) + ",");
}
if (model.bStartFlag != null)
{
strSql1.Append("bStartFlag,");
strSql2.Append("" + (model.bStartFlag ? 1 : 0) + ",");
}
if (model.cOrderNo != null)
{
strSql1.Append("cOrderNo,");
strSql2.Append("'" + model.cOrderNo + "',");
}
if (model.cCode != null)
{
strSql1.Append("cCode,");
strSql2.Append("'" + model.cCode + "',");
}
if (model.cPreCode != null)
{
strSql1.Append("cPreCode,");
strSql2.Append("'" + model.cPreCode + "',");
}
if (model.iPayForOther != null)
{
strSql1.Append("iPayForOther,");
strSql2.Append("" + (model.iPayForOther ? 1 : 0) + ",");
}
if (model.cSrcFlag != null)
{
strSql1.Append("cSrcFlag,");
strSql2.Append("'" + model.cSrcFlag + "',");
}
if (model.cPzID != null)
{
strSql1.Append("cPzID,");
strSql2.Append("'" + model.cPzID + "',");
}
if (model.cFlag != null)
{
strSql1.Append("cFlag,");
strSql2.Append("'" + model.cFlag + "',");
}
if (model.bSend != null)
{
strSql1.Append("bSend,");
strSql2.Append("" + (model.bSend ? 1 : 0) + ",");
}
if (model.bReceived != null)
{
strSql1.Append("bReceived,");
strSql2.Append("" + (model.bReceived ? 1 : 0) + ",");
}
if (model.csItemCode != null)
{
strSql1.Append("csItemCode,");
strSql2.Append("'" + model.csItemCode + "',");
}
if (model.iID != null)
{
strSql1.Append("iID,");
strSql2.Append("" + model.iID + ",");
}
if (model.cCancelNo != null)
{
strSql1.Append("cCancelNo,");
strSql2.Append("'" + model.cCancelNo + "',");
}
if (model.cBank != null)
{
strSql1.Append("cBank,");
strSql2.Append("'" + model.cBank + "',");
}
if (model.cNatBank != null)
{
strSql1.Append("cNatBank,");
strSql2.Append("'" + model.cNatBank + "',");
}
if (model.cNatBankAccount != null)
{
strSql1.Append("cNatBankAccount,");
strSql2.Append("'" + model.cNatBankAccount + "',");
}
if (model.bFromBank != null)
{
strSql1.Append("bFromBank,");
strSql2.Append("" + (model.bFromBank ? 1 : 0) + ",");
}
if (model.bToBank != null)
{
strSql1.Append("bToBank,");
strSql2.Append("" + (model.bToBank ? 1 : 0) + ",");
}
if (model.bSure != null)
{
strSql1.Append("bSure,");
strSql2.Append("" + (model.bSure ? 1 : 0) + ",");
}
if (model.VT_ID != null)
{
strSql1.Append("VT_ID,");
strSql2.Append("" + model.VT_ID + ",");
}
if (model.cCheckMan != null)
{
strSql1.Append("cCheckMan,");
strSql2.Append("'" + model.cCheckMan + "',");
}
if (model.cDefine1 != null)
{
strSql1.Append("cDefine1,");
strSql2.Append("'" + model.cDefine1 + "',");
}
if (model.cDefine2 != null)
{
strSql1.Append("cDefine2,");
strSql2.Append("'" + model.cDefine2 + "',");
}
if (model.cDefine3 != null)
{
strSql1.Append("cDefine3,");
strSql2.Append("'" + model.cDefine3 + "',");
}
if (model.cDefine4 != null)
{
strSql1.Append("cDefine4,");
strSql2.Append("'" + model.cDefine4 + "',");
}
if (model.cDefine5 != null)
{
strSql1.Append("cDefine5,");
strSql2.Append("" + model.cDefine5 + ",");
}
if (model.cDefine6 != null)
{
strSql1.Append("cDefine6,");
strSql2.Append("'" + model.cDefine6 + "',");
}
if (model.cDefine7 != null)
{
strSql1.Append("cDefine7,");
strSql2.Append("" + model.cDefine7 + ",");
}
if (model.cDefine8 != null)
{
strSql1.Append("cDefine8,");
strSql2.Append("'" + model.cDefine8 + "',");
}
if (model.cDefine9 != null)
{
strSql1.Append("cDefine9,");
strSql2.Append("'" + model.cDefine9 + "',");
}
if (model.cDefine10 != null)
{
strSql1.Append("cDefine10,");
strSql2.Append("'" + model.cDefine10 + "',");
}
if (model.cDefine11 != null)
{
strSql1.Append("cDefine11,");
strSql2.Append("'" + model.cDefine11 + "',");
}
if (model.cDefine12 != null)
{
strSql1.Append("cDefine12,");
strSql2.Append("'" + model.cDefine12 + "',");
}
if (model.cDefine13 != null)
{
strSql1.Append("cDefine13,");
strSql2.Append("'" + model.cDefine13 + "',");
}
if (model.cDefine14 != null)
{
strSql1.Append("cDefine14,");
strSql2.Append("'" + model.cDefine14 + "',");
}
if (model.cDefine15 != null)
{
strSql1.Append("cDefine15,");
strSql2.Append("" + model.cDefine15 + ",");
}
if (model.cDefine16 != null)
{
strSql1.Append("cDefine16,");
strSql2.Append("" + model.cDefine16 + ",");
}
if (model.Ufts != null)
{
strSql1.Append("Ufts,");
strSql2.Append("" + model.Ufts + ",");
}
if (model.cItemName != null)
{
strSql1.Append("cItemName,");
strSql2.Append("'" + model.cItemName + "',");
}
if (model.cContractType != null)
{
strSql1.Append("cContractType,");
strSql2.Append("'" + model.cContractType + "',");
}
if (model.cContractID != null)
{
strSql1.Append("cContractID,");
strSql2.Append("'" + model.cContractID + "',");
}
if (model.iAmount_s != null)
{
strSql1.Append("iAmount_s,");
strSql2.Append("" + model.iAmount_s + ",");
}
if (model.IsWfControlled != null)
{
strSql1.Append("IsWfControlled,");
strSql2.Append("" + (model.IsWfControlled ? 1 : 0) + ",");
}
if (model.iSource != null)
{
strSql1.Append("iSource,");
strSql2.Append("" + model.iSource + ",");
}
if (model.sDLCode != null)
{
strSql1.Append("sDLCode,");
strSql2.Append("'" + model.sDLCode + "',");
}
if (model.RegisterFlag != null)
{
strSql1.Append("RegisterFlag,");
strSql2.Append("" + model.RegisterFlag + ",");
}
if (model.iverifystate != null)
{
strSql1.Append("iverifystate,");
strSql2.Append("" + model.iverifystate + ",");
}
if (model.ireturncount != null)
{
strSql1.Append("ireturncount,");
strSql2.Append("" + model.ireturncount + ",");
}
if (model.dcreatesystime != null)
{
strSql1.Append("dcreatesystime,");
strSql2.Append("'" + model.dcreatesystime + "',");
}
if (model.dverifysystime != null)
{
strSql1.Append("dverifysystime,");
strSql2.Append("'" + model.dverifysystime + "',");
}
if (model.dmodifysystime != null)
{
strSql1.Append("dmodifysystime,");
strSql2.Append("'" + model.dmodifysystime + "',");
}
if (model.cmodifier != null)
{
strSql1.Append("cmodifier,");
strSql2.Append("'" + model.cmodifier + "',");
}
if (model.dmoddate != null)
{
strSql1.Append("dmoddate,");
strSql2.Append("'" + model.dmoddate + "',");
}
if (model.dverifydate != null)
{
strSql1.Append("dverifydate,");
strSql2.Append("'" + model.dverifydate + "',");
}
if (model.ibg_overflag != null)
{
strSql1.Append("ibg_overflag,");
strSql2.Append("" + model.ibg_overflag + ",");
}
if (model.cbg_auditor != null)
{
strSql1.Append("cbg_auditor,");
strSql2.Append("'" + model.cbg_auditor + "',");
}
if (model.cbg_audittime != null)
{
strSql1.Append("cbg_audittime,");
strSql2.Append("'" + model.cbg_audittime + "',");
}
if (model.controlresult != null)
{
strSql1.Append("controlresult,");
strSql2.Append("" + model.controlresult + ",");
}
if (model.cbg_itemcode != null)
{
strSql1.Append("cbg_itemcode,");
strSql2.Append("'" + model.cbg_itemcode + "',");
}
if (model.cbg_itemname != null)
{
strSql1.Append("cbg_itemname,");
strSql2.Append("'" + model.cbg_itemname + "',");
}
if (model.cbg_caliberkey1 != null)
{
strSql1.Append("cbg_caliberkey1,");
strSql2.Append("'" + model.cbg_caliberkey1 + "',");
}
if (model.cbg_caliberkeyname1 != null)
{
strSql1.Append("cbg_caliberkeyname1,");
strSql2.Append("'" + model.cbg_caliberkeyname1 + "',");
}
if (model.cbg_caliberkey2 != null)
{
strSql1.Append("cbg_caliberkey2,");
strSql2.Append("'" + model.cbg_caliberkey2 + "',");
}
if (model.cbg_caliberkeyname2 != null)
{
strSql1.Append("cbg_caliberkeyname2,");
strSql2.Append("'" + model.cbg_caliberkeyname2 + "',");
}
if (model.cbg_caliberkey3 != null)
{
strSql1.Append("cbg_caliberkey3,");
strSql2.Append("'" + model.cbg_caliberkey3 + "',");
}
if (model.cbg_caliberkeyname3 != null)
{
strSql1.Append("cbg_caliberkeyname3,");
strSql2.Append("'" + model.cbg_caliberkeyname3 + "',");
}
if (model.cbg_calibercode1 != null)
{
strSql1.Append("cbg_calibercode1,");
strSql2.Append("'" + model.cbg_calibercode1 + "',");
}
if (model.cbg_calibername1 != null)
{
strSql1.Append("cbg_calibername1,");
strSql2.Append("'" + model.cbg_calibername1 + "',");
}
if (model.cbg_calibercode2 != null)
{
strSql1.Append("cbg_calibercode2,");
strSql2.Append("'" + model.cbg_calibercode2 + "',");
}
if (model.cbg_calibername2 != null)
{
strSql1.Append("cbg_calibername2,");
strSql2.Append("'" + model.cbg_calibername2 + "',");
}
if (model.cbg_calibercode3 != null)
{
strSql1.Append("cbg_calibercode3,");
strSql2.Append("'" + model.cbg_calibercode3 + "',");
}
if (model.cbg_calibername3 != null)
{
strSql1.Append("cbg_calibername3,");
strSql2.Append("'" + model.cbg_calibername3 + "',");
}
if (model.ibg_ctrl != null)
{
strSql1.Append("ibg_ctrl,");
strSql2.Append("" + (model.ibg_ctrl ? 1 : 0) + ",");
}
if (model.cbg_auditopinion != null)
{
strSql1.Append("cbg_auditopinion,");
strSql2.Append("'" + model.cbg_auditopinion + "',");
}
if (model.cApplyCode != null)
{
strSql1.Append("cApplyCode,");
strSql2.Append("'" + model.cApplyCode + "',");
}
if (model.cPZNum != null)
{
strSql1.Append("cPZNum,");
strSql2.Append("'" + model.cPZNum + "',");
}
if (model.doutbilldate != null)
{
strSql1.Append("doutbilldate,");
strSql2.Append("'" + model.doutbilldate + "',");
}
if (model.cbg_caliberkey4 != null)
{
strSql1.Append("cbg_caliberkey4,");
strSql2.Append("'" + model.cbg_caliberkey4 + "',");
}
if (model.cbg_caliberkeyname4 != null)
{
strSql1.Append("cbg_caliberkeyname4,");
strSql2.Append("'" + model.cbg_caliberkeyname4 + "',");
}
if (model.cbg_caliberkey5 != null)
{
strSql1.Append("cbg_caliberkey5,");
strSql2.Append("'" + model.cbg_caliberkey5 + "',");
}
if (model.cbg_caliberkeyname5 != null)
{
strSql1.Append("cbg_caliberkeyname5,");
strSql2.Append("'" + model.cbg_caliberkeyname5 + "',");
}
if (model.cbg_caliberkey6 != null)
{
strSql1.Append("cbg_caliberkey6,");
strSql2.Append("'" + model.cbg_caliberkey6 + "',");
}
if (model.cbg_caliberkeyname6 != null)
{
strSql1.Append("cbg_caliberkeyname6,");
strSql2.Append("'" + model.cbg_caliberkeyname6 + "',");
}
if (model.cbg_calibercode4 != null)
{
strSql1.Append("cbg_calibercode4,");
strSql2.Append("'" + model.cbg_calibercode4 + "',");
}
if (model.cbg_calibername4 != null)
{
strSql1.Append("cbg_calibername4,");
strSql2.Append("'" + model.cbg_calibername4 + "',");
}
if (model.cbg_calibercode5 != null)
{
strSql1.Append("cbg_calibercode5,");
strSql2.Append("'" + model.cbg_calibercode5 + "',");
}
if (model.cbg_calibername5 != null)
{
strSql1.Append("cbg_calibername5,");
strSql2.Append("'" + model.cbg_calibername5 + "',");
}
if (model.cbg_calibercode6 != null)
{
strSql1.Append("cbg_calibercode6,");
strSql2.Append("'" + model.cbg_calibercode6 + "',");
}
if (model.cbg_calibername6 != null)
{
strSql1.Append("cbg_calibername6,");
strSql2.Append("'" + model.cbg_calibername6 + "',");
}
if (model.iPrintCount != null)
{
strSql1.Append("iPrintCount,");
strSql2.Append("" + model.iPrintCount + ",");
}
if (model.cReserveDeptCode != null)
{
strSql1.Append("cReserveDeptCode,");
strSql2.Append("'" + model.cReserveDeptCode + "',");
}
if (model.bDealMode != null)
{
strSql1.Append("bDealMode,");
strSql2.Append("" + (model.bDealMode ? 1 : 0) + ",");
}
if (model.iBusType != null)
{
strSql1.Append("iBusType,");
strSql2.Append("" + model.iBusType + ",");
}
if (model.iPayType != null)
{
strSql1.Append("iPayType,");
strSql2.Append("" + model.iPayType + ",");
}
if (model.cagentcuscode != null)
{
strSql1.Append("cagentcuscode,");
strSql2.Append("'" + model.cagentcuscode + "',");
}
if (model.csysbarcode != null)
{
strSql1.Append("csysbarcode,");
strSql2.Append("'" + model.csysbarcode + "',");
}
if (model.cCurrentAuditor != null)
{
strSql1.Append("cCurrentAuditor,");
strSql2.Append("'" + model.cCurrentAuditor + "',");
}
strSql.Append("insert into Ap_CloseBill(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
return(strSql.ToString());
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
gridView1.PostEditor();
string sErr = "";
int iCount = 0;
SqlConnection conn = new SqlConnection(sConnString);
conn.Open();
//启用事务
SqlTransaction tran = conn.BeginTransaction();
string sSQL = "";
try
{
////获得单据号
//sSQL = "select max(cNumber) as Maxnumber From VoucherHistory with (ROWLOCK) Where CardNumber='RR' and cContent is NULL";
//dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
//long lCode = 0;
//if (dt != null && dt.Rows.Count > 0)
//{
// lCode = BaseFunction.ReturnLong(dt.Rows[0]["Maxnumber"]);
//}
//else
//{
// lCode = 0;
//}
long lID = -1;
long lIDDetails = -1;
sSQL = @"
declare @p5 int
set @p5=aaaaaa
declare @p6 int
set @p6=bbbbbb
exec sp_GetId N'00',N'dddddd',N'SK',cccccc,@p5 output,@p6 output,default
select @p5, @p6
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
sSQL = sSQL.Replace("bbbbbb", lIDDetails.ToString());
sSQL = sSQL.Replace("cccccc", 1.ToString());
sSQL = sSQL.Replace("dddddd", s数据库.Substring(7, 3));
DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
lID = BaseFunction.ReturnLong(dt.Rows[0][0]) - 1;
lIDDetails = BaseFunction.ReturnLong(dt.Rows[0][1]) - 1;
ArrayList aList = new ArrayList();
for (int i = 0; i < gridView1.RowCount; i++)
{
if (!BaseFunction.ReturnBool(gridView1.GetRowCellValue(i, gridColchoose)))
{
continue;
}
bool bExists = false;
string sDocumentNo = gridView1.GetRowCellValue(i, gridColDocumentNo).ToString().Trim();
for (int j = 0; j < aList.Count; j++)
{
if (sDocumentNo == aList[j].ToString().Trim())
{
bExists = true;
break;
}
}
if (bExists)
{
continue;
}
aList.Add(sDocumentNo);
DateTime dDate = BaseFunction.ReturnDate(gridView1.GetRowCellValue(i, gridColDate));
sSQL = "select isnull(bflag_AR,0) as bflag from GL_mend where iYPeriod = '" + dDate.ToString("yyyyMM") + "'";
dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dt == null || dt.Rows.Count == 0)
{
sErr = sErr + "Row " + (i + 1).ToString() + " access module state failure\n";
continue;
}
int i结账 = BaseFunction.ReturnInt(dt.Rows[0]["bflag"]);
if (i结账 > 0)
{
sErr = sErr + "Row " + (i + 1).ToString() + " date is err\n";
continue;
}
sSQL = "select count(1) from Ap_CloseBills where isnull(cDefine22,'') = 'aaaaaa'";
sSQL = sSQL.Replace("aaaaaa", sDocumentNo);
DataTable dtDoc = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dtDoc != null && dtDoc.Rows.Count > 0 && BaseFunction.ReturnInt(dtDoc.Rows[0][0]) > 0)
{
sErr = sErr + "row " + i.ToString() + " Document No. is exists err\n";
continue;
}
//lCode += 1;
//string sCode = lCode.ToString();
//while (sCode.Length < 10)
//{
// sCode = "0" + sCode;
//}
lID += 1;
TH.clsU8.Model.Ap_CloseBill model = new TH.clsU8.Model.Ap_CloseBill();
model.cVouchType = "48";
model.cVouchID = sDocumentNo;
model.dVouchDate = BaseFunction.ReturnDate(dDate.ToString("yyyy-MM-dd"));
model.iPeriod = model.dVouchDate.Month - 3;
if (model.iPeriod <= 0)
{
model.iPeriod = model.iPeriod + 12;
}
sSQL = "select * from Customer where isnull(cCusDefine2,'') = '" + gridView1.GetRowCellValue(i, gridColGMCVCode).ToString().Trim() + "'";
DataTable dtCus = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dtCus == null || dtCus.Rows.Count == 0)
{
sErr = sErr + "row " + i.ToString() + "GMCV Code is not exists err\n";
continue;
}
model.cDwCode = dtCus.Rows[0]["cCusCode"].ToString().Trim();
model.cSSCode = "1"; //需要默认值
sSQL = "select * from foreigncurrency where cexch_name = 'aaaaaa' or cexch_code = 'aaaaaa'";
sSQL = sSQL.Replace("aaaaaa", gridView1.GetRowCellValue(i, gridColCurency).ToString().Trim());
DataTable dtForeigncurrency = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dtForeigncurrency == null || dtForeigncurrency.Rows.Count == 0)
{
sErr = sErr + "row " + i.ToString() + "Curency is not exists err\n";
continue;
}
model.cexch_name = dtForeigncurrency.Rows[0]["cexch_name"].ToString().Trim();
model.iExchRate = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColExchangeRate));
if (model.iExchRate == 0)
{
sErr = sErr + "row " + i.ToString() + " Please set Exchange Rate\n";
continue;
}
model.cOperator = sUserName;
model.bPrePay = false;
model.bStartFlag = false;
model.iPayForOther = false;
model.cFlag = "AR";
model.bSend = false;
model.bReceived = false;
model.iID = lID;
model.bFromBank = false;
model.bToBank = false;
model.bSure = false;
model.VT_ID = 8052;
model.iAmount = 0;
model.IsWfControlled = false;
model.RegisterFlag = 0;
model.dcreatesystime = DateTime.Now;
model.ibg_ctrl = false;
model.ibg_ctrl = false;
model.iPrintCount = 0;
model.iPayForOther = false;
model.iAmount_s = 0;
decimal d本币 = 0;
decimal d原币 = 0;
ArrayList aListDetails = new ArrayList();
for (int j = i; j < gridView1.RowCount; j++)
{
string sDocumentNo2 = gridView1.GetRowCellValue(j, gridColDocumentNo).ToString().Trim();
if (sDocumentNo != sDocumentNo2)
{
continue;
}
TH.clsU8.Model.Ap_CloseBills models = new TH.clsU8.Model.Ap_CloseBills();
models.iID = model.iID;
lIDDetails += 1;
models.ID = lIDDetails;
models.iType = 0;
models.bPrePay = false;
models.cCusVen = model.cDwCode;
models.iAmt_f = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(j, gridColOriginal));
models.iRAmt_f = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(j, gridColOriginal));
d原币 = d原币 + models.iAmt_f;
models.iAmt = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(j, gridColLocalAMT));
models.iRAmt = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(j, gridColLocalAMT));
d本币 = d本币 + models.iAmt;
models.iAmt_s = 0;
models.RegisterFlag = 0;
models.iSrcClosesID = 0;
models.ifaresettled_f = 0;
models.cMemo = gridView1.GetRowCellValue(j, gridColDiscription).ToString().Trim();
models.cDefine22 = gridView1.GetRowCellValue(j, gridColDocumentNo).ToString().Trim();
models.cDefine23 = gridView1.GetRowCellValue(j, gridColInvoiceNo).ToString().Trim();
models.iRAmt_s = 0;
TH.clsU8.DAL.Ap_CloseBills dals = new TH.clsU8.DAL.Ap_CloseBills();
sSQL = dals.Add(models);
aListDetails.Add(sSQL);
}
model.iAmount = d本币;
model.iAmount_f = d原币;
model.iRAmount = d本币;
model.iRAmount_f = d原币;
TH.clsU8.DAL.Ap_CloseBill dal = new TH.clsU8.DAL.Ap_CloseBill();
sSQL = dal.Add(model);
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
for (int ii = 0; ii < aListDetails.Count; ii++)
{
iCount = iCount + DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, aListDetails[ii].ToString());
}
}
if (sErr != "")
{
throw new Exception(sErr);
}
if (lID > 1000000000)
{
lID = lID - 1000000000;
}
if (lIDDetails > 1000000000)
{
lIDDetails = lIDDetails - 1000000000;
}
sSQL = "update UFSystem..UA_Identity set iFatherId = " + lID.ToString() + ",iChildId = " + lIDDetails + " where cAcc_Id = '" + s数据库.Substring(7, 3) + "' and cVouchType = 'SK'";
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
// sSQL = @"
//if exists(select * from VoucherHistory where CardNumber='RR' and cContent is NULL)
// update VoucherHistory set cNumber = aaaaaa where CardNumber='RR' and cContent is NULL
//else
// insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)
// values('RR',null,null,null,'aaaaaa',0)
//";
// sSQL = sSQL.Replace("aaaaaa", lCode.ToString());
// DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
if (iCount > 0)
{
tran.Commit();
MessageBox.Show("OK\n");
}
else
{
throw new Exception("Save failed");
}
}
catch (Exception error)
{
tran.Rollback();
throw new Exception(error.Message);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
