private List <TransportGoodsInformationCorresponding> getTransportGoodsInformationCorresponding() { TransportGoodsInformationCorresponding transportGoodsInformationCorresponding = null; List <TransportGoodsInformationCorresponding> list = new List <TransportGoodsInformationCorresponding>(); foreach (DataGridViewRow dgvr in dgv_transportGoods.Rows) { transportGoodsInformationCorresponding = new TransportGoodsInformationCorresponding(); transportGoodsInformationCorresponding.distance = decimal.Parse(dgvr.Cells["distance"].Value.ToString()); transportGoodsInformationCorresponding.inputMan = this.UserName; string mnid = dgvr.Cells["nid"].Value.ToString(); string mmid = dgvr.Cells["mid"].Value.ToString(); if (dgvr.Cells["Type"].Value.ToString() == TransportLogic.TranType.material.ToString()) { transportGoodsInformationCorresponding.mId = long.Parse(new Produce().queryMid(mnid, mmid).ToString()); } else { transportGoodsInformationCorresponding.pId = long.Parse(new Produce().queryPid(mnid, mmid).ToString()); } transportGoodsInformationCorresponding.price = decimal.Parse(dgvr.Cells["price"].Value.ToString()); transportGoodsInformationCorresponding.sId1 = long.Parse(dgvr.Cells["sid1"].Value.ToString()); transportGoodsInformationCorresponding.sId2 = long.Parse(dgvr.Cells["sid2"].Value.ToString()); transportGoodsInformationCorresponding.tsmId = long.Parse(dgvr.Cells["tsmid"].Value.ToString()); list.Add(transportGoodsInformationCorresponding); } return(list); }
/// <summary> /// 获取增加操作SQL字符串 /// </summary> public string GetInsertSql(TransportGoodsInformationCorresponding model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); strSql1.Append("tcId,"); strSql2.Append(" @pid,"); if (model.mId != null) { strSql1.Append("mId,"); strSql2.Append("" + model.mId + ","); } if (model.pId != null) { strSql1.Append("pId,"); strSql2.Append("" + model.pId + ","); } if (model.sId1 != null) { strSql1.Append("sId1,"); strSql2.Append("" + model.sId1 + ","); } if (model.sId2 != null) { strSql1.Append("sId2,"); strSql2.Append("" + model.sId2 + ","); } if (model.distance != null) { strSql1.Append("distance,"); strSql2.Append("" + model.distance + ","); } strSql1.Append("inputDate,"); strSql2.Append("getdate(),"); if (model.inputMan != null) { strSql1.Append("inputMan,"); strSql2.Append("'" + model.inputMan + "',"); } if (model.price != null) { strSql1.Append("price,"); strSql2.Append("" + model.price + ","); } if (model.tsmId != null) { strSql1.Append("tsmId,"); strSql2.Append("" + model.tsmId + ","); } strSql.Append("insert into transportGoodsInformationCorresponding("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY;"); return(strSql.ToString()); }