110,538
社区成员
发帖
与我相关
我的任务
分享
CBomDetail cbd = new CBomDetail();
string cmdstr = "select MTL_PARENT_CODE, MTL_PARENT_EDITION,RELATION_EDITION, SELF_LEVEL_QUANTITY,QUANTITY_UNIT, MP_FLAG, REMARK " +
"from ENG_BOM_DETAIL where MTL_PARENT_CODE='" + partID + "' and RELATION_EDITION='" + edition + "'";
if (cn.State == ConnectionState.Closed)
cn.Open();
SqlCommand cmd = new SqlCommand(cmdstr,cn);
SqlDataReader dr = cmd.ExecuteReader();
//if (dr.HasRows)
while(dr.Read())
{
cbd.PartCode = dr.GetString(0);
cbd.PartEdition = dr.GetString(1);
cbd.RelationEdition = dr.GetString(2);
cbd.SelfLevelQuant =dr.GetFloat(3);
cbd.QuantityUnit = dr.GetString(4);
cbd.MpFlag =char.Parse(dr.GetString(5));
cbd.Remark = dr.GetString(6);
}
cn.Close();
return cbd;