111,092
社区成员




ds.Tables.Add(CPublicDB.CDBHelper.GetDBInstance.GetDataTableDirectly("select * from PackListDet where PackBoxNo=''", "Detail"));
DataTable dt = CPublicDB.CDBHelper.GetDBInstance.GetDataTableDirectly("exec getPackListDet '" + this.txtPackNo.Text + "'");
foreach (DataRow dr in dt.Rows)
{
object[] objs = new object[13];
objs[0] = 0;
objs[1] = dr["PackListNo"].ToString();
objs[2] = dr["CtnId"].ToString();
objs[3] = dr["FrCtn"].ToString();
objs[4] = dr["ToCtn"].ToString();
objs[5] = dr["CtnQty"].ToString();
objs[6] = dr["StyleNo"].ToString();
objs[7] = dr["StyleNo"].ToString();
objs[8] = dr["Color"].ToString();
objs[9] = dr["Sizes"].ToString();
objs[10] = dr["SizeSeq"].ToString();
objs[11] = dr["Qty"].ToString();
objs[12] = "";
ds.Tables["Detail"].Rows.Add(objs);
}
public bool ExecuteBatchCommandBySQL(DataTable dt, string sSelectSql)
{
OpenCon();
SqlDataAdapter sd = new SqlDataAdapter();
sd.SelectCommand = new SqlCommand(sSelectSql, con);
SqlCommandBuilder scb = new SqlCommandBuilder(sd);
try
{
lock (this)
{
sd.Update(dt);
}
}
catch (Exception ex)
{
throw ex;
}
return true;
//return ds; //数据集的行状态在更新后会都变为: UnChange,在这次更新后客户端要用返回的ds
}
if (CPublicDB.CDBHelper.GetDBInstance.ExecuteBatchCommandBySQL(ds.Tables["Detail"], "select * from PackListDet"))
{
MessageBox.Show("保存成功!");
}
else
MessageBox.Show("保存失败!");
foreach (DataRow dr in dt.Rows)
{
DataRow newDr = ds.Tables["Detail"].NewRow();
newDr["PackListNo"] = dr["PackListNo"].ToString();
newDr["CtnId"] = dr["CtnId"].ToString();
.....同上
ds.Tables["Detail"].Rows.Add(newDr);
}