/// <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); } }