/// <summary>
/// 撤回开坯计划
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_canale_Click(object sender, EventArgs e)
{
WaitingFrom.ShowWait("计划正在撤回，请稍候...");
int[] rownumber = this.gv_KPZPJH.GetSelectedRows();//获取选中行号数组；
for (int i = 0; i < rownumber.Length; i++)
{
int selectedHandle = rownumber[i];
string c_id = gv_KPZPJH.GetRowCellValue(selectedHandle, "C_ID").ToString();
Mod_TRP_PLAN_COGDOWN mod = bll_kp.GetModel(c_id);
if (mod.N_STATUS == 1 && mod.N_GROUP_WGT == 0)
{
string order_id = mod.C_ORDER_NO;
Mod_TSP_PLAN_SMS mod_sms = bll_sms.GetModel(order_id);
if (mod_sms != null)
{
mod_sms.N_CREAT_ZG_PLAN = 0;
bll_sms.Update(mod_sms);
bll_kp.Delete(c_id);
}
}
}
WaitingFrom.CloseWait();
btn_query_zg_Click(null, null);
btn_query_kpplan_Click(null, null);
}
/// <summary>
/// 撤回开坯计划
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_canale_Click(object sender, EventArgs e)
{
try
{
WaitingFrom.ShowWait("计划正在撤回，请稍候...");
int[] rownumber = this.gv_KPZPJH.GetSelectedRows();//获取选中行号数组；
int num = 0;
for (int i = 0; i < rownumber.Length; i++)
{
int selectedHandle = rownumber[i];
string c_id = gv_KPZPJH.GetRowCellValue(selectedHandle, "C_ID").ToString();
Mod_TRP_PLAN_COGDOWN mod = bll_kp.GetModel(c_id);
if (mod.N_STATUS == 1 && mod.N_GROUP_WGT == 0)
{
if (bll_kp.Delete(c_id))
{
num++;
}
}
}
if (num > 0)
{
MessageBox.Show("需要撤回{" + rownumber.Length + "}条计划，已成功撤回{" + num + "}条计划！");
BindKP();
BindPlan();
}
else
{
MessageBox.Show("撤回失败！");
}
WaitingFrom.CloseWait();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRP_PLAN_COGDOWN GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from TRP_PLAN_COGDOWN ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRP_PLAN_COGDOWN model = new Mod_TRP_PLAN_COGDOWN();
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_xf_Click(object sender, EventArgs e)
{
if (this.icbo_zx3.SelectedIndex < 0)
{
MessageBox.Show("请选择开坯线！");
this.icbo_zx3.Focus();
return;
}
WaitingFrom.ShowWait("");
int[] rownumber = this.gridView1.GetSelectedRows();//获取选中行号数组；
for (int i = 0; i < rownumber.Length; i++)
{
int selectedHandle = rownumber[i];
Mod_TRP_PLAN_COGDOWN mod = new Mod_TRP_PLAN_COGDOWN();
mod.C_ID = System.Guid.NewGuid().ToString();
mod.N_STATUS = 1;
mod.C_ORDER_NO = this.gridView1.GetRowCellValue(selectedHandle, "C_ID").ToString();
// mod.C_INITIALIZE_ITEM_ID = this.gridView1.GetRowCellValue(selectedHandle, "N_JC_SORT").ToString();
// mod.N_SORT = Convert.ToInt32(this.gridView1.GetRowCellValue(selectedHandle, "N_SORT").ToString());
mod.N_WGT = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_SLAB_WGT").ToString());
mod.C_MAT_CODE = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_CODE_KP").ToString();
mod.C_MAT_NAME = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NAME_KP").ToString();
mod.C_SPEC = this.gridView1.GetRowCellValue(selectedHandle, "C_KP_SIZE").ToString();
mod.C_STL_GRD = this.gridView1.GetRowCellValue(selectedHandle, "C_STL_GRD").ToString();
mod.C_STD_CODE = this.gridView1.GetRowCellValue(selectedHandle, "C_STD_CODE").ToString();
mod.N_LENTH = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_KP_LENGTH").ToString());
try
{
mod.D_P_START_TIME = Convert.ToDateTime(this.gridView1.GetRowCellValue(selectedHandle, "D_KP_START_TIME").ToString());
mod.D_P_END_TIME = Convert.ToDateTime(this.gridView1.GetRowCellValue(selectedHandle, "D_KP_END_TIME").ToString());
}
catch (Exception)
{
}
mod.C_STA_ID = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Value.ToString();
mod.C_CAST_NO = this.gridView1.GetRowCellValue(selectedHandle, "C_STOVE_NO").ToString();
mod.C_LINE_DESC = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Description.ToString();
mod.C_FREE1 = this.gridView1.GetRowCellValue(selectedHandle, "C_FREE1").ToString();
mod.C_FREE2 = this.gridView1.GetRowCellValue(selectedHandle, "C_FREE2").ToString();
mod.C_EMP_ID = RV.UI.UserInfo.userID;
mod.D_MOD_DT = RV.UI.ServerTime.timeNow();
mod.N_PW = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_KP_PW").ToString());
mod.C_MATRL_CODE_SLAB = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NO").ToString();
mod.C_MATRL_NAME_SLAB = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NAME").ToString();
mod.C_SLAB_SIZE = this.gridView1.GetRowCellValue(selectedHandle, "C_SLAB_SIZE").ToString();
mod.N_SLAB_LENGTH = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "C_SLAB_LENGTH").ToString());
mod.N_SLAB_PW = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_SLAB_PW").ToString());
Mod_TSP_PLAN_SMS mod_sms = bll_sms.GetModel(mod.C_ORDER_NO);
mod_sms.N_CREAT_ZG_PLAN = 1;
bll_sms.Update(mod_sms);
bll_kp.Add(mod);
}
#region MyRegion
//for (int i = 0; i < rownumber.Length; i++)
//{
// int selectedHandle = rownumber[i];
// Mod_TRP_PLAN_COGDOWN mod = new Mod_TRP_PLAN_COGDOWN();
// mod.C_ID = System.Guid.NewGuid().ToString();
// mod.N_STATUS = 1;
// mod.C_INITIALIZE_ITEM_ID = this.gridView1.GetRowCellValue(selectedHandle, "N_JC_SORT").ToString();
// mod.N_SORT = Convert.ToInt32(this.gridView1.GetRowCellValue(selectedHandle, "N_SORT").ToString());
// mod.N_WGT = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_SLAB_WGT").ToString());
// mod.C_MAT_CODE = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_CODE_KP").ToString();
// mod.C_MAT_NAME = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NAME_KP").ToString();
// mod.C_SPEC = this.gridView1.GetRowCellValue(selectedHandle, "C_KP_SIZE").ToString();
// mod.C_STL_GRD = this.gridView1.GetRowCellValue(selectedHandle, "C_STL_GRD").ToString();
// mod.C_STD_CODE = this.gridView1.GetRowCellValue(selectedHandle, "C_STD_CODE").ToString();
// mod.N_LENTH = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_KP_LENGTH").ToString());
// try
// {
// mod.D_P_START_TIME = Convert.ToDateTime(this.gridView1.GetRowCellValue(selectedHandle, "D_P_START_TIME").ToString());
// mod.D_P_END_TIME = Convert.ToDateTime(this.gridView1.GetRowCellValue(selectedHandle, "D_P_END_TIME").ToString());
// }
// catch (Exception)
// {
// }
// mod.C_STA_ID = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Value.ToString();
// mod.C_FREE1 = this.gridView1.GetRowCellValue(selectedHandle, "C_FREE1").ToString();
// mod.C_FREE2 = this.gridView1.GetRowCellValue(selectedHandle, "C_FREE2").ToString();
// mod.C_EMP_ID = RV.UI.UserInfo.userID;
// mod.D_MOD_DT = RV.UI.ServerTime.timeNow();
// mod.N_PW = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_KP_PW").ToString());
// mod.C_MATRL_CODE_SLAB = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NO").ToString();
// mod.C_MATRL_NAME_SLAB = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NAME").ToString();
// mod.C_SLAB_SIZE = this.gridView1.GetRowCellValue(selectedHandle, "C_SLAB_SIZE").ToString();
// mod.N_SLAB_LENGTH = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "C_SLAB_LENGTH").ToString());
// mod.N_SLAB_PW = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_SLAB_PW").ToString());
// bll_sms.Down_KP(mod.C_STL_GRD, mod.C_MATRL_CODE_SLAB, mod.C_STD_CODE, mod.C_MAT_CODE, mod.C_INITIALIZE_ITEM_ID);
// bll_kp.Add(mod);
//}
#endregion
btn_query_zg_Click(null, null);
btn_query_kpplan_Click(null, null);
WaitingFrom.CloseWait();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRP_PLAN_COGDOWN DataRowToModel(DataRow row)
{
Mod_TRP_PLAN_COGDOWN model = new Mod_TRP_PLAN_COGDOWN();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["C_INITIALIZE_ITEM_ID"] != null)
{
model.C_INITIALIZE_ITEM_ID = row["C_INITIALIZE_ITEM_ID"].ToString();
}
if (row["C_ORDER_NO"] != null)
{
model.C_ORDER_NO = row["C_ORDER_NO"].ToString();
}
if (row["N_WGT"] != null && row["N_WGT"].ToString() != "")
{
model.N_WGT = decimal.Parse(row["N_WGT"].ToString());
}
if (row["C_MAT_CODE"] != null)
{
model.C_MAT_CODE = row["C_MAT_CODE"].ToString();
}
if (row["C_MAT_NAME"] != null)
{
model.C_MAT_NAME = row["C_MAT_NAME"].ToString();
}
if (row["C_TECH_PROT"] != null)
{
model.C_TECH_PROT = row["C_TECH_PROT"].ToString();
}
if (row["C_SPEC"] != null)
{
model.C_SPEC = row["C_SPEC"].ToString();
}
if (row["C_STL_GRD"] != null)
{
model.C_STL_GRD = row["C_STL_GRD"].ToString();
}
if (row["C_STD_CODE"] != null)
{
model.C_STD_CODE = row["C_STD_CODE"].ToString();
}
if (row["N_USER_LEV"] != null && row["N_USER_LEV"].ToString() != "")
{
model.N_USER_LEV = decimal.Parse(row["N_USER_LEV"].ToString());
}
if (row["N_STL_GRD_LEV"] != null && row["N_STL_GRD_LEV"].ToString() != "")
{
model.N_STL_GRD_LEV = decimal.Parse(row["N_STL_GRD_LEV"].ToString());
}
if (row["N_ORDER_LEV"] != null && row["N_ORDER_LEV"].ToString() != "")
{
model.N_ORDER_LEV = decimal.Parse(row["N_ORDER_LEV"].ToString());
}
if (row["C_QUALIRY_LEV"] != null)
{
model.C_QUALIRY_LEV = row["C_QUALIRY_LEV"].ToString();
}
if (row["D_NEED_DT"] != null && row["D_NEED_DT"].ToString() != "")
{
model.D_NEED_DT = DateTime.Parse(row["D_NEED_DT"].ToString());
}
if (row["D_DELIVERY_DT"] != null && row["D_DELIVERY_DT"].ToString() != "")
{
model.D_DELIVERY_DT = DateTime.Parse(row["D_DELIVERY_DT"].ToString());
}
if (row["D_DT"] != null && row["D_DT"].ToString() != "")
{
model.D_DT = DateTime.Parse(row["D_DT"].ToString());
}
if (row["C_LINE_DESC"] != null)
{
model.C_LINE_DESC = row["C_LINE_DESC"].ToString();
}
if (row["C_LINE_CODE"] != null)
{
model.C_LINE_CODE = row["C_LINE_CODE"].ToString();
}
if (row["D_P_START_TIME"] != null && row["D_P_START_TIME"].ToString() != "")
{
model.D_P_START_TIME = DateTime.Parse(row["D_P_START_TIME"].ToString());
}
if (row["D_P_END_TIME"] != null && row["D_P_END_TIME"].ToString() != "")
{
model.D_P_END_TIME = DateTime.Parse(row["D_P_END_TIME"].ToString());
}
if (row["N_PROD_TIME"] != null && row["N_PROD_TIME"].ToString() != "")
{
model.N_PROD_TIME = decimal.Parse(row["N_PROD_TIME"].ToString());
}
if (row["N_SORT"] != null && row["N_SORT"].ToString() != "")
{
model.N_SORT = decimal.Parse(row["N_SORT"].ToString());
}
if (row["N_ROLL_PROD_WGT"] != null && row["N_ROLL_PROD_WGT"].ToString() != "")
{
model.N_ROLL_PROD_WGT = decimal.Parse(row["N_ROLL_PROD_WGT"].ToString());
}
if (row["C_ROLL_PROD_EMP_ID"] != null)
{
model.C_ROLL_PROD_EMP_ID = row["C_ROLL_PROD_EMP_ID"].ToString();
}
if (row["C_STL_ROL_DT"] != null)
{
model.C_STL_ROL_DT = row["C_STL_ROL_DT"].ToString();
}
if (row["N_PROD_WGT"] != null && row["N_PROD_WGT"].ToString() != "")
{
model.N_PROD_WGT = decimal.Parse(row["N_PROD_WGT"].ToString());
}
if (row["N_WARE_WGT"] != null && row["N_WARE_WGT"].ToString() != "")
{
model.N_WARE_WGT = decimal.Parse(row["N_WARE_WGT"].ToString());
}
if (row["N_WARE_OUT_WGT"] != null && row["N_WARE_OUT_WGT"].ToString() != "")
{
model.N_WARE_OUT_WGT = decimal.Parse(row["N_WARE_OUT_WGT"].ToString());
}
if (row["N_FLAG"] != null && row["N_FLAG"].ToString() != "")
{
model.N_FLAG = decimal.Parse(row["N_FLAG"].ToString());
}
if (row["N_ISSUE_WGT"] != null && row["N_ISSUE_WGT"].ToString() != "")
{
model.N_ISSUE_WGT = decimal.Parse(row["N_ISSUE_WGT"].ToString());
}
if (row["C_CUST_NO"] != null)
{
model.C_CUST_NO = row["C_CUST_NO"].ToString();
}
if (row["C_CUST_NAME"] != null)
{
model.C_CUST_NAME = row["C_CUST_NAME"].ToString();
}
if (row["C_SALE_CHANNEL"] != null)
{
model.C_SALE_CHANNEL = row["C_SALE_CHANNEL"].ToString();
}
if (row["C_PACK"] != null)
{
model.C_PACK = row["C_PACK"].ToString();
}
if (row["C_DESIGN_NO"] != null)
{
model.C_DESIGN_NO = row["C_DESIGN_NO"].ToString();
}
if (row["N_GROUP_WGT"] != null && row["N_GROUP_WGT"].ToString() != "")
{
model.N_GROUP_WGT = decimal.Parse(row["N_GROUP_WGT"].ToString());
}
if (row["C_STA_ID"] != null)
{
model.C_STA_ID = row["C_STA_ID"].ToString();
}
if (row["D_START_TIME"] != null && row["D_START_TIME"].ToString() != "")
{
model.D_START_TIME = DateTime.Parse(row["D_START_TIME"].ToString());
}
if (row["D_END_TIME"] != null && row["D_END_TIME"].ToString() != "")
{
model.D_END_TIME = DateTime.Parse(row["D_END_TIME"].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_ROLL_WGT"] != null && row["N_ROLL_WGT"].ToString() != "")
{
model.N_ROLL_WGT = decimal.Parse(row["N_ROLL_WGT"].ToString());
}
if (row["N_MACH_WGT"] != null && row["N_MACH_WGT"].ToString() != "")
{
model.N_MACH_WGT = decimal.Parse(row["N_MACH_WGT"].ToString());
}
if (row["C_CAST_NO"] != null)
{
model.C_CAST_NO = row["C_CAST_NO"].ToString();
}
if (row["C_INITIALIZE_ID"] != null)
{
model.C_INITIALIZE_ID = row["C_INITIALIZE_ID"].ToString();
}
if (row["N_UPLOADSTATUS"] != null && row["N_UPLOADSTATUS"].ToString() != "")
{
model.N_UPLOADSTATUS = decimal.Parse(row["N_UPLOADSTATUS"].ToString());
}
if (row["C_FREE1"] != null)
{
model.C_FREE1 = row["C_FREE1"].ToString();
}
if (row["C_FREE2"] != null)
{
model.C_FREE2 = row["C_FREE2"].ToString();
}
if (row["N_PW"] != null && row["N_PW"].ToString() != "")
{
model.N_PW = decimal.Parse(row["N_PW"].ToString());
}
if (row["N_LENTH"] != null && row["N_LENTH"].ToString() != "")
{
model.N_LENTH = decimal.Parse(row["N_LENTH"].ToString());
}
if (row["C_MATRL_CODE_SLAB"] != null)
{
model.C_MATRL_CODE_SLAB = row["C_MATRL_CODE_SLAB"].ToString();
}
if (row["C_MATRL_NAME_SLAB"] != null)
{
model.C_MATRL_NAME_SLAB = row["C_MATRL_NAME_SLAB"].ToString();
}
if (row["C_SLAB_SIZE"] != null)
{
model.C_SLAB_SIZE = row["C_SLAB_SIZE"].ToString();
}
if (row["N_SLAB_LENGTH"] != null && row["N_SLAB_LENGTH"].ToString() != "")
{
model.N_SLAB_LENGTH = decimal.Parse(row["N_SLAB_LENGTH"].ToString());
}
if (row["N_SLAB_PW"] != null && row["N_SLAB_PW"].ToString() != "")
{
model.N_SLAB_PW = decimal.Parse(row["N_SLAB_PW"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRP_PLAN_COGDOWN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRP_PLAN_COGDOWN(");
strSql.Append("C_ID,N_STATUS,C_INITIALIZE_ITEM_ID,C_ORDER_NO,N_WGT,C_MAT_CODE,C_MAT_NAME,C_TECH_PROT,C_SPEC,C_STL_GRD,C_STD_CODE,N_USER_LEV,N_STL_GRD_LEV,N_ORDER_LEV,C_QUALIRY_LEV,D_NEED_DT,D_DELIVERY_DT,D_DT,C_LINE_DESC,C_LINE_CODE,D_P_START_TIME,D_P_END_TIME,N_PROD_TIME,N_SORT,N_ROLL_PROD_WGT,C_ROLL_PROD_EMP_ID,C_STL_ROL_DT,N_PROD_WGT,N_WARE_WGT,N_WARE_OUT_WGT,N_FLAG,N_ISSUE_WGT,C_CUST_NO,C_CUST_NAME,C_SALE_CHANNEL,C_PACK,C_DESIGN_NO,N_GROUP_WGT,C_STA_ID,D_START_TIME,D_END_TIME,C_EMP_ID,D_MOD_DT,N_ROLL_WGT,N_MACH_WGT,C_CAST_NO,C_INITIALIZE_ID,N_UPLOADSTATUS,C_FREE1,C_FREE2,N_PW,N_LENTH,C_MATRL_CODE_SLAB,C_MATRL_NAME_SLAB,C_SLAB_SIZE,N_SLAB_LENGTH,N_SLAB_PW)");
strSql.Append(" values (");
strSql.Append(":C_ID,:N_STATUS,:C_INITIALIZE_ITEM_ID,:C_ORDER_NO,:N_WGT,:C_MAT_CODE,:C_MAT_NAME,:C_TECH_PROT,:C_SPEC,:C_STL_GRD,:C_STD_CODE,:N_USER_LEV,:N_STL_GRD_LEV,:N_ORDER_LEV,:C_QUALIRY_LEV,:D_NEED_DT,:D_DELIVERY_DT,:D_DT,:C_LINE_DESC,:C_LINE_CODE,:D_P_START_TIME,:D_P_END_TIME,:N_PROD_TIME,:N_SORT,:N_ROLL_PROD_WGT,:C_ROLL_PROD_EMP_ID,:C_STL_ROL_DT,:N_PROD_WGT,:N_WARE_WGT,:N_WARE_OUT_WGT,:N_FLAG,:N_ISSUE_WGT,:C_CUST_NO,:C_CUST_NAME,:C_SALE_CHANNEL,:C_PACK,:C_DESIGN_NO,:N_GROUP_WGT,:C_STA_ID,:D_START_TIME,:D_END_TIME,:C_EMP_ID,:D_MOD_DT,:N_ROLL_WGT,:N_MACH_WGT,:C_CAST_NO,:C_INITIALIZE_ID,:N_UPLOADSTATUS,:C_FREE1,:C_FREE2,:N_PW,:N_LENTH,:C_MATRL_CODE_SLAB,:C_MATRL_NAME_SLAB,:C_SLAB_SIZE,:N_SLAB_LENGTH,:N_SLAB_PW)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_INITIALIZE_ITEM_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TECH_PROT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_USER_LEV", OracleDbType.Decimal, 5),
new OracleParameter(":N_STL_GRD_LEV", OracleDbType.Decimal, 5),
new OracleParameter(":N_ORDER_LEV", OracleDbType.Decimal, 5),
new OracleParameter(":C_QUALIRY_LEV", OracleDbType.Varchar2, 100),
new OracleParameter(":D_NEED_DT", OracleDbType.Date),
new OracleParameter(":D_DELIVERY_DT", OracleDbType.Date),
new OracleParameter(":D_DT", OracleDbType.Date),
new OracleParameter(":C_LINE_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LINE_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":D_P_START_TIME", OracleDbType.Date),
new OracleParameter(":D_P_END_TIME", OracleDbType.Date),
new OracleParameter(":N_PROD_TIME", OracleDbType.Decimal, 5),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 5),
new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_ROLL_PROD_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_ROL_DT", OracleDbType.Varchar2, 100),
new OracleParameter(":N_PROD_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_WARE_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_WARE_OUT_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_FLAG", OracleDbType.Decimal, 5),
new OracleParameter(":N_ISSUE_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_CUST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SALE_CHANNEL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PACK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":N_GROUP_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_START_TIME", OracleDbType.Date),
new OracleParameter(":D_END_TIME", OracleDbType.Date),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_ROLL_WGT", OracleDbType.Decimal, 5),
new OracleParameter(":N_MACH_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_CAST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_UPLOADSTATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_FREE1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FREE2", OracleDbType.Varchar2, 100),
new OracleParameter(":N_PW", OracleDbType.Decimal, 15),
new OracleParameter(":N_LENTH", OracleDbType.Decimal, 15),
new OracleParameter(":C_MATRL_CODE_SLAB", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MATRL_NAME_SLAB", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLAB_SIZE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SLAB_LENGTH", OracleDbType.Decimal, 15),
new OracleParameter(":N_SLAB_PW", OracleDbType.Decimal, 15)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.N_STATUS;
parameters[2].Value = model.C_INITIALIZE_ITEM_ID;
parameters[3].Value = model.C_ORDER_NO;
parameters[4].Value = model.N_WGT;
parameters[5].Value = model.C_MAT_CODE;
parameters[6].Value = model.C_MAT_NAME;
parameters[7].Value = model.C_TECH_PROT;
parameters[8].Value = model.C_SPEC;
parameters[9].Value = model.C_STL_GRD;
parameters[10].Value = model.C_STD_CODE;
parameters[11].Value = model.N_USER_LEV;
parameters[12].Value = model.N_STL_GRD_LEV;
parameters[13].Value = model.N_ORDER_LEV;
parameters[14].Value = model.C_QUALIRY_LEV;
parameters[15].Value = model.D_NEED_DT;
parameters[16].Value = model.D_DELIVERY_DT;
parameters[17].Value = model.D_DT;
parameters[18].Value = model.C_LINE_DESC;
parameters[19].Value = model.C_LINE_CODE;
parameters[20].Value = model.D_P_START_TIME;
parameters[21].Value = model.D_P_END_TIME;
parameters[22].Value = model.N_PROD_TIME;
parameters[23].Value = model.N_SORT;
parameters[24].Value = model.N_ROLL_PROD_WGT;
parameters[25].Value = model.C_ROLL_PROD_EMP_ID;
parameters[26].Value = model.C_STL_ROL_DT;
parameters[27].Value = model.N_PROD_WGT;
parameters[28].Value = model.N_WARE_WGT;
parameters[29].Value = model.N_WARE_OUT_WGT;
parameters[30].Value = model.N_FLAG;
parameters[31].Value = model.N_ISSUE_WGT;
parameters[32].Value = model.C_CUST_NO;
parameters[33].Value = model.C_CUST_NAME;
parameters[34].Value = model.C_SALE_CHANNEL;
parameters[35].Value = model.C_PACK;
parameters[36].Value = model.C_DESIGN_NO;
parameters[37].Value = model.N_GROUP_WGT;
parameters[38].Value = model.C_STA_ID;
parameters[39].Value = model.D_START_TIME;
parameters[40].Value = model.D_END_TIME;
parameters[41].Value = model.C_EMP_ID;
parameters[42].Value = model.D_MOD_DT;
parameters[43].Value = model.N_ROLL_WGT;
parameters[44].Value = model.N_MACH_WGT;
parameters[45].Value = model.C_CAST_NO;
parameters[46].Value = model.C_INITIALIZE_ID;
parameters[47].Value = model.N_UPLOADSTATUS;
parameters[48].Value = model.C_FREE1;
parameters[49].Value = model.C_FREE2;
parameters[50].Value = model.N_PW;
parameters[51].Value = model.N_LENTH;
parameters[52].Value = model.C_MATRL_CODE_SLAB;
parameters[53].Value = model.C_MATRL_NAME_SLAB;
parameters[54].Value = model.C_SLAB_SIZE;
parameters[55].Value = model.N_SLAB_LENGTH;
parameters[56].Value = model.N_SLAB_PW;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void btn_xf_Click(object sender, EventArgs e)
{
if (this.icbo_zx3.SelectedIndex < 0)
{
MessageBox.Show("请选择开坯线！");
this.icbo_zx3.Focus();
return;
}
int[] rownumber = gridView1.GetSelectedRows();//获取选中行号数组；
if (rownumber.Length == 0)
{
MessageBox.Show("请选择需要下发的计划！");
return;
}
DataRow row = gridView1.GetDataRow(rownumber[0]);
for (int i = 0; i < rownumber.Length; i++)
{
DataRow dr = gridView1.GetDataRow(rownumber[i]);
if (dr["C_STL_GRD"].ToString() != row["C_STL_GRD"].ToString() ||
dr["C_STD_CODE"].ToString() != row["C_STD_CODE"].ToString() ||
dr["C_MAT_CODE"].ToString() != row["C_MAT_CODE"].ToString() ||
dr["C_SPEC"].ToString() != row["C_SPEC"].ToString() ||
dr["N_LEN"].ToString() != row["N_LEN"].ToString() ||
dr["C_ZYX1"].ToString() != row["C_ZYX1"].ToString() ||
dr["C_ZYX2"].ToString() != row["C_ZYX2"].ToString())
{
MessageBox.Show("选择需要下发的开坯计划信息不一致，请重新选择！");
return;
}
}
if (string.IsNullOrEmpty(btn_mat_code.Text.Trim()) || string.IsNullOrEmpty(txt_mat_name.Text.Trim()) || string.IsNullOrEmpty(txt_Slab_Size.Text.Trim()) || string.IsNullOrEmpty(txt_Len.Text.Trim()) || string.IsNullOrEmpty(strHsl))
{
MessageBox.Show("热轧坯物料编码有误！");
return;
}
else
{
if (DialogResult.No == MessageBox.Show("确认下发 物料：" + btn_mat_code.Text.Trim() + "断面：" + txt_Slab_Size.Text.Trim() + "*" + txt_Len.Text.Trim() + "的开坯计划吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1))
{
return;
}
}
WaitingFrom.ShowWait("");
for (int i = 0; i < rownumber.Length; i++)
{
DataRow dr = gridView1.GetDataRow(rownumber[i]);
int i_sort = bll_kp.Get_Max_Sort() + 1;
Mod_TB_MATRL_MAIN modWl = bll_wl.GetModel(btn_mat_code.Text.Trim());
if (modWl == null)
{
MessageBox.Show("没有找到热轧坯物料编码，不能下发！");
return;
}
else
{
if (modWl.C_STL_GRD != dr["C_STL_GRD"].ToString())
{
MessageBox.Show("热轧坯钢种和大方坯钢种不一致，不能下发！");
return;
}
}
Mod_TRP_PLAN_COGDOWN mod = new Mod_TRP_PLAN_COGDOWN();
mod.C_ID = System.Guid.NewGuid().ToString();
mod.N_STATUS = 1;
mod.C_INITIALIZE_ITEM_ID = "";
mod.N_SORT = i_sort;
mod.N_WGT = Convert.ToDecimal(dr["N_WGT"].ToString());
mod.C_MAT_CODE = btn_mat_code.Text.Trim();
mod.C_MAT_NAME = txt_mat_name.Text.Trim();
mod.C_SPEC = txt_Slab_Size.Text.Trim();
mod.C_STL_GRD = dr["C_STL_GRD"].ToString();
mod.C_STD_CODE = dr["C_STD_CODE"].ToString();
mod.N_LENTH = Convert.ToDecimal(txt_Len.Text.Trim());
try
{
mod.D_P_START_TIME = RV.UI.ServerTime.timeNow();
mod.D_P_END_TIME = Convert.ToDateTime(mod.D_P_START_TIME).AddHours(Convert.ToDouble(mod.N_WGT / 114));
}
catch
{
}
mod.C_STA_ID = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Value.ToString();
mod.C_CAST_NO = dr["C_STOVE"].ToString();
mod.C_LINE_DESC = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Description.ToString();
mod.C_FREE1 = dr["C_ZYX1"].ToString();
mod.C_FREE2 = dr["C_ZYX2"].ToString();
mod.C_EMP_ID = RV.UI.UserInfo.userID;
mod.D_MOD_DT = RV.UI.ServerTime.timeNow();
mod.N_PW = Convert.ToDecimal(strHsl);
mod.C_MATRL_CODE_SLAB = dr["C_MAT_CODE"].ToString();
mod.C_MATRL_NAME_SLAB = dr["C_MAT_NAME"].ToString();
mod.C_SLAB_SIZE = dr["C_SPEC"].ToString();
mod.N_SLAB_LENGTH = Convert.ToDecimal(dr["N_LEN"].ToString());
Mod_TB_MATRL_MAIN modMaterMain = bll_wl.GetModel(dr["C_MAT_CODE"].ToString());
if (modMaterMain != null)
{
mod.N_SLAB_PW = modMaterMain.N_HSL;
}
bll_kp.Add(mod);
}
BindKP();
BindPlan();
WaitingFrom.CloseWait();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRP_PLAN_COGDOWN model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRP_PLAN_COGDOWN model)
{
return(dal.Add(model));
}
