public SystemParamInfo GetSystemParamByIDX(int IDX)
{
DataTable tb = getSystemParamByIDX(IDX);
SystemParamInfo info = new SystemParamInfo();
if (tb != null && tb.Rows.Count > 0)
{
info.IDX = int.Parse(tb.Rows[0][0].ToString());
info.ITEM_CD = tb.Rows[0][2].ToString();
info.SLOT_TY = tb.Rows[0][3].ToString();
info.SLOT_SITE = tb.Rows[0][4].ToString();
info.SLOT_X_DOT = tb.Rows[0][5].ToString();
info.SLOT_Y_DOT = tb.Rows[0][6].ToString();
info.SLOT_Z_DOT = tb.Rows[0][7].ToString();
info.SLOT_U_DOT = tb.Rows[0][8].ToString();
info.LIGHT_1 = tb.Rows[0][9].ToString();
info.LIGHT_2 = tb.Rows[0][10].ToString();
info.LIGHT_3 = tb.Rows[0][11].ToString();
info.LIGHT_4 = tb.Rows[0][12].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("执行 getSystemParamByIDX 查询到空值");
}
}
public List <SystemParamInfo> GetSystemParams(string item_cd)
//public List<SystemParamInfo> GetSystemParams()
{
DataTable tb = SystemParamTableQuery(item_cd);
List <SystemParamInfo> list = new List <SystemParamInfo>();
if (tb != null && tb.Rows.Count > 0)
{
foreach (DataRow row in tb.Rows)
{
SystemParamInfo info = new SystemParamInfo();
info.IDX = int.Parse(row[0].ToString());
info.ITEM_CD = row[1].ToString();
info.SLOT_TY = row[2].ToString();
info.SLOT_SITE = row[3].ToString();
info.SLOT_X_DOT = row[4].ToString();
info.SLOT_Y_DOT = row[5].ToString();
info.SLOT_Z_DOT = row[6].ToString();
info.SLOT_U_DOT = row[7].ToString();
info.LIGHT_1 = row[8].ToString();
info.LIGHT_2 = row[9].ToString();
info.LIGHT_3 = row[10].ToString();
info.LIGHT_4 = row[11].ToString();
info.MO = row[12].ToString();
info.CRT_ID = row[13].ToString();
info.CRT_DT = DateTime.Parse(row[14].ToString());
info.UPT_ID = row[15].ToString();
info.UPT_DT = DateTime.Parse(row[16].ToString());
list.Add(info);
}
}
return(list);
}
public void UpdateSystemParams(SystemParamInfo info)
{
if (!logCell)
{
return;
}
Database equipDB = dataProvider.EQUIPDataBase;
string sql = string.Format(
@"update C_BASE_PRODUCT_SLOT_T t
set
t.SLOT_TY = '{1}',
t.SLOT_SITE = '{2}',
t.SLOT_X_DOT = '{3}',
t.SLOT_Y_DOT = '{4}',
t.SLOT_Z_DOT = '{5}',
t.SLOT_U_DOT = '{6}',
t.LIGHT_1 = '{7}',
t.LIGHT_2 = '{8}',
t.LIGHT_3 = '{9}',
t.LIGHT_4 = '{10}',
t.MO = '{11}',
t.UPT_ID = '{12}',
t.UPT_DT = '{13}'
where t.IDX = '{0}'"
, info.IDX, info.SLOT_TY, info.SLOT_SITE, info.SLOT_X_DOT, info.SLOT_Y_DOT, info.SLOT_Z_DOT
, info.SLOT_U_DOT, info.LIGHT_1, info.LIGHT_2, info.LIGHT_3, info.LIGHT_4, info.MO
, info.UPT_ID, info.UPT_DT.ToString()
);
equipDB.ExecuteScalar(CommandType.Text, sql);
}
//
public void InsertSystemParamsInfo(SystemParamInfo info)
{
Database equipDB = dataProvider.EQUIPDataBase;
string SQL = "select max(IDX) from C_BASE_PRODUCT_SLOT_T";
DataSet ds = equipDB.ExecuteDataSet(CommandType.Text, SQL);
DataTable tb = ds.Tables[0];
if (tb != null && tb.Rows.Count > 0)
{
foreach (DataRow row in tb.Rows)
{
string str = row[0].ToString();
if (str.Length != 0)
{
info.IDX = int.Parse(row[0].ToString()) + 1;
}
else
{
info.IDX = 0;
}
}
}
string sql = string.Format(@"insert C_BASE_PRODUCT_SLOT_T (IDX,ITEM_CD, SLOT_TY, SLOT_SITE, SLOT_X_DOT, SLOT_Y_DOT, SLOT_Z_DOT, SLOT_U_DOT,LIGHT_1,LIGHT_2,LIGHT_3,LIGHT_4,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}', '{16}'); "
, info.IDX, info.ITEM_CD, info.SLOT_TY, info.SLOT_SITE, info.SLOT_X_DOT, info.SLOT_Y_DOT, info.SLOT_Z_DOT, info.SLOT_U_DOT,
info.LIGHT_1, info.LIGHT_2, info.LIGHT_3, info.LIGHT_4,
info.MO, info.CRT_ID, info.CRT_DT.ToString(), info.UPT_ID, info.UPT_DT.ToString());
equipDB.ExecuteNonQuery(CommandType.Text, sql);
}
