public ProductParamInfo GetProductParamByITEM_CD(string ITEM_CD)
{
DataTable tb = getProductParamByITEM_CD(ITEM_CD);
ProductParamInfo info = new ProductParamInfo();
if (tb != null && tb.Rows.Count > 0)
{
info.ITEM_CD = tb.Rows[0][1].ToString();
info.ITEM_NM = tb.Rows[0][2].ToString();
info.ITEM_DESC = tb.Rows[0][3].ToString();
info.MODEL_CD = tb.Rows[0][4].ToString();
info.MODEL_NM = tb.Rows[0][5].ToString();
info.ITEM_COLOR = tb.Rows[0][6].ToString();
info.ITEM_LONG = tb.Rows[0][7].ToString();
info.ITEM_WIDE = tb.Rows[0][8].ToString();
info.LIGHT_BRIGHT = tb.Rows[0][9].ToString();
info.QTY_FOR_CRIB = tb.Rows[0][10].ToString();
info.QTY_FOR_TARY = tb.Rows[0][11].ToString();
info.MO = tb.Rows[0][12].ToString();
info.CRT_ID = tb.Rows[0][13].ToString();
info.CRT_DT = DateTime.Parse(tb.Rows[0][14].ToString());
info.UPT_ID = tb.Rows[0][15].ToString();
info.UPT_DT = DateTime.Parse(tb.Rows[0][16].ToString());
return(info);
}
else
{
throw new Exception("执行 getProductParamByITEM_CD 查询到空值");
}
}
public List <ProductParamInfo> GetProductParams(string item_cd)
{
DataTable tb = ProductParamTableQuery(item_cd);
List <ProductParamInfo> list = new List <ProductParamInfo>();
if (tb != null && tb.Rows.Count > 0)
{
foreach (DataRow row in tb.Rows)
{
ProductParamInfo info = new ProductParamInfo();
info.ITEM_CD = row[0].ToString();
info.ITEM_NM = row[1].ToString();
info.ITEM_DESC = row[2].ToString();
info.MODEL_CD = row[3].ToString();
info.MODEL_NM = row[4].ToString();
info.ITEM_COLOR = row[5].ToString();
info.ITEM_LONG = row[6].ToString();
info.ITEM_WIDE = row[7].ToString();
info.LIGHT_BRIGHT = row[8].ToString();
info.QTY_FOR_CRIB = row[9].ToString();
info.QTY_FOR_TARY = row[10].ToString();
info.MO = row[11].ToString();
info.CRT_ID = row[12].ToString();
info.CRT_DT = DateTime.Parse(row[13].ToString());
info.UPT_ID = row[14].ToString();
info.UPT_DT = DateTime.Parse(row[15].ToString());
list.Add(info);
}
}
return(list);
}
public void UpdateProductParams(ProductParamInfo info)
{
if (!logCell)
{
return;
}
Database equipDB = dataProvider.EQUIPDataBase;
string sql = string.Format(
@"update C_BASE_PRODUCT_T t
set
t.ITEM_NM = '{1}',
t.ITEM_DESC = '{2}',
t.MODEL_CD = '{3}',
t.MODEL_NM = '{4}',
t.ITEM_COLOR = '{5}',
t.ITEM_LONG = '{6}',
t.ITEM_WIDE = '{7}',
t.LIGHT_BRIGHT = '{8}',
t.QTY_FOR_CRIB = '{9}',
t.QTY_FOR_TARY = '{10}',
t.MO = '{11}',
t.UPT_ID = '{12}',
t.UPT_DT = '{13}'
where t.ITEM_CD = '{0}'"
, info.ITEM_CD, info.ITEM_NM, info.ITEM_DESC, info.MODEL_CD, info.MODEL_NM, info.ITEM_COLOR
, info.ITEM_LONG, info.ITEM_WIDE, info.LIGHT_BRIGHT, info.QTY_FOR_CRIB, info.QTY_FOR_TARY, info.MO
, info.UPT_ID, info.UPT_DT.ToString()
);
equipDB.ExecuteScalar(CommandType.Text, sql);
}
//
public void InsertProductParamsInfo(ProductParamInfo info)
{
Database equipDB = dataProvider.EQUIPDataBase;
string sql = string.Format(@"insert C_BASE_PRODUCT_T (ITEM_CD, ITEM_NM, ITEM_DESC, MODEL_CD, MODEL_NM, ITEM_COLOR, ITEM_LONG,ITEM_WIDE,LIGHT_BRIGHT,QTY_FOR_CRIB,QTY_FOR_TARY,MO,CRT_ID,CRT_DT,UPT_ID,UPT_DT) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}'); "
, info.ITEM_CD, info.ITEM_NM, info.ITEM_DESC, info.MODEL_CD, info.MODEL_NM, info.ITEM_COLOR, info.ITEM_LONG, info.ITEM_WIDE, /*info.LIGHT_BRIGHT*/ 0, info.QTY_FOR_CRIB, info.QTY_FOR_TARY,
info.MO, info.CRT_ID, info.CRT_DT.ToString(), info.UPT_ID, info.UPT_DT.ToString());
equipDB.ExecuteNonQuery(CommandType.Text, sql);
}