private List <stockMaterialSettlementDetail> getStockSettledetail() { stockMaterialSettlementDetail stockSetDetail = null; List <stockMaterialSettlementDetail> list = new List <stockMaterialSettlementDetail>(); foreach (DataGridViewRow dgvr in dgvMain.Rows) { stockSetDetail = new stockMaterialSettlementDetail(); stockSetDetail.iId = Convert.ToInt64(dgvr.Cells["indentId"].Value.ToString()); if (dgvr.Cells["countNote"].Value != null) { stockSetDetail.count = int.Parse(dgvr.Cells["countNote"].Value.ToString()); } else { stockSetDetail.count = 0; } if (dgvr.Cells["money"].Value != null) { stockSetDetail.sum = decimal.Parse(dgvr.Cells["money"].Value.ToString()); } else { stockSetDetail.sum = 0; } stockSetDetail.inputDate = DateTime.Now; stockSetDetail.inputMan = this.userName; list.Add(stockSetDetail); } return(list); }
//向核算明细表中插入数据 public string insertStockSettlementDetail(stockMaterialSettlementDetail stockSetDetail) { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("insert into stockMaterialSettlementDetail(smsId,iId,count,"); sqlStr.Append("sum,inputDate,inputMan)"); sqlStr.Append("values("); sqlStr.Append("" + "@smsId" + ","); sqlStr.Append("" + stockSetDetail.iId + ","); sqlStr.Append("" + stockSetDetail.count + ","); sqlStr.Append("" + stockSetDetail.sum + ","); sqlStr.Append("" + "'" + stockSetDetail.inputDate + "'" + ","); sqlStr.Append("" + "'" + stockSetDetail.inputMan + "'"); sqlStr.Append(")"); return(sqlStr.ToString()); }