/// <summary>
/// 增加一条数据
/// </summary>
public string Add(TH.clsU8.Model.RdRecord09 model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.ID != null)
{
strSql1.Append("ID,");
strSql2.Append("" + model.ID + ",");
}
if (model.bRdFlag != null)
{
strSql1.Append("bRdFlag,");
strSql2.Append("" + model.bRdFlag + ",");
}
if (model.cVouchType != null)
{
strSql1.Append("cVouchType,");
strSql2.Append("'" + model.cVouchType + "',");
}
if (model.cBusType != null)
{
strSql1.Append("cBusType,");
strSql2.Append("'" + model.cBusType + "',");
}
if (model.cSource != null)
{
strSql1.Append("cSource,");
strSql2.Append("'" + model.cSource + "',");
}
if (model.cBusCode != null)
{
strSql1.Append("cBusCode,");
strSql2.Append("'" + model.cBusCode + "',");
}
if (model.cWhCode != null)
{
strSql1.Append("cWhCode,");
strSql2.Append("'" + model.cWhCode + "',");
}
if (model.dDate != null)
{
strSql1.Append("dDate,");
strSql2.Append("'" + model.dDate + "',");
}
if (model.cCode != null)
{
strSql1.Append("cCode,");
strSql2.Append("'" + model.cCode + "',");
}
if (model.cRdCode != null)
{
strSql1.Append("cRdCode,");
strSql2.Append("'" + model.cRdCode + "',");
}
if (model.cDepCode != null)
{
strSql1.Append("cDepCode,");
strSql2.Append("'" + model.cDepCode + "',");
}
if (model.cPersonCode != null)
{
strSql1.Append("cPersonCode,");
strSql2.Append("'" + model.cPersonCode + "',");
}
if (model.cPTCode != null)
{
strSql1.Append("cPTCode,");
strSql2.Append("'" + model.cPTCode + "',");
}
if (model.cSTCode != null)
{
strSql1.Append("cSTCode,");
strSql2.Append("'" + model.cSTCode + "',");
}
if (model.cCusCode != null)
{
strSql1.Append("cCusCode,");
strSql2.Append("'" + model.cCusCode + "',");
}
if (model.cVenCode != null)
{
strSql1.Append("cVenCode,");
strSql2.Append("'" + model.cVenCode + "',");
}
if (model.cOrderCode != null)
{
strSql1.Append("cOrderCode,");
strSql2.Append("'" + model.cOrderCode + "',");
}
if (model.cARVCode != null)
{
strSql1.Append("cARVCode,");
strSql2.Append("'" + model.cARVCode + "',");
}
if (model.cBillCode != null)
{
strSql1.Append("cBillCode,");
strSql2.Append("" + model.cBillCode + ",");
}
if (model.cDLCode != null)
{
strSql1.Append("cDLCode,");
strSql2.Append("" + model.cDLCode + ",");
}
if (model.cProBatch != null)
{
strSql1.Append("cProBatch,");
strSql2.Append("'" + model.cProBatch + "',");
}
if (model.cHandler != null)
{
strSql1.Append("cHandler,");
strSql2.Append("'" + model.cHandler + "',");
}
if (model.cMemo != null)
{
strSql1.Append("cMemo,");
strSql2.Append("'" + model.cMemo + "',");
}
if (model.bTransFlag != null)
{
strSql1.Append("bTransFlag,");
strSql2.Append("" + (model.bTransFlag ? 1 : 0) + ",");
}
if (model.cAccounter != null)
{
strSql1.Append("cAccounter,");
strSql2.Append("'" + model.cAccounter + "',");
}
if (model.cMaker != null)
{
strSql1.Append("cMaker,");
strSql2.Append("'" + model.cMaker + "',");
}
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.dKeepDate != null)
{
strSql1.Append("dKeepDate,");
strSql2.Append("'" + model.dKeepDate + "',");
}
if (model.dVeriDate != null)
{
strSql1.Append("dVeriDate,");
strSql2.Append("'" + model.dVeriDate + "',");
}
if (model.bpufirst != null)
{
strSql1.Append("bpufirst,");
strSql2.Append("" + (model.bpufirst ? 1 : 0) + ",");
}
if (model.biafirst != null)
{
strSql1.Append("biafirst,");
strSql2.Append("" + (model.biafirst ? 1 : 0) + ",");
}
if (model.iMQuantity != null)
{
strSql1.Append("iMQuantity,");
strSql2.Append("" + model.iMQuantity + ",");
}
if (model.dARVDate != null)
{
strSql1.Append("dARVDate,");
strSql2.Append("'" + model.dARVDate + "',");
}
if (model.cChkCode != null)
{
strSql1.Append("cChkCode,");
strSql2.Append("'" + model.cChkCode + "',");
}
if (model.dChkDate != null)
{
strSql1.Append("dChkDate,");
strSql2.Append("'" + model.dChkDate + "',");
}
if (model.cChkPerson != null)
{
strSql1.Append("cChkPerson,");
strSql2.Append("'" + model.cChkPerson + "',");
}
if (model.VT_ID != null)
{
strSql1.Append("VT_ID,");
strSql2.Append("" + model.VT_ID + ",");
}
if (model.bIsSTQc != null)
{
strSql1.Append("bIsSTQc,");
strSql2.Append("" + (model.bIsSTQc ? 1 : 0) + ",");
}
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.gspcheck != null)
{
strSql1.Append("gspcheck,");
strSql2.Append("'" + model.gspcheck + "',");
}
if (model.ufts != null)
{
strSql1.Append("ufts,");
strSql2.Append("" + model.ufts + ",");
}
if (model.iExchRate != null)
{
strSql1.Append("iExchRate,");
strSql2.Append("" + model.iExchRate + ",");
}
if (model.cExch_Name != null)
{
strSql1.Append("cExch_Name,");
strSql2.Append("'" + model.cExch_Name + "',");
}
if (model.cShipAddress != null)
{
strSql1.Append("cShipAddress,");
strSql2.Append("'" + model.cShipAddress + "',");
}
if (model.caddcode != null)
{
strSql1.Append("caddcode,");
strSql2.Append("'" + model.caddcode + "',");
}
if (model.bOMFirst != null)
{
strSql1.Append("bOMFirst,");
strSql2.Append("" + (model.bOMFirst ? 1 : 0) + ",");
}
if (model.bFromPreYear != null)
{
strSql1.Append("bFromPreYear,");
strSql2.Append("" + (model.bFromPreYear ? 1 : 0) + ",");
}
if (model.bIsLsQuery != null)
{
strSql1.Append("bIsLsQuery,");
strSql2.Append("" + (model.bIsLsQuery ? 1 : 0) + ",");
}
if (model.bIsComplement != null)
{
strSql1.Append("bIsComplement,");
strSql2.Append("" + model.bIsComplement + ",");
}
if (model.iDiscountTaxType != null)
{
strSql1.Append("iDiscountTaxType,");
strSql2.Append("" + model.iDiscountTaxType + ",");
}
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.ireturncount != null)
{
strSql1.Append("ireturncount,");
strSql2.Append("" + model.ireturncount + ",");
}
if (model.iverifystate != null)
{
strSql1.Append("iverifystate,");
strSql2.Append("" + model.iverifystate + ",");
}
if (model.iswfcontrolled != null)
{
strSql1.Append("iswfcontrolled,");
strSql2.Append("" + model.iswfcontrolled + ",");
}
if (model.cModifyPerson != null)
{
strSql1.Append("cModifyPerson,");
strSql2.Append("'" + model.cModifyPerson + "',");
}
if (model.dModifyDate != null)
{
strSql1.Append("dModifyDate,");
strSql2.Append("'" + model.dModifyDate + "',");
}
if (model.dnmaketime != null)
{
strSql1.Append("dnmaketime,");
strSql2.Append("'" + model.dnmaketime + "',");
}
if (model.dnmodifytime != null)
{
strSql1.Append("dnmodifytime,");
strSql2.Append("'" + model.dnmodifytime + "',");
}
if (model.dnverifytime != null)
{
strSql1.Append("dnverifytime,");
strSql2.Append("'" + model.dnverifytime + "',");
}
if (model.bredvouch != null)
{
strSql1.Append("bredvouch,");
strSql2.Append("" + model.bredvouch + ",");
}
if (model.iFlowId != null)
{
strSql1.Append("iFlowId,");
strSql2.Append("" + model.iFlowId + ",");
}
if (model.cPZID != null)
{
strSql1.Append("cPZID,");
strSql2.Append("'" + model.cPZID + "',");
}
if (model.cSourceLs != null)
{
strSql1.Append("cSourceLs,");
strSql2.Append("'" + model.cSourceLs + "',");
}
if (model.cSourceCodeLs != null)
{
strSql1.Append("cSourceCodeLs,");
strSql2.Append("'" + model.cSourceCodeLs + "',");
}
if (model.iPrintCount != null)
{
strSql1.Append("iPrintCount,");
strSql2.Append("" + model.iPrintCount + ",");
}
if (model.ctransflag != null)
{
strSql1.Append("ctransflag,");
strSql2.Append("'" + model.ctransflag + "',");
}
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 RdRecord09(");
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
{
string sErr = "";
int iCount = 0;
SqlConnection conn = new SqlConnection(sConnString);
conn.Open();
//启用事务
SqlTransaction tran = conn.BeginTransaction();
string sSQL = "";
try
{
string s采购订单号 = gridView1.GetRowCellValue(0, gridColcPOID).ToString().Trim();
sSQL = @"
select a.cPOID
from PO_PoMain a inner join PO_Podetails b on a.POID = b.POID
inner join RdRecord09 c on b.cDefine33 = c.cCode
and a.cPOID = '111111'
";
sSQL = sSQL.Replace("111111", s采购订单号);
DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
throw new Exception("Packing bag has been out of the warehouse");
}
sSQL = "select isnull(bflag_ST,0) as bflag_ST from GL_mend where iYPeriod = '" + dateEdit1.DateTime.ToString("yyyyMM") + "'";
dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dt == null || dt.Rows.Count == 0)
{
throw new Exception("Access module state failure");
}
int i结账 = BaseFunction.ReturnInt(dt.Rows[0]["bflag_ST"]);
if (i结账 > 0)
{
throw new Exception(dateEdit1.DateTime.ToString("yyyy-MM") + " have checked out");
}
int iCouRow = gridView1.RowCount;
DateTime dLog = dateEdit1.DateTime;
DateTime sLogDate = dateEdit1.DateTime;
//获得单据号
sSQL = "select cNumber from VoucherHistory Where CardNumber='0302'"; // and cSeed = '" + dLog.ToString("yyyyMM") + "'
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]["cNumber"]);
lCode += 1;
sSQL = "update VoucherHistory set cNumber = '" + lCode.ToString() + "' Where CardNumber='0302'";
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
}
else
{
lCode = 1;
sSQL = "insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)" +
"values('0302',null,null,null,'1',0)";
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
}
string sCode = lCode.ToString();
while (sCode.Length < 10)
{
sCode = "0" + sCode;
}
long lID = -1;
long lIDDetails = -1;
sSQL = @"
declare @p5 int
set @p5=111111
declare @p6 int
set @p6=222222
exec sp_GetId N'',N'003',N'rd',333333,@p5 output,@p6 output,default
select @p5, @p6
";
sSQL = sSQL.Replace("111111", lID.ToString());
sSQL = sSQL.Replace("222222", lIDDetails.ToString());
sSQL = sSQL.Replace("333333", iCouRow.ToString());
dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
lID = BaseFunction.ReturnLong(dt.Rows[0][0]) - 1;
lIDDetails = BaseFunction.ReturnLong(dt.Rows[0][1]) - iCouRow;
TH.clsU8.Model.RdRecord09 model = new TH.clsU8.Model.RdRecord09();
lID += 1;
model.ID = lID;
model.bRdFlag = 0;
model.cVouchType = "09";
model.cBusType = "其他出库";
model.cSource = "库存";
//model.cBusCode
model.cWhCode = lookUpEditWarehouse.EditValue.ToString().Trim();
model.dDate = BaseFunction.ReturnDate(dateEdit1.DateTime.ToString("yyyy-MM-dd"));
model.cCode = sCode;
model.cRdCode = lookUpEditOutType.EditValue.ToString().Trim();
//model.cDepCode
//model.cPersonCode
//model.cPTCode
//model.cSTCode
//model.cCusCode
//model.cVenCode
//model.cOrderCode
//model.cARVCode
//model.cBillCode
//model.cDLCode
//model.cProBatch
model.bTransFlag = false;
model.bpufirst = false;
model.biafirst = false;
model.VT_ID = 85;
model.bIsSTQc = false;
model.bFromPreYear = false;
model.bIsComplement = 0;
model.iDiscountTaxType = 0;
model.iBG_OverFlag = 0;
model.dnmaketime = DateTime.Now;
model.bredvouch = 0;
model.iPrintCount = 0;
model.csysbarcode = "||st09|" + sCode;
model.cMaker = sUserName;
model.cDefine1 = s采购订单号;
model.cHandler = sUserName;
model.dVeriDate = BaseFunction.ReturnDate(DateTime.Now.ToString("yyyy-MM-dd"));
model.dnverifytime = DateTime.Now;
TH.clsU8.DAL.RdRecord09 dal = new TH.clsU8.DAL.RdRecord09();
sSQL = dal.Add(model);
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
int iRow = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
string scInvCode = gridView1.GetRowCellValue(i, gridColcInvCode).ToString().Trim();
string scInvCode2 = gridView1.GetRowCellValue(i, gridColcInvCode2).ToString().Trim();
if (scInvCode2 == "")
{
sErr = sErr + "Item Code " + scInvCode + " no set\n";
continue;
}
decimal dQty = clsU8.BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColQty), 2);
string sInvCode = gridView1.GetRowCellValue(i, gridColcInvCode2).ToString().Trim();
sSQL = "select cInvCode,cWhCode,iQuantity as iQty,cWhCode,isnull(cBatch,'') as cBatch from currentstock where cInvCode = '" + sInvCode + "' and cWhCode = '" + model.cWhCode + "' order by cBatch";
dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dQty <= 0)
{
break;
}
string sBatch = dt.Rows[j]["cBatch"].ToString().Trim();
decimal dCurrQtyRow = BaseFunction.ReturnDecimal(dt.Rows[j]["iQty"], 2);
if (dCurrQtyRow <= 0)
{
continue;
}
decimal dOutRow = 0;
if (dCurrQtyRow >= dQty)
{
dOutRow = dQty;
dQty = 0;
}
else
{
dOutRow = dCurrQtyRow;
dQty = dQty - dCurrQtyRow;
}
TH.clsU8.Model.rdrecords09 models = new TH.clsU8.Model.rdrecords09();
lIDDetails += 1;
models.AutoID = lIDDetails;
models.ID = lID;
models.cInvCode = sInvCode;
models.iQuantity = dOutRow;
models.cBatch = sBatch;
models.iFlag = 0;
models.bLPUseFree = false;
models.iRSRowNO = 0;
models.iOriTrackID = 0;
models.bCosting = true;
models.bVMIUsed = false;
models.iExpiratDateCalcu = 0;
models.iordertype = 0;
models.isotype = 0;
models.irowno = iRow;
iRow += 1;
models.cbsysbarcode = "||st09|" + sCode + "|" + (iRow + 1).ToString();
TH.clsU8.DAL.rdrecords09 dals = new TH.clsU8.DAL.rdrecords09();
sSQL = dals.Add(models);
iCount = iCount + DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = "update PO_Podetails set cDefine34 = " + models.iQuantity.ToString() + ",cDefine33 = '" + model.cCode + "' where ID = " + gridView1.GetRowCellValue(i, gridColID).ToString();
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
if (sBatch == "")
{
sSQL = "update currentstock set iQuantity = iQuantity - " + models.iQuantity.ToString().Trim() + " where cInvCode = '" + models.cInvCode + "' and cWhCode = '" + model.cWhCode + "' and isnull(cBatch,'') =''";
}
else
{
sSQL = "update currentstock set iQuantity = iQuantity - " + models.iQuantity.ToString().Trim() + " where cInvCode = '" + models.cInvCode + "' and cWhCode = '" + model.cWhCode + "' and isnull(cBatch,'') = '" + sBatch + "'";
}
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
}
}
if (sErr != "")
{
throw new Exception(sErr);
}
if (iCount > 0)
{
tran.Commit();
MessageBox.Show("OK\n" + sCode);
}
else
{
throw new Exception("Save failed");
}
}
catch (Exception error)
{
tran.Rollback();
throw new Exception(error.Message);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
