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());
}
