110,533
社区成员
发帖
与我相关
我的任务
分享
StringReader sr = new StringReader(oTagInfo.InputParams[0]);
ds.ReadXml(sr);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++) // ds.Tables[0].Rows.Count=1
{
string PalletNo = ds.Tables[0].Rows[i]["托盘号"].ToString();
string SLCodeID = ds.Tables[0].Rows[i]["库位"].ToString();
string ModuleToSL_ConditionID = ds.Tables[0].Rows[i]["卡关条件ID"].ToString();
string OpUserID = oTagInfo.UserID;// "Admin";// ds.Tables[0].Rows[i]["颜色"].ToString();
string Status = "0"; // 0----入库初始状态为 ;1-----已拼柜; -1 ------退库
sql += " insert into warehouse.modulebindingsl (PalletNo,SLCodeID,ModuleToSL_ConditionID , OpUserID , CreateDateTime,Status ,Computer) values " +
"('" + PalletNo + "','" + SLCodeID + "','" + ModuleToSL_ConditionID + "','" + OpUserID + "', now(),'" + Status + "','"+oTagInfo.ComputerName+"');";
}
DB.ExecuteNonquery(DB.MySqlconn, sql, ref result);
sr.Close();
string PalletNo = ds.Tables[0].Rows[i]["托盘号"].ToString();
一样不一样你需要看这个获取的是什么