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