/// <summary>
/// 增加一条数据
/// </summary>
public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model.PO_Podetails 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.cPOID != null)
{
strSql1.Append("cPOID,");
strSql2.Append("'" + model.cPOID + "',");
}
if (model.cInvCode != null)
{
strSql1.Append("cInvCode,");
strSql2.Append("'" + model.cInvCode + "',");
}
if (model.iQuantity != null)
{
strSql1.Append("iQuantity,");
strSql2.Append("" + model.iQuantity + ",");
}
if (model.iNum != null)
{
strSql1.Append("iNum,");
strSql2.Append("" + model.iNum + ",");
}
if (model.iQuotedPrice != null)
{
strSql1.Append("iQuotedPrice,");
strSql2.Append("" + model.iQuotedPrice + ",");
}
if (model.iUnitPrice != null)
{
strSql1.Append("iUnitPrice,");
strSql2.Append("" + model.iUnitPrice + ",");
}
if (model.iMoney != null)
{
strSql1.Append("iMoney,");
strSql2.Append("" + model.iMoney + ",");
}
if (model.iTax != null)
{
strSql1.Append("iTax,");
strSql2.Append("" + model.iTax + ",");
}
if (model.iSum != null)
{
strSql1.Append("iSum,");
strSql2.Append("" + model.iSum + ",");
}
if (model.iDisCount != null)
{
strSql1.Append("iDisCount,");
strSql2.Append("" + model.iDisCount + ",");
}
if (model.iNatUnitPrice != null)
{
strSql1.Append("iNatUnitPrice,");
strSql2.Append("" + model.iNatUnitPrice + ",");
}
if (model.iNatMoney != null)
{
strSql1.Append("iNatMoney,");
strSql2.Append("" + model.iNatMoney + ",");
}
if (model.iNatTax != null)
{
strSql1.Append("iNatTax,");
strSql2.Append("" + model.iNatTax + ",");
}
if (model.iNatSum != null)
{
strSql1.Append("iNatSum,");
strSql2.Append("" + model.iNatSum + ",");
}
if (model.iNatDisCount != null)
{
strSql1.Append("iNatDisCount,");
strSql2.Append("" + model.iNatDisCount + ",");
}
if (model.dArriveDate != null)
{
strSql1.Append("dArriveDate,");
strSql2.Append("'" + model.dArriveDate + "',");
}
if (model.iReceivedQTY != null)
{
strSql1.Append("iReceivedQTY,");
strSql2.Append("" + model.iReceivedQTY + ",");
}
if (model.iReceivedNum != null)
{
strSql1.Append("iReceivedNum,");
strSql2.Append("" + model.iReceivedNum + ",");
}
if (model.iReceivedMoney != null)
{
strSql1.Append("iReceivedMoney,");
strSql2.Append("" + model.iReceivedMoney + ",");
}
if (model.iInvQTY != null)
{
strSql1.Append("iInvQTY,");
strSql2.Append("" + model.iInvQTY + ",");
}
if (model.iInvNum != null)
{
strSql1.Append("iInvNum,");
strSql2.Append("" + model.iInvNum + ",");
}
if (model.iInvMoney != null)
{
strSql1.Append("iInvMoney,");
strSql2.Append("" + model.iInvMoney + ",");
}
if (model.cFree1 != null)
{
strSql1.Append("cFree1,");
strSql2.Append("'" + model.cFree1 + "',");
}
if (model.cFree2 != null)
{
strSql1.Append("cFree2,");
strSql2.Append("'" + model.cFree2 + "',");
}
if (model.iNatInvMoney != null)
{
strSql1.Append("iNatInvMoney,");
strSql2.Append("" + model.iNatInvMoney + ",");
}
if (model.iOriTotal != null)
{
strSql1.Append("iOriTotal,");
strSql2.Append("" + model.iOriTotal + ",");
}
if (model.iTotal != null)
{
strSql1.Append("iTotal,");
strSql2.Append("" + model.iTotal + ",");
}
if (model.iPerTaxRate != null)
{
strSql1.Append("iPerTaxRate,");
strSql2.Append("" + model.iPerTaxRate + ",");
}
if (model.cDefine22 != null)
{
strSql1.Append("cDefine22,");
strSql2.Append("'" + model.cDefine22 + "',");
}
if (model.cDefine23 != null)
{
strSql1.Append("cDefine23,");
strSql2.Append("'" + model.cDefine23 + "',");
}
if (model.cDefine24 != null)
{
strSql1.Append("cDefine24,");
strSql2.Append("'" + model.cDefine24 + "',");
}
if (model.cDefine25 != null)
{
strSql1.Append("cDefine25,");
strSql2.Append("'" + model.cDefine25 + "',");
}
if (model.cDefine26 != null)
{
strSql1.Append("cDefine26,");
strSql2.Append("" + model.cDefine26 + ",");
}
if (model.cDefine27 != null)
{
strSql1.Append("cDefine27,");
strSql2.Append("" + model.cDefine27 + ",");
}
if (model.iflag != null)
{
strSql1.Append("iflag,");
strSql2.Append("" + model.iflag + ",");
}
if (model.cItemCode != null)
{
strSql1.Append("cItemCode,");
strSql2.Append("'" + model.cItemCode + "',");
}
if (model.cItem_class != null)
{
strSql1.Append("cItem_class,");
strSql2.Append("'" + model.cItem_class + "',");
}
if (model.PPCIds != null)
{
strSql1.Append("PPCIds,");
strSql2.Append("" + model.PPCIds + ",");
}
if (model.cItemName != null)
{
strSql1.Append("cItemName,");
strSql2.Append("'" + model.cItemName + "',");
}
if (model.cFree3 != null)
{
strSql1.Append("cFree3,");
strSql2.Append("'" + model.cFree3 + "',");
}
if (model.cFree4 != null)
{
strSql1.Append("cFree4,");
strSql2.Append("'" + model.cFree4 + "',");
}
if (model.cFree5 != null)
{
strSql1.Append("cFree5,");
strSql2.Append("'" + model.cFree5 + "',");
}
if (model.cFree6 != null)
{
strSql1.Append("cFree6,");
strSql2.Append("'" + model.cFree6 + "',");
}
if (model.cFree7 != null)
{
strSql1.Append("cFree7,");
strSql2.Append("'" + model.cFree7 + "',");
}
if (model.cFree8 != null)
{
strSql1.Append("cFree8,");
strSql2.Append("'" + model.cFree8 + "',");
}
if (model.cFree9 != null)
{
strSql1.Append("cFree9,");
strSql2.Append("'" + model.cFree9 + "',");
}
if (model.cFree10 != null)
{
strSql1.Append("cFree10,");
strSql2.Append("'" + model.cFree10 + "',");
}
if (model.bGsp != null)
{
strSql1.Append("bGsp,");
strSql2.Append("" + model.bGsp + ",");
}
if (model.POID != null)
{
strSql1.Append("POID,");
strSql2.Append("" + model.POID + ",");
}
if (model.cUnitID != null)
{
strSql1.Append("cUnitID,");
strSql2.Append("'" + model.cUnitID + "',");
}
if (model.iTaxPrice != null)
{
strSql1.Append("iTaxPrice,");
strSql2.Append("" + model.iTaxPrice + ",");
}
if (model.iArrQTY != null)
{
strSql1.Append("iArrQTY,");
strSql2.Append("" + model.iArrQTY + ",");
}
if (model.iArrNum != null)
{
strSql1.Append("iArrNum,");
strSql2.Append("" + model.iArrNum + ",");
}
if (model.iArrMoney != null)
{
strSql1.Append("iArrMoney,");
strSql2.Append("" + model.iArrMoney + ",");
}
if (model.iNatArrMoney != null)
{
strSql1.Append("iNatArrMoney,");
strSql2.Append("" + model.iNatArrMoney + ",");
}
if (model.iAppIds != null)
{
strSql1.Append("iAppIds,");
strSql2.Append("" + model.iAppIds + ",");
}
if (model.cDefine28 != null)
{
strSql1.Append("cDefine28,");
strSql2.Append("'" + model.cDefine28 + "',");
}
if (model.cDefine29 != null)
{
strSql1.Append("cDefine29,");
strSql2.Append("'" + model.cDefine29 + "',");
}
if (model.cDefine30 != null)
{
strSql1.Append("cDefine30,");
strSql2.Append("'" + model.cDefine30 + "',");
}
if (model.cDefine31 != null)
{
strSql1.Append("cDefine31,");
strSql2.Append("'" + model.cDefine31 + "',");
}
if (model.cDefine32 != null)
{
strSql1.Append("cDefine32,");
strSql2.Append("'" + model.cDefine32 + "',");
}
if (model.cDefine33 != null)
{
strSql1.Append("cDefine33,");
strSql2.Append("'" + model.cDefine33 + "',");
}
if (model.cDefine34 != null)
{
strSql1.Append("cDefine34,");
strSql2.Append("" + model.cDefine34 + ",");
}
if (model.cDefine35 != null)
{
strSql1.Append("cDefine35,");
strSql2.Append("" + model.cDefine35 + ",");
}
if (model.cDefine36 != null)
{
strSql1.Append("cDefine36,");
strSql2.Append("'" + model.cDefine36 + "',");
}
if (model.cDefine37 != null)
{
strSql1.Append("cDefine37,");
strSql2.Append("'" + model.cDefine37 + "',");
}
if (model.iSOsID != null)
{
strSql1.Append("iSOsID,");
strSql2.Append("" + model.iSOsID + ",");
}
if (model.bTaxCost != null)
{
strSql1.Append("bTaxCost,");
strSql2.Append("" + (model.bTaxCost ? 1 : 0) + ",");
}
if (model.cSource != null)
{
strSql1.Append("cSource,");
strSql2.Append("'" + model.cSource + "',");
}
if (model.cbCloser != null)
{
strSql1.Append("cbCloser,");
strSql2.Append("'" + model.cbCloser + "',");
}
if (model.iPPartId != null)
{
strSql1.Append("iPPartId,");
strSql2.Append("" + model.iPPartId + ",");
}
if (model.iPQuantity != null)
{
strSql1.Append("iPQuantity,");
strSql2.Append("" + model.iPQuantity + ",");
}
if (model.iPTOSeq != null)
{
strSql1.Append("iPTOSeq,");
strSql2.Append("" + model.iPTOSeq + ",");
}
if (model.SoType != null)
{
strSql1.Append("SoType,");
strSql2.Append("" + model.SoType + ",");
}
if (model.SoDId != null)
{
strSql1.Append("SoDId,");
strSql2.Append("'" + model.SoDId + "',");
}
//if (model.ContractRowGUID != null)
//{
// strSql1.Append("ContractRowGUID,");
// strSql2.Append("'" + Guid.NewGuid().ToString() + "',");
//}
if (model.cupsocode != null)
{
strSql1.Append("cupsocode,");
strSql2.Append("'" + model.cupsocode + "',");
}
if (model.iInvMPCost != null)
{
strSql1.Append("iInvMPCost,");
strSql2.Append("" + model.iInvMPCost + ",");
}
if (model.ContractCode != null)
{
strSql1.Append("ContractCode,");
strSql2.Append("'" + model.ContractCode + "',");
}
if (model.ContractRowNo != null)
{
strSql1.Append("ContractRowNo,");
strSql2.Append("'" + model.ContractRowNo + "',");
}
if (model.fPoValidQuantity != null)
{
strSql1.Append("fPoValidQuantity,");
strSql2.Append("" + model.fPoValidQuantity + ",");
}
if (model.fPoValidNum != null)
{
strSql1.Append("fPoValidNum,");
strSql2.Append("" + model.fPoValidNum + ",");
}
if (model.fPoArrQuantity != null)
{
strSql1.Append("fPoArrQuantity,");
strSql2.Append("" + model.fPoArrQuantity + ",");
}
if (model.fPoArrNum != null)
{
strSql1.Append("fPoArrNum,");
strSql2.Append("" + model.fPoArrNum + ",");
}
if (model.fPoRetQuantity != null)
{
strSql1.Append("fPoRetQuantity,");
strSql2.Append("" + model.fPoRetQuantity + ",");
}
if (model.fPoRetNum != null)
{
strSql1.Append("fPoRetNum,");
strSql2.Append("" + model.fPoRetNum + ",");
}
if (model.fPoRefuseQuantity != null)
{
strSql1.Append("fPoRefuseQuantity,");
strSql2.Append("" + model.fPoRefuseQuantity + ",");
}
if (model.fPoRefuseNum != null)
{
strSql1.Append("fPoRefuseNum,");
strSql2.Append("" + model.fPoRefuseNum + ",");
}
//if (model.dUfts != null)
//{
// strSql1.Append("dUfts,");
// strSql2.Append("" + model.dUfts + ",");
//}
if (model.iorderdid != null)
{
strSql1.Append("iorderdid,");
strSql2.Append("" + model.iorderdid + ",");
}
if (model.iordertype != null)
{
strSql1.Append("iordertype,");
strSql2.Append("" + model.iordertype + ",");
}
if (model.csoordercode != null)
{
strSql1.Append("csoordercode,");
strSql2.Append("'" + model.csoordercode + "',");
}
if (model.iorderseq != null)
{
strSql1.Append("iorderseq,");
strSql2.Append("" + model.iorderseq + ",");
}
if (model.cbCloseTime != null)
{
strSql1.Append("cbCloseTime,");
strSql2.Append("'" + model.cbCloseTime + "',");
}
if (model.cbCloseDate != null)
{
strSql1.Append("cbCloseDate,");
strSql2.Append("'" + model.cbCloseDate + "',");
}
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 + ",");
}
if (model.cBG_Auditopinion != null)
{
strSql1.Append("cBG_Auditopinion,");
strSql2.Append("'" + model.cBG_Auditopinion + "',");
}
if (model.fexquantity != null)
{
strSql1.Append("fexquantity,");
strSql2.Append("" + model.fexquantity + ",");
}
if (model.fexnum != null)
{
strSql1.Append("fexnum,");
strSql2.Append("" + model.fexnum + ",");
}
if (model.ivouchrowno != null)
{
strSql1.Append("ivouchrowno,");
strSql2.Append("" + model.ivouchrowno + ",");
}
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.csocode != null)
{
strSql1.Append("csocode,");
strSql2.Append("'" + model.csocode + "',");
}
if (model.irowno != null)
{
strSql1.Append("irowno,");
strSql2.Append("" + model.irowno + ",");
}
if (model.freceivedqty != null)
{
strSql1.Append("freceivedqty,");
strSql2.Append("" + model.freceivedqty + ",");
}
if (model.freceivednum != null)
{
strSql1.Append("freceivednum,");
strSql2.Append("" + model.freceivednum + ",");
}
if (model.cxjspdids != null)
{
strSql1.Append("cxjspdids,");
strSql2.Append("'" + model.cxjspdids + "',");
}
if (model.cbMemo != null)
{
strSql1.Append("cbMemo,");
strSql2.Append("'" + model.cbMemo + "',");
}
if (model.cbsysbarcode != null)
{
strSql1.Append("cbsysbarcode,");
strSql2.Append("'" + model.cbsysbarcode + "',");
}
if (model.planlotnumber != null)
{
strSql1.Append("planlotnumber,");
strSql2.Append("'" + model.planlotnumber + "',");
}
strSql.Append("insert into PO_Podetails(");
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)
{
string sErr = "";
int iCount = 0;
try
{
try
{
gridView1.FocusedRowHandle -= 1;
gridView1.FocusedRowHandle += 1;
}
catch { }
SqlConnection conn = new SqlConnection(Conn);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
string sSQL = "select getdate()";
DateTime dNow = BaseFunction.ReturnDate(DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0].Rows[0][0]);
DateTime dNowDate = BaseFunction.ReturnDate(dNow.ToString("yyyy-MM-dd"));
int iRowCou = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
bool bChoose = BaseFunction.ReturnBool(gridView1.GetRowCellValue(i, gridColbChoose));
if (!bChoose)
{
continue;
}
decimal dQty = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColOrderQty));
if (dQty <= 0)
{
continue;
}
DateTime dDate = BaseFunction.ReturnDate(gridView1.GetRowCellValue(i, gridColPlanDate));
if (dNowDate > dDate)
{
dDate = dNowDate;
}
iRowCou += 1;
}
if (sErr.Length > 0)
{
throw new Exception(sErr);
}
sSQL = @"
declare @p5 int
set @p5=1000000003
declare @p6 int
set @p6=1000000005
exec sp_getID N'00',N'111111',N'Pomain',222222,@p5 output,@p6 output
select @p5, @p6
";
sSQL = sSQL.Replace("111111", sAccID);
sSQL = sSQL.Replace("222222", iRowCou.ToString());
DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
long iID = BaseFunction.ReturnLong(dt.Rows[0][0]);
long iIDDetails = BaseFunction.ReturnLong(dt.Rows[0][1]);
iIDDetails = iIDDetails - iRowCou;
sSQL = @"
select isnull(max(cNumber),0) as Maxnumber From VoucherHistory with (NOLOCK) Where CardNumber = '88' and cContent like '%单据日期|采购类型%' and cSeed = 'aaaaaaaa'
";
sSQL = sSQL.Replace("aaaaaaaa", BaseFunction.ReturnDate(sLogDate).ToString("yyyy") + "1");
DataTable dtCode = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
long iVouch = 0;
dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dt == null || dt.Rows.Count == 0)
{
iVouch = 0;
}
else
{
iVouch = BaseFunction.ReturnLong(dt.Rows[0][0]);
}
iVouch += 1;
Model.PO_Pomain model = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.PO_Pomain();
sSQL = "select * from PurchaseType where isnull(bDefault,0) = 1";
DataTable dtCodeType = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dtCodeType == null || dtCodeType.Rows.Count < 1)
{
throw new Exception("Please set purchase category");
}
model.cPTCode = dtCodeType.Rows[0]["cPTCode"].ToString().Trim();
model.cPOID = sGetVouCode(BaseFunction.ReturnDate(sLogDate).ToString("yyyy"), iVouch, model.cPTCode);
model.dPODate = BaseFunction.ReturnDate(sLogDate);
sSQL = "select * from Vendor where cVenCode = '" + gridView1.GetRowCellValue(0, gridColcVenCode).ToString().Trim() + "' or cVenName = '" + gridView1.GetRowCellValue(0, gridColcVenCode).ToString().Trim() + "' or cVenAbbName = '" + gridView1.GetRowCellValue(0, gridColcVenCode).ToString().Trim() + "'";
DataTable dtVendor = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dtVendor == null || dtVendor.Rows.Count == 0)
{
throw new Exception("Vendor error");
}
model.cVenCode = dtVendor.Rows[0]["cVenCode"].ToString().Trim();
if (dtVendor.Rows[0]["cVenDepart"].ToString().Trim() == "")
{
throw new Exception("Vendor Department error");
}
model.cDepCode = dtVendor.Rows[0]["cVenDepart"].ToString().Trim();
if (dtVendor.Rows[0]["cVenPPerson"].ToString().Trim() != "")
{
model.cPersonCode = dtVendor.Rows[0]["cVenPPerson"].ToString().Trim();
}
if (dtVendor.Rows[0]["cVenExch_name"].ToString().Trim() == "")
{
model.cexch_name = "SGD";
}
else
{
model.cexch_name = dtVendor.Rows[0]["cVenExch_name"].ToString().Trim();
}
model.nflat = BaseFunction.ReturnDecimal(txtnflat.Text.Trim());
decimal dTax = BaseFunction.ReturnDecimal(dtVendor.Rows[0]["iVenTaxRate"]);
//if (dTax > 0)
//{ }
//else
//{
model.iTaxRate = dTax;
//}
model.iCost = 0;
model.iBargain = 0;
model.cMaker = sUserName;
model.POID = iID;
model.iVTid = 8173;
model.cBusType = "普通采购";
model.iDiscountTaxType = 0;
model.IsWfControlled = false;
model.cmaketime = dNow;
model.iPrintCount = 0;
//model.cVerifier = sUserName;
//model.iverifystateex = 2;
//model.cAuditDate = dNowDate;
//model.cAuditTime = dNow;
model.cState = 0; //审核后是1
model.iverifystateex = 0;
DAL.PO_Pomain dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.PO_Pomain();
sSQL = dal.Add(model);
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
if exists(select * From VoucherHistory with (NOLOCK) Where CardNumber = '88' and cContent like '%单据日期%' and cSeed = N'aaaaaaaa')
update VoucherHistory set cNumber = bbbbbbbb Where CardNumber=N'88' and cContent like '%单据日期%' and cSeed = N'aaaaaaaa'
else
insert into VoucherHistory(CardNumber, cContent, cContentRule, cSeed, cNumber, bEmpty)
values(N'88',N'单据日期|采购类型',N'YYYY|',N'aaaaaaaa',bbbbbbbb,0)
";
sSQL = sSQL.Replace("aaaaaaaa", BaseFunction.ReturnDate(sLogDate).ToString("yyyy") + "1");
sSQL = sSQL.Replace("bbbbbbbb", iVouch.ToString());
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
int iRowNo = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
bool bChoose = BaseFunction.ReturnBool(gridView1.GetRowCellValue(i, gridColbChoose));
if (!bChoose)
{
continue;
}
decimal dQty = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColOrderQty));
if (dQty <= 0)
{
continue;
}
sSQL = "select * from Inventory where cInvCode = '" + gridView1.GetRowCellDisplayText(i, gridColcInvCode).ToString().Trim() + "'";
DataTable dtInv = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
iIDDetails += 1;
Model.PO_Podetails models = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.PO_Podetails();
models.ID = iIDDetails;
models.cInvCode = gridView1.GetRowCellDisplayText(i, gridColcInvCode).ToString().Trim();
models.iQuantity = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColOrderQty));
decimal dNum = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColOrderNum));
if (dNum != 0)
{
models.iNum = dNum;
}
models.cDefine26 = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColvolume));
models.cDefine27 = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColweight));
decimal dPrice = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColPrice));
if (dPrice == 0)
{
throw new Exception("Row " + (i + 1).ToString() + " please set vendor price");
}
//decimal dTaxRate = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColTaxRate));
//if(dTaxRate == 0)
// dTaxRate = 7;
models.iPerTaxRate = model.iTaxRate;
models.iUnitPrice = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColPrice));
models.iMoney = BaseFunction.ReturnDecimal(models.iUnitPrice * models.iQuantity, 6);
models.iTaxPrice = BaseFunction.ReturnDecimal(models.iUnitPrice * (1 + models.iPerTaxRate / 100));
models.iSum = BaseFunction.ReturnDecimal(models.iTaxPrice * models.iQuantity, 6);
models.iTax = models.iSum - models.iMoney;
decimal iFlat = BaseFunction.ReturnDecimal(txtnflat.Text.Trim());
if (iFlat == 1)
{
models.iNatUnitPrice = models.iUnitPrice;
}
else
{
if (radio2.Checked)
{
models.iNatUnitPrice = BaseFunction.ReturnDecimal(models.iUnitPrice / iFlat);
}
if (radio1.Checked)
{
models.iNatUnitPrice = BaseFunction.ReturnDecimal(models.iUnitPrice * iFlat);
}
}
models.iNatMoney = BaseFunction.ReturnDecimal(models.iNatUnitPrice * models.iQuantity, 6);
models.iNatSum = BaseFunction.ReturnDecimal(models.iNatMoney * (1 + models.iPerTaxRate / 100));
models.iNatTax = models.iNatSum - models.iNatMoney;
models.dArriveDate = BaseFunction.ReturnDate(gridView1.GetRowCellValue(i, gridColPlanDate));
models.bGsp = 0;
models.POID = iID;
models.cUnitID = gridView1.GetRowCellValue(i, gridColcComunitCode).ToString().Trim();
models.bTaxCost = true;
iRowNo += 1;
//models.irowno = iRowNo;
models.ivouchrowno = iRowNo;
DAL.PO_Podetails dals = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.PO_Podetails();
sSQL = dals.Add(models);
iCount = DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = "update PO_Pomain set iTaxrate = " + models.iPerTaxRate.ToString() + " where poid = " + iID.ToString();
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
}
if (iCount > 0)
{
tran.Commit();
MessageBox.Show("OK\n" + model.cPOID);
gridControl1.DataSource = null;
}
else
{
throw new Exception("no data");
}
}
catch (Exception ee)
{
tran.Rollback();
throw new Exception(ee.Message);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
