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 { } } }