/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_SLABWH_LOG GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_SLAB_MAIN_ID,C_MOVE_TYPE,C_SHIFT,C_GROUP,C_MAT_CODE,C_MAT_DESC,C_SLABWH_CODE_BEFORE,C_SLABWH_AREA_CODE_BEFORE,C_SLABWH_LOC_CODE_BEFORE,C_FLOOR_BEFORE,D_STORAGE_DT,C_SLABWH_CODE_AFTER,C_SLABWH_AREA_CODE_AFTER,C_FLOOR_AFTER,C_SALE_AREA,C_TRANSPORTATION,C_EMP_ID,D_MOD_DT,N_STATUS,C_SLABWH_LOC_CODE_AFTER,N_ORDER,D_ESC_DATE,D_LSC_DATE,C_COOLPIT_CODE,C_COOLPIT_AREA_CODE,C_COOLPIT_LOC_CODE,C_COOLPIT from TRC_SLABWH_LOG ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_SLABWH_LOG model = new Mod_TRC_SLABWH_LOG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (DialogResult.No == MessageBox.Show("是否确认？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1))
{
return;
}
int[] row = gv_GP1.GetSelectedRows();
int ycount = 0;
int krzs = Convert.ToInt32(txt_ZDZS.Text) - Convert.ToInt32(txt_KCZS.Text);
if (row.Count() > krzs)
{
MessageBox.Show("已超出当前层支数！"); return;
}
foreach (var item in row)
{
DataRow dr = gv_GP1.GetDataRow(item);
string id = dr["C_ID"].ToString();
string ck = cbo_CK1.Text;
string qy = cbo_QY1.Text;
string kw = cbo_KW1.Text;
string c = cbo_C1.Text;
string rkzt = "E";
DateTime startdatetime = de_Start.DateTime;
DateTime enddateTime = de_End.DateTime;
if (bll_TSC_SLAB_MAIN.Update(id, type2, ck, qy, kw, c, rkzt, startdatetime, enddateTime))
{
ycount += 1;
Mod_TRC_SLABWH_LOG model = new Mod_TRC_SLABWH_LOG();
model.C_SLAB_MAIN_ID = id;
model.C_MOVE_TYPE = type2;
model.C_EMP_ID = RV.UI.UserInfo.userName;
model.C_COOLPIT = cbo_C1.Text;
model.C_FLOOR_BEFORE = dr["C_SLABWH_TIER_CODE"].ToString();
model.C_GROUP = cbo_BZ.EditValue.ToString();
model.C_COOLPIT_AREA_CODE = cbo_QY1.Text;
model.C_SLABWH_AREA_CODE_BEFORE = dr["C_SLABWH_AREA_CODE"].ToString();
model.C_COOLPIT_CODE = cbo_CK1.Text;
model.C_SLABWH_CODE_BEFORE = dr["C_SLABWH_CODE"].ToString();
model.C_COOLPIT_LOC_CODE = cbo_KW1.Text;
model.C_SLABWH_LOC_CODE_BEFORE = dr["C_SLABWH_LOC_CODE"].ToString();
model.C_SHIFT = cbo_BC.EditValue.ToString();
model.D_STORAGE_DT = de_st.DateTime;
model.D_ESC_DATE = de_Start.DateTime;
model.D_LSC_DATE = de_End.DateTime;
model.N_ORDER = bll_TRC_SLABWH_LOG.GetSLABCount(id, type2).Tables[0].Rows.Count + 1;
bll_TRC_SLABWH_LOG.Add(model);
bll_TRC_SLABWH_LOG.Upstatus(id, 0, Convert.ToInt32(model.N_ORDER));
}
}
MessageBox.Show("共入坑" + row.Count() + "条，成功入坑" + ycount + "条！");
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "钢坯入缓冷坑");//添加操作日志
Query1();
Query2();
cbo_C1_SelectedValueChanged(null, null);
txt_XZZS.Text = "0";
}
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.No == MessageBox.Show("是否确认？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1))
{
return;
}
int[] row = gv_GP1.GetSelectedRows();
int ycount = 0;
string ck = cbo_CK1.Text;
string qy = cbo_QY1.Text;
foreach (var item in row)
{
DataRow dr = gv_GP1.GetDataRow(item);
string id = dr["C_ID"].ToString();
if (type2 == "D")
{
type2 += bll_TRC_SLABWH_LOG.GetDBCount(id, type2);
}
if (bll_TSC_SLAB_MAIN.Update(id, type2, ck, qy, "", ""))
{
ycount += 1;
Mod_TRC_SLABWH_LOG model = new Mod_TRC_SLABWH_LOG();
model.C_SLAB_MAIN_ID = id;
model.C_MOVE_TYPE = type2;
model.C_TRANSPORTATION = cbo_ZKFS.Text;
model.C_EMP_ID = RV.UI.UserInfo.userName;
model.C_FLOOR_BEFORE = dr["C_SLABWH_TIER_CODE"].ToString();
model.C_GROUP = cbo_BZ.EditValue.ToString();
model.C_SLABWH_AREA_CODE_AFTER = cbo_QY1.Text;
model.C_SLABWH_AREA_CODE_BEFORE = dr["C_SLABWH_AREA_CODE"].ToString();
model.C_SLABWH_CODE_AFTER = cbo_CK1.Text;
model.C_SLABWH_CODE_BEFORE = dr["C_SLABWH_CODE"].ToString();
model.C_SLABWH_LOC_CODE_BEFORE = dr["C_SLABWH_LOC_CODE"].ToString();
model.C_SHIFT = cbo_BC.EditValue.ToString();
model.D_STORAGE_DT = de_st.DateTime;
model.N_ORDER = bll_TRC_SLABWH_LOG.GetSLABCount(id, type2).Tables[0].Rows.Count + 1;
bll_TRC_SLABWH_LOG.Add(model);
bll_TRC_SLABWH_LOG.Upstatus(id, 0, Convert.ToInt32(model.N_ORDER));
}
}
MessageBox.Show("共出库" + row.Count() + "条，成功出库" + ycount + "条！");
Query1();
Query2();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
int[] row = gv_GP1.GetSelectedRows();
int ycount = 0;
string ck = cbo_CK1.Text;
string qy = cbo_QY1.Text;
foreach (var item in row)
{
DataRow dr = gv_GP1.GetDataRow(item);
string id = dr["C_ID"].ToString();
if (bll_TSC_SLAB_MAIN.Update(id, type2, ck, qy, "", ""))
{
ycount += 1;
Mod_TRC_SLABWH_LOG model = new Mod_TRC_SLABWH_LOG();
model.C_SLAB_MAIN_ID = id;
model.C_MOVE_TYPE = type2;
model.C_TRANSPORTATION = cbo_ZKFS.Text;
model.C_EMP_ID = RV.UI.UserInfo.userName;
model.C_FLOOR_BEFORE = dr["C_SLABWH_TIER_CODE"].ToString();
model.C_GROUP = cbo_BZ.EditValue.ToString();
model.C_SLABWH_AREA_CODE_AFTER = cbo_QY1.Text;
model.C_SLABWH_AREA_CODE_BEFORE = dr["C_SLABWH_AREA_CODE"].ToString();
model.C_SLABWH_CODE_AFTER = cbo_CK1.Text;
model.C_SLABWH_CODE_BEFORE = dr["C_SLABWH_CODE"].ToString();
model.C_SLABWH_LOC_CODE_BEFORE = dr["C_SLABWH_LOC_CODE"].ToString();
model.C_SHIFT = cbo_BC.EditValue.ToString();
model.D_STORAGE_DT = de_st.DateTime;
model.N_ORDER = bll_TRC_SLABWH_LOG.GetSLABCount(id, type2).Tables[0].Rows.Count + 1;
bll_TRC_SLABWH_LOG.Add(model);
bll_TRC_SLABWH_LOG.Upstatus(id, 0, Convert.ToInt32(model.N_ORDER));
}
}
MessageBox.Show("共出库" + row.Count() + "条，成功出库" + ycount + "条！");
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "钢坯调拨");//添加操作日志
Query1();
Query2();
txt_XZZS.Text = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.No == MessageBox.Show("是否确认？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1))
{
return;
}
int[] row = gv_GP1.GetSelectedRows();
int ycount = 0;
if (xtraTabControl1.SelectedTabPage.Name == "TC")
{
row = gv_TCP.GetSelectedRows();
}
if (xtraTabControl1.SelectedTabPage.Name == "XM")
{
row = gv_XM.GetSelectedRows();
}
if (xtraTabControl1.SelectedTabPage.Name == "KP")
{
row = gv_KP.GetSelectedRows();
}
if (xtraTabControl1.SelectedTabPage.Name == "XST")
{
row = gv_XST.GetSelectedRows();
}
if (xtraTabControl1.SelectedTabPage.Name == "DB")
{
row = gv_DB.GetSelectedRows();
}
int krzs = Convert.ToInt32(txt_ZDZS.Text) - Convert.ToInt32(txt_KCZS.Text);
if (row.Count() > krzs)
{
MessageBox.Show("已超出当前层支数！"); return;
}
foreach (var item in row)
{
DataRow dr = gv_GP1.GetDataRow(item);
if (xtraTabControl1.SelectedTabPage.Name == "TC")
{
dr = gv_TCP.GetDataRow(item);
}
if (xtraTabControl1.SelectedTabPage.Name == "XM")
{
dr = gv_XM.GetDataRow(item);
}
if (xtraTabControl1.SelectedTabPage.Name == "KP")
{
dr = gv_KP.GetDataRow(item);
}
if (xtraTabControl1.SelectedTabPage.Name == "XST")
{
dr = gv_XST.GetDataRow(item);
}
if (xtraTabControl1.SelectedTabPage.Name == "DB")
{
dr = gv_DB.GetDataRow(item);
}
string id = dr["C_ID"].ToString();
string ck = cbo_CK1.Text;
string qy = cbo_QY1.Text;
string kw = cbo_KW1.Text;
string c = cbo_C1.Text;
if (bll_TSC_SLAB_MAIN.Update(id, type2, ck, qy, kw, c))
{
ycount += 1;
Mod_TRC_SLABWH_LOG model = new Mod_TRC_SLABWH_LOG();
model.C_SLAB_MAIN_ID = id;
model.C_MOVE_TYPE = type2;
model.C_EMP_ID = RV.UI.UserInfo.userName;
model.C_FLOOR_AFTER = cbo_C1.Text;
model.C_FLOOR_BEFORE = dr["C_SLABWH_TIER_CODE"].ToString();
model.C_GROUP = cbo_BZ.EditValue.ToString();
model.C_SLABWH_AREA_CODE_AFTER = cbo_QY1.Text;
model.C_SLABWH_AREA_CODE_BEFORE = dr["C_SLABWH_AREA_CODE"].ToString();
model.C_SLABWH_CODE_AFTER = cbo_CK1.Text;
model.C_SLABWH_CODE_BEFORE = dr["C_SLABWH_CODE"].ToString();
model.C_SLABWH_LOC_CODE_AFTER = cbo_KW1.Text;
model.C_SLABWH_LOC_CODE_BEFORE = dr["C_SLABWH_LOC_CODE"].ToString();
model.C_SHIFT = cbo_BC.EditValue.ToString();
model.D_STORAGE_DT = de_st.DateTime;
model.N_ORDER = bll_TRC_SLABWH_LOG.GetSLABCount(id, type2).Tables[0].Rows.Count + 1;
bll_TRC_SLABWH_LOG.Add(model);
bll_TRC_SLABWH_LOG.Upstatus(id, 0, Convert.ToInt32(model.N_ORDER));
}
}
MessageBox.Show("共入库" + row.Count() + "条，成功入库" + ycount + "条！");
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "钢坯入库");//添加操作日志
Query1();
Query2();
cbo_CK1_SelectedValueChanged(null, null);
txt_XZZS.Text = "0";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_SLABWH_LOG model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_SLABWH_LOG model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_SLABWH_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_SLABWH_LOG(");
strSql.Append("C_SLAB_MAIN_ID,C_MOVE_TYPE,C_SHIFT,C_GROUP,C_MAT_CODE,C_MAT_DESC,C_SLABWH_CODE_BEFORE,C_SLABWH_AREA_CODE_BEFORE,C_SLABWH_LOC_CODE_BEFORE,C_FLOOR_BEFORE,D_STORAGE_DT,C_SLABWH_CODE_AFTER,C_SLABWH_AREA_CODE_AFTER,C_FLOOR_AFTER,C_SALE_AREA,C_TRANSPORTATION,C_EMP_ID,D_MOD_DT,N_STATUS,C_SLABWH_LOC_CODE_AFTER,N_ORDER,D_ESC_DATE,D_LSC_DATE,C_COOLPIT_CODE,C_COOLPIT_AREA_CODE,C_COOLPIT_LOC_CODE,C_COOLPIT)");
strSql.Append(" values (");
strSql.Append(":C_SLAB_MAIN_ID,:C_MOVE_TYPE,:C_SHIFT,:C_GROUP,:C_MAT_CODE,:C_MAT_DESC,:C_SLABWH_CODE_BEFORE,:C_SLABWH_AREA_CODE_BEFORE,:C_SLABWH_LOC_CODE_BEFORE,:C_FLOOR_BEFORE,:D_STORAGE_DT,:C_SLABWH_CODE_AFTER,:C_SLABWH_AREA_CODE_AFTER,:C_FLOOR_AFTER,:C_SALE_AREA,:C_TRANSPORTATION,:C_EMP_ID,:D_MOD_DT,:N_STATUS,:C_SLABWH_LOC_CODE_AFTER,:N_ORDER,:D_ESC_DATE,:D_LSC_DATE,:C_COOLPIT_CODE,:C_COOLPIT_AREA_CODE,:C_COOLPIT_LOC_CODE,:C_COOLPIT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_SLAB_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MOVE_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SHIFT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GROUP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLABWH_CODE_BEFORE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLABWH_AREA_CODE_BEFORE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLABWH_LOC_CODE_BEFORE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FLOOR_BEFORE", OracleDbType.Varchar2, 100),
new OracleParameter(":D_STORAGE_DT", OracleDbType.Date),
new OracleParameter(":C_SLABWH_CODE_AFTER", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLABWH_AREA_CODE_AFTER", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FLOOR_AFTER", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SALE_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TRANSPORTATION", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_SLABWH_LOC_CODE_AFTER", OracleDbType.Varchar2, 100),
new OracleParameter(":N_ORDER", OracleDbType.Decimal, 3),
new OracleParameter(":D_ESC_DATE", OracleDbType.Date),
new OracleParameter(":D_LSC_DATE", OracleDbType.Date),
new OracleParameter(":C_COOLPIT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_COOLPIT_AREA_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_COOLPIT_LOC_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_COOLPIT", OracleDbType.Varchar2, 100),
};
parameters[0].Value = model.C_SLAB_MAIN_ID;
parameters[1].Value = model.C_MOVE_TYPE;
parameters[2].Value = model.C_SHIFT;
parameters[3].Value = model.C_GROUP;
parameters[4].Value = model.C_MAT_CODE;
parameters[5].Value = model.C_MAT_DESC;
parameters[6].Value = model.C_SLABWH_CODE_BEFORE;
parameters[7].Value = model.C_SLABWH_AREA_CODE_BEFORE;
parameters[8].Value = model.C_SLABWH_LOC_CODE_BEFORE;
parameters[9].Value = model.C_FLOOR_BEFORE;
parameters[10].Value = model.D_STORAGE_DT;
parameters[11].Value = model.C_SLABWH_CODE_AFTER;
parameters[12].Value = model.C_SLABWH_AREA_CODE_AFTER;
parameters[13].Value = model.C_FLOOR_AFTER;
parameters[14].Value = model.C_SALE_AREA;
parameters[15].Value = model.C_TRANSPORTATION;
parameters[16].Value = model.C_EMP_ID;
parameters[17].Value = model.D_MOD_DT;
parameters[18].Value = model.N_STATUS;
parameters[19].Value = model.C_SLABWH_LOC_CODE_AFTER;
parameters[20].Value = model.N_ORDER;
parameters[21].Value = model.D_ESC_DATE;
parameters[22].Value = model.D_LSC_DATE;
parameters[23].Value = model.C_COOLPIT_CODE;
parameters[24].Value = model.C_COOLPIT_AREA_CODE;
parameters[25].Value = model.C_COOLPIT_LOC_CODE;
parameters[26].Value = model.C_COOLPIT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_SLABWH_LOG DataRowToModel(DataRow row)
{
Mod_TRC_SLABWH_LOG model = new Mod_TRC_SLABWH_LOG();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_SLAB_MAIN_ID"] != null)
{
model.C_SLAB_MAIN_ID = row["C_SLAB_MAIN_ID"].ToString();
}
if (row["C_MOVE_TYPE"] != null)
{
model.C_MOVE_TYPE = row["C_MOVE_TYPE"].ToString();
}
if (row["C_SHIFT"] != null)
{
model.C_SHIFT = row["C_SHIFT"].ToString();
}
if (row["C_GROUP"] != null)
{
model.C_GROUP = row["C_GROUP"].ToString();
}
if (row["C_MAT_CODE"] != null)
{
model.C_MAT_CODE = row["C_MAT_CODE"].ToString();
}
if (row["C_MAT_DESC"] != null)
{
model.C_MAT_DESC = row["C_MAT_DESC"].ToString();
}
if (row["C_SLABWH_CODE_BEFORE"] != null)
{
model.C_SLABWH_CODE_BEFORE = row["C_SLABWH_CODE_BEFORE"].ToString();
}
if (row["C_SLABWH_AREA_CODE_BEFORE"] != null)
{
model.C_SLABWH_AREA_CODE_BEFORE = row["C_SLABWH_AREA_CODE_BEFORE"].ToString();
}
if (row["C_SLABWH_LOC_CODE_BEFORE"] != null)
{
model.C_SLABWH_LOC_CODE_BEFORE = row["C_SLABWH_LOC_CODE_BEFORE"].ToString();
}
if (row["C_FLOOR_BEFORE"] != null)
{
model.C_FLOOR_BEFORE = row["C_FLOOR_BEFORE"].ToString();
}
if (row["D_STORAGE_DT"] != null && row["D_STORAGE_DT"].ToString() != "")
{
model.D_STORAGE_DT = DateTime.Parse(row["D_STORAGE_DT"].ToString());
}
if (row["C_SLABWH_CODE_AFTER"] != null)
{
model.C_SLABWH_CODE_AFTER = row["C_SLABWH_CODE_AFTER"].ToString();
}
if (row["C_SLABWH_AREA_CODE_AFTER"] != null)
{
model.C_SLABWH_AREA_CODE_AFTER = row["C_SLABWH_AREA_CODE_AFTER"].ToString();
}
if (row["C_FLOOR_AFTER"] != null)
{
model.C_FLOOR_AFTER = row["C_FLOOR_AFTER"].ToString();
}
if (row["C_SALE_AREA"] != null)
{
model.C_SALE_AREA = row["C_SALE_AREA"].ToString();
}
if (row["C_TRANSPORTATION"] != null)
{
model.C_TRANSPORTATION = row["C_TRANSPORTATION"].ToString();
}
if (row["C_EMP_ID"] != null)
{
model.C_EMP_ID = row["C_EMP_ID"].ToString();
}
if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "")
{
model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString());
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["C_SLABWH_LOC_CODE_AFTER"] != null)
{
model.C_SLABWH_LOC_CODE_AFTER = row["C_SLABWH_LOC_CODE_AFTER"].ToString();
}
if (row["N_ORDER"] != null && row["N_ORDER"].ToString() != "")
{
model.N_ORDER = decimal.Parse(row["N_ORDER"].ToString());
}
if (row["D_ESC_DATE"] != null && row["D_ESC_DATE"].ToString() != "")
{
model.D_ESC_DATE = DateTime.Parse(row["D_ESC_DATE"].ToString());
}
if (row["D_LSC_DATE"] != null && row["D_LSC_DATE"].ToString() != "")
{
model.D_LSC_DATE = DateTime.Parse(row["D_LSC_DATE"].ToString());
}
if (row["C_COOLPIT_CODE"] != null)
{
model.C_COOLPIT_CODE = row["C_COOLPIT_CODE"].ToString();
}
if (row["C_COOLPIT_AREA_CODE"] != null)
{
model.C_COOLPIT_AREA_CODE = row["C_COOLPIT_AREA_CODE"].ToString();
}
if (row["C_COOLPIT_LOC_CODE"] != null)
{
model.C_COOLPIT_LOC_CODE = row["C_COOLPIT_LOC_CODE"].ToString();
}
if (row["C_COOLPIT"] != null)
{
model.C_COOLPIT = row["C_COOLPIT"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_SLABWH_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_SLABWH_LOG set ");
strSql.Append("C_SLAB_MAIN_ID=:C_SLAB_MAIN_ID,");
strSql.Append("C_MOVE_TYPE=:C_MOVE_TYPE,");
strSql.Append("C_SHIFT=:C_SHIFT,");
strSql.Append("C_GROUP=:C_GROUP,");
strSql.Append("C_MAT_CODE=:C_MAT_CODE,");
strSql.Append("C_MAT_DESC=:C_MAT_DESC,");
strSql.Append("C_SLABWH_CODE_BEFORE=:C_SLABWH_CODE_BEFORE,");
strSql.Append("C_SLABWH_AREA_CODE_BEFORE=:C_SLABWH_AREA_CODE_BEFORE,");
strSql.Append("C_SLABWH_LOC_CODE_BEFORE=:C_SLABWH_LOC_CODE_BEFORE,");
strSql.Append("C_FLOOR_BEFORE=:C_FLOOR_BEFORE,");
strSql.Append("D_STORAGE_DT=:D_STORAGE_DT,");
strSql.Append("C_SLABWH_CODE_AFTER=:C_SLABWH_CODE_AFTER,");
strSql.Append("C_SLABWH_AREA_CODE_AFTER=:C_SLABWH_AREA_CODE_AFTER,");
strSql.Append("C_FLOOR_AFTER=:C_FLOOR_AFTER,");
strSql.Append("C_SALE_AREA=:C_SALE_AREA,");
strSql.Append("C_TRANSPORTATION=:C_TRANSPORTATION,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_SLABWH_LOC_CODE_AFTER=:C_SLABWH_LOC_CODE_AFTER,");
strSql.Append("N_ORDER=:N_ORDER,");
strSql.Append("D_ESC_DATE=:D_ESC_DATE,");
strSql.Append("D_LSC_DATE=:D_LSC_DATE,");
strSql.Append("C_COOLPIT_CODE=:C_COOLPIT_CODE,");
strSql.Append("C_COOLPIT_AREA_CODE=:C_COOLPIT_AREA_CODE,");
strSql.Append("C_COOLPIT_LOC_CODE=:C_COOLPIT_LOC_CODE,");
strSql.Append("C_COOLPIT=:C_COOLPIT,");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_SLAB_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MOVE_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SHIFT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GROUP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLABWH_CODE_BEFORE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLABWH_AREA_CODE_BEFORE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLABWH_LOC_CODE_BEFORE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FLOOR_BEFORE", OracleDbType.Varchar2, 100),
new OracleParameter(":D_STORAGE_DT", OracleDbType.Date),
new OracleParameter(":C_SLABWH_CODE_AFTER", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLABWH_AREA_CODE_AFTER", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FLOOR_AFTER", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SALE_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TRANSPORTATION", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_SLABWH_LOC_CODE_AFTER", OracleDbType.Varchar2, 100),
new OracleParameter(":N_ORDER", OracleDbType.Decimal, 3),
new OracleParameter(":D_ESC_DATE", OracleDbType.Date),
new OracleParameter(":D_LSC_DATE", OracleDbType.Date),
new OracleParameter(":C_COOLPIT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_COOLPIT_AREA_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_COOLPIT_LOC_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_COOLPIT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_SLAB_MAIN_ID;
parameters[1].Value = model.C_MOVE_TYPE;
parameters[2].Value = model.C_SHIFT;
parameters[3].Value = model.C_GROUP;
parameters[4].Value = model.C_MAT_CODE;
parameters[5].Value = model.C_MAT_DESC;
parameters[6].Value = model.C_SLABWH_CODE_BEFORE;
parameters[7].Value = model.C_SLABWH_AREA_CODE_BEFORE;
parameters[8].Value = model.C_SLABWH_LOC_CODE_BEFORE;
parameters[9].Value = model.C_FLOOR_BEFORE;
parameters[10].Value = model.D_STORAGE_DT;
parameters[11].Value = model.C_SLABWH_CODE_AFTER;
parameters[12].Value = model.C_SLABWH_AREA_CODE_AFTER;
parameters[13].Value = model.C_FLOOR_AFTER;
parameters[14].Value = model.C_SALE_AREA;
parameters[15].Value = model.C_TRANSPORTATION;
parameters[16].Value = model.C_EMP_ID;
parameters[17].Value = model.D_MOD_DT;
parameters[18].Value = model.N_STATUS;
parameters[19].Value = model.C_SLABWH_LOC_CODE_AFTER;
parameters[20].Value = model.N_ORDER;
parameters[21].Value = model.D_ESC_DATE;
parameters[22].Value = model.D_LSC_DATE;
parameters[23].Value = model.C_COOLPIT_CODE;
parameters[24].Value = model.C_COOLPIT_AREA_CODE;
parameters[25].Value = model.C_COOLPIT_LOC_CODE;
parameters[26].Value = model.C_COOLPIT;
parameters[27].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
