private stockMaterialSettlement getStockSettlement()
{
stockMaterialSettlement stockSet = new stockMaterialSettlement();
stockSet.totalWeight = float.Parse(this.textBox2.Text);
stockSet.scId = Convert.ToInt64(this.dgvMain.Rows[0].Cells["scId"].Value.ToString());
stockSet.sum = decimal.Parse(this.textBox3.Text);
stockSet.inputDate = DateTime.Now;
stockSet.inputMan = this.userName;
stockSet.count = Convert.ToInt32(this.textBox4.Text);
return(stockSet);
}
//向采购核算表中插入数据
public string insertStockSettlement(stockMaterialSettlement stockSet)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("insert into stockMaterialSettlement(totalWeight,scId,sum,inputDate,");
sqlStr.Append("inputMan,count)");
sqlStr.Append("values(");
sqlStr.Append("" + stockSet.totalWeight + "," + stockSet.scId + ",");
sqlStr.Append("" + stockSet.sum + "," + "'" + stockSet.inputDate + "'" + ",");
sqlStr.Append("" + "'" + stockSet.inputMan + "'" + ",");
sqlStr.Append("" + stockSet.count);
sqlStr.Append(")");
sqlStr.Append("; declare @smsId int");
sqlStr.Append("; set @smsId=@@IDENTITY;");
return(sqlStr.ToString());
}
//核算和核算明细的保存
public long saveStockSettlementAdd(stockMaterialSettlement stockSet, List <stockMaterialSettlementDetail> list)
{
ArrayList sqlList = new ArrayList();
sqlList.Add(stockSettlementdb.insertStockSettlement(stockSet));
foreach (stockMaterialSettlementDetail stockSetDetail in list)
{
sqlList.Add(stockSettlementdb.insertStockSettlementDetail(stockSetDetail));
}
if (sqlHelper.Insert(sqlList))
{
return(stockSettlementdb.GetMaxInRecId());
}
else
{
return(-1);
}
}
private void saveAll()
{
//实体类
stockMaterialSettlement stockSet = getStockSettlement();
//合同明细列表
List <stockMaterialSettlementDetail> list = getStockSettledetail();
//存合同明细
MaterialSettlementNo = stockSettlementLogic.saveStockSettlementAdd(stockSet, list);
if (MaterialSettlementNo >= 0)
{
List <stockMaterialNoteCorresponding> list1 = GetStockMaterialNote();
List <string> UpdateList = GetStockNodeUpdateInfo();
//stockSettlementLogic.saveMaterialNoteCorresponding(list1, UpdateList);
if (stockSettlementLogic.saveMaterialNoteCorresponding(list1, UpdateList))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
}
}
}
