/// <summary>
/// 连铸调整
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_fp_lz_Click(object sender, EventArgs e)
{
int[] rownumber = this.gv_ini_order.GetSelectedRows();//获取选中行号数组；
if (rownumber.Length > 0)
{
for (int i = 0; i < rownumber.Length; i++)
{
int selectedHandle = rownumber[i];
string strId = gv_ini_order.GetRowCellValue(selectedHandle, "C_ID").ToString();
Mod_TPP_INITIALIZE_ORDER mod = bll_ini_order.GetModel(strId);
mod.C_CCM_STA_ID = this.cbo_lz3.Properties.Items[this.cbo_lz3.SelectedIndex].Value.ToString();
bll_ini_order.Update(mod);
}
btn_query_ycsh_Click(null, null);
MessageBox.Show("连铸调整成功！");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPP_INITIALIZE_ORDER GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_INITIALIZE_ID,C_ORDER_ID,N_WGT,N_MACH_WGT,C_DESIGN_NO,N_STATUS,N_FLAG,C_RH,C_LF,C_KP,N_HL_TIME,C_HL,N_DFP_HL_TIME,C_DFP_HL,C_XM,C_ROLL_STA_ID,C_CCM_STA_ID,N_MACH_WGT_CCM,N_LGPC_STATUS,N_EXEC_STATUS,N_ROLL_PROD_WGT,N_SMS_PROD_WGT,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_MATRL_CODE_SLAB,C_MATRL_NAME_SLAB,C_SLAB_SIZE,N_SLAB_LENGTH,N_SLAB_PW,C_MATRL_CODE_KP,C_MATRL_NAME_KP,C_KP_SIZE,N_KP_LENGTH,N_KP_PW,C_ROUTE,N_GROUP,N_SORT,C_XC,C_SL,C_WL,C_ORDERNO,C_CONNO from TPP_INITIALIZE_ORDER ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TPP_INITIALIZE_ORDER model = new Mod_TPP_INITIALIZE_ORDER();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TPP_INITIALIZE_ORDER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TPP_INITIALIZE_ORDER(");
strSql.Append("C_INITIALIZE_ID,C_ORDER_ID,N_WGT,N_MACH_WGT,C_DESIGN_NO,C_RH,C_LF,C_KP,N_HL_TIME,C_HL,N_DFP_HL_TIME,C_DFP_HL,C_XM,C_ROLL_STA_ID,C_CCM_STA_ID,N_MACH_WGT_CCM,N_LGPC_STATUS,N_EXEC_STATUS,N_ROLL_PROD_WGT,N_SMS_PROD_WGT,C_REMARK,C_EMP_ID,C_EMP_NAME,C_MATRL_CODE_SLAB,C_MATRL_NAME_SLAB,C_SLAB_SIZE,N_SLAB_LENGTH,N_SLAB_PW,C_MATRL_CODE_KP,C_MATRL_NAME_KP,C_KP_SIZE,N_KP_LENGTH,N_KP_PW,C_ROUTE,N_GROUP,N_SORT,C_XC,C_SL,C_WL,C_ORDERNO,C_CONNO)");
strSql.Append(" values (");
strSql.Append(":C_INITIALIZE_ID,:C_ORDER_ID,:N_WGT,:N_MACH_WGT,:C_DESIGN_NO,:C_RH,:C_LF,:C_KP,:N_HL_TIME,:C_HL,:N_DFP_HL_TIME,:C_DFP_HL,:C_XM,:C_ROLL_STA_ID,:C_CCM_STA_ID,:N_MACH_WGT_CCM,:N_LGPC_STATUS,:N_EXEC_STATUS,:N_ROLL_PROD_WGT,:N_SMS_PROD_WGT,:C_REMARK,:C_EMP_ID,:C_EMP_NAME,:C_MATRL_CODE_SLAB,:C_MATRL_NAME_SLAB,:C_SLAB_SIZE,:N_SLAB_LENGTH,:N_SLAB_PW,:C_MATRL_CODE_KP,:C_MATRL_NAME_KP,:C_KP_SIZE,:N_KP_LENGTH,:N_KP_PW,:C_ROUTE,:N_GROUP,:N_SORT,:C_XC,:C_SL,:C_WL,:C_ORDERNO,:C_CONNO)");
OracleParameter[] parameters =
{
new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_MACH_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LF", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":N_HL_TIME", OracleDbType.Decimal, 4),
new OracleParameter(":C_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Decimal, 4),
new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Decimal, 15),
new OracleParameter(":N_LGPC_STATUS", OracleDbType.Decimal, 4),
new OracleParameter(":N_EXEC_STATUS", OracleDbType.Decimal, 4),
new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
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),
new OracleParameter(":C_MATRL_CODE_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MATRL_NAME_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KP_SIZE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_KP_LENGTH", OracleDbType.Decimal, 15),
new OracleParameter(":N_KP_PW", OracleDbType.Decimal, 15),
new OracleParameter(":C_ROUTE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_GROUP", OracleDbType.Decimal, 4),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 4),
new OracleParameter(":C_XC", OracleDbType.Varchar2, 10),
new OracleParameter(":C_SL", OracleDbType.Varchar2, 10),
new OracleParameter(":C_WL", OracleDbType.Varchar2, 10),
new OracleParameter(":C_ORDERNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONNO", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_INITIALIZE_ID;
parameters[1].Value = model.C_ORDER_ID;
parameters[2].Value = model.N_WGT;
parameters[3].Value = model.N_MACH_WGT;
parameters[4].Value = model.C_DESIGN_NO;
parameters[5].Value = model.C_RH;
parameters[6].Value = model.C_LF;
parameters[7].Value = model.C_KP;
parameters[8].Value = model.N_HL_TIME;
parameters[9].Value = model.C_HL;
parameters[10].Value = model.N_DFP_HL_TIME;
parameters[11].Value = model.C_DFP_HL;
parameters[12].Value = model.C_XM;
parameters[13].Value = model.C_ROLL_STA_ID;
parameters[14].Value = model.C_CCM_STA_ID;
parameters[15].Value = model.N_MACH_WGT_CCM;
parameters[16].Value = model.N_LGPC_STATUS;
parameters[17].Value = model.N_EXEC_STATUS;
parameters[18].Value = model.N_ROLL_PROD_WGT;
parameters[19].Value = model.N_SMS_PROD_WGT;
parameters[20].Value = model.C_REMARK;
parameters[21].Value = model.C_EMP_ID;
parameters[22].Value = model.C_EMP_NAME;
parameters[23].Value = model.C_MATRL_CODE_SLAB;
parameters[24].Value = model.C_MATRL_NAME_SLAB;
parameters[25].Value = model.C_SLAB_SIZE;
parameters[26].Value = model.N_SLAB_LENGTH;
parameters[27].Value = model.N_SLAB_PW;
parameters[28].Value = model.C_MATRL_CODE_KP;
parameters[29].Value = model.C_MATRL_NAME_KP;
parameters[30].Value = model.C_KP_SIZE;
parameters[31].Value = model.N_KP_LENGTH;
parameters[32].Value = model.N_KP_PW;
parameters[33].Value = model.C_ROUTE;
parameters[34].Value = model.N_GROUP;
parameters[35].Value = model.N_SORT;
parameters[36].Value = model.C_XC;
parameters[37].Value = model.C_SL;
parameters[38].Value = model.C_WL;
parameters[39].Value = model.C_ORDERNO;
parameters[40].Value = model.C_CONNO;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPP_INITIALIZE_ORDER DataRowToModel(DataRow row)
{
Mod_TPP_INITIALIZE_ORDER model = new Mod_TPP_INITIALIZE_ORDER();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_INITIALIZE_ID"] != null)
{
model.C_INITIALIZE_ID = row["C_INITIALIZE_ID"].ToString();
}
if (row["C_ORDER_ID"] != null)
{
model.C_ORDER_ID = row["C_ORDER_ID"].ToString();
}
if (row["N_WGT"] != null && row["N_WGT"].ToString() != "")
{
model.N_WGT = decimal.Parse(row["N_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_DESIGN_NO"] != null)
{
model.C_DESIGN_NO = row["C_DESIGN_NO"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["N_FLAG"] != null && row["N_FLAG"].ToString() != "")
{
model.N_FLAG = decimal.Parse(row["N_FLAG"].ToString());
}
if (row["C_RH"] != null)
{
model.C_RH = row["C_RH"].ToString();
}
if (row["C_LF"] != null)
{
model.C_LF = row["C_LF"].ToString();
}
if (row["C_KP"] != null)
{
model.C_KP = row["C_KP"].ToString();
}
if (row["N_HL_TIME"] != null && row["N_HL_TIME"].ToString() != "")
{
model.N_HL_TIME = decimal.Parse(row["N_HL_TIME"].ToString());
}
if (row["C_HL"] != null)
{
model.C_HL = row["C_HL"].ToString();
}
if (row["N_DFP_HL_TIME"] != null && row["N_DFP_HL_TIME"].ToString() != "")
{
model.N_DFP_HL_TIME = decimal.Parse(row["N_DFP_HL_TIME"].ToString());
}
if (row["C_DFP_HL"] != null)
{
model.C_DFP_HL = row["C_DFP_HL"].ToString();
}
if (row["C_XM"] != null)
{
model.C_XM = row["C_XM"].ToString();
}
if (row["C_ROLL_STA_ID"] != null)
{
model.C_ROLL_STA_ID = row["C_ROLL_STA_ID"].ToString();
}
if (row["C_CCM_STA_ID"] != null)
{
model.C_CCM_STA_ID = row["C_CCM_STA_ID"].ToString();
}
if (row["N_MACH_WGT_CCM"] != null && row["N_MACH_WGT_CCM"].ToString() != "")
{
model.N_MACH_WGT_CCM = decimal.Parse(row["N_MACH_WGT_CCM"].ToString());
}
if (row["N_LGPC_STATUS"] != null && row["N_LGPC_STATUS"].ToString() != "")
{
model.N_LGPC_STATUS = decimal.Parse(row["N_LGPC_STATUS"].ToString());
}
if (row["N_EXEC_STATUS"] != null && row["N_EXEC_STATUS"].ToString() != "")
{
model.N_EXEC_STATUS = decimal.Parse(row["N_EXEC_STATUS"].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["N_SMS_PROD_WGT"] != null && row["N_SMS_PROD_WGT"].ToString() != "")
{
model.N_SMS_PROD_WGT = decimal.Parse(row["N_SMS_PROD_WGT"].ToString());
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["C_EMP_ID"] != null)
{
model.C_EMP_ID = row["C_EMP_ID"].ToString();
}
if (row["C_EMP_NAME"] != null)
{
model.C_EMP_NAME = row["C_EMP_NAME"].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["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());
}
if (row["C_MATRL_CODE_KP"] != null)
{
model.C_MATRL_CODE_KP = row["C_MATRL_CODE_KP"].ToString();
}
if (row["C_MATRL_NAME_KP"] != null)
{
model.C_MATRL_NAME_KP = row["C_MATRL_NAME_KP"].ToString();
}
if (row["C_KP_SIZE"] != null)
{
model.C_KP_SIZE = row["C_KP_SIZE"].ToString();
}
if (row["N_KP_LENGTH"] != null && row["N_KP_LENGTH"].ToString() != "")
{
model.N_KP_LENGTH = decimal.Parse(row["N_KP_LENGTH"].ToString());
}
if (row["N_KP_PW"] != null && row["N_KP_PW"].ToString() != "")
{
model.N_KP_PW = decimal.Parse(row["N_KP_PW"].ToString());
}
if (row["C_ROUTE"] != null)
{
model.C_ROUTE = row["C_ROUTE"].ToString();
}
if (row["N_GROUP"] != null && row["N_GROUP"].ToString() != "")
{
model.N_GROUP = decimal.Parse(row["N_GROUP"].ToString());
}
if (row["N_SORT"] != null && row["N_SORT"].ToString() != "")
{
model.N_SORT = decimal.Parse(row["N_SORT"].ToString());
}
if (row["C_XC"] != null)
{
model.C_XC = row["C_XC"].ToString();
}
if (row["C_SL"] != null)
{
model.C_SL = row["C_SL"].ToString();
}
if (row["C_WL"] != null)
{
model.C_WL = row["C_WL"].ToString();
}
if (row["C_ORDERNO"] != null)
{
model.C_ORDERNO = row["C_ORDERNO"].ToString();
}
if (row["C_CONNO"] != null)
{
model.C_CONNO = row["C_CONNO"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TPP_INITIALIZE_ORDER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TPP_INITIALIZE_ORDER set ");
strSql.Append("C_INITIALIZE_ID=:C_INITIALIZE_ID,");
strSql.Append("C_ORDER_ID=:C_ORDER_ID,");
strSql.Append("N_WGT=:N_WGT,");
strSql.Append("N_MACH_WGT=:N_MACH_WGT,");
strSql.Append("C_DESIGN_NO=:C_DESIGN_NO,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("N_FLAG=:N_FLAG,");
strSql.Append("C_RH=:C_RH,");
strSql.Append("C_LF=:C_LF,");
strSql.Append("C_KP=:C_KP,");
strSql.Append("N_HL_TIME=:N_HL_TIME,");
strSql.Append("C_HL=:C_HL,");
strSql.Append("N_DFP_HL_TIME=:N_DFP_HL_TIME,");
strSql.Append("C_DFP_HL=:C_DFP_HL,");
strSql.Append("C_XM=:C_XM,");
strSql.Append("C_ROLL_STA_ID=:C_ROLL_STA_ID,");
strSql.Append("C_CCM_STA_ID=:C_CCM_STA_ID,");
strSql.Append("N_MACH_WGT_CCM=:N_MACH_WGT_CCM,");
strSql.Append("N_LGPC_STATUS=:N_LGPC_STATUS,");
strSql.Append("N_EXEC_STATUS=:N_EXEC_STATUS,");
strSql.Append("N_ROLL_PROD_WGT=:N_ROLL_PROD_WGT,");
strSql.Append("N_SMS_PROD_WGT=:N_SMS_PROD_WGT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_MATRL_CODE_SLAB=:C_MATRL_CODE_SLAB,");
strSql.Append("C_MATRL_NAME_SLAB=:C_MATRL_NAME_SLAB,");
strSql.Append("C_SLAB_SIZE=:C_SLAB_SIZE,");
strSql.Append("N_SLAB_LENGTH=:N_SLAB_LENGTH,");
strSql.Append("N_SLAB_PW=:N_SLAB_PW,");
strSql.Append("C_MATRL_CODE_KP=:C_MATRL_CODE_KP,");
strSql.Append("C_MATRL_NAME_KP=:C_MATRL_NAME_KP,");
strSql.Append("C_KP_SIZE=:C_KP_SIZE,");
strSql.Append("N_KP_LENGTH=:N_KP_LENGTH,");
strSql.Append("N_KP_PW=:N_KP_PW,");
strSql.Append("C_ROUTE=:C_ROUTE,");
strSql.Append("N_GROUP=:N_GROUP,");
strSql.Append("N_SORT=:N_SORT,");
strSql.Append("C_XC=:C_XC,");
strSql.Append("C_SL=:C_SL,");
strSql.Append("C_WL=:C_WL,");
strSql.Append("C_ORDERNO=:C_ORDERNO,");
strSql.Append("C_CONNO=:C_CONNO");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_MACH_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 4),
new OracleParameter(":N_FLAG", OracleDbType.Decimal, 4),
new OracleParameter(":C_RH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LF", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":N_HL_TIME", OracleDbType.Decimal, 4),
new OracleParameter(":C_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Decimal, 4),
new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Decimal, 15),
new OracleParameter(":N_LGPC_STATUS", OracleDbType.Decimal, 4),
new OracleParameter(":N_EXEC_STATUS", OracleDbType.Decimal, 4),
new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Decimal, 15),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
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),
new OracleParameter(":C_MATRL_CODE_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MATRL_NAME_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KP_SIZE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_KP_LENGTH", OracleDbType.Decimal, 15),
new OracleParameter(":N_KP_PW", OracleDbType.Decimal, 15),
new OracleParameter(":C_ROUTE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_GROUP", OracleDbType.Decimal, 4),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 4),
new OracleParameter(":C_XC", OracleDbType.Varchar2, 10),
new OracleParameter(":C_SL", OracleDbType.Varchar2, 10),
new OracleParameter(":C_WL", OracleDbType.Varchar2, 10),
new OracleParameter(":C_ORDERNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_INITIALIZE_ID;
parameters[1].Value = model.C_ORDER_ID;
parameters[2].Value = model.N_WGT;
parameters[3].Value = model.N_MACH_WGT;
parameters[4].Value = model.C_DESIGN_NO;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.N_FLAG;
parameters[7].Value = model.C_RH;
parameters[8].Value = model.C_LF;
parameters[9].Value = model.C_KP;
parameters[10].Value = model.N_HL_TIME;
parameters[11].Value = model.C_HL;
parameters[12].Value = model.N_DFP_HL_TIME;
parameters[13].Value = model.C_DFP_HL;
parameters[14].Value = model.C_XM;
parameters[15].Value = model.C_ROLL_STA_ID;
parameters[16].Value = model.C_CCM_STA_ID;
parameters[17].Value = model.N_MACH_WGT_CCM;
parameters[18].Value = model.N_LGPC_STATUS;
parameters[19].Value = model.N_EXEC_STATUS;
parameters[20].Value = model.N_ROLL_PROD_WGT;
parameters[21].Value = model.N_SMS_PROD_WGT;
parameters[22].Value = model.C_REMARK;
parameters[23].Value = model.C_EMP_ID;
parameters[24].Value = model.C_EMP_NAME;
parameters[25].Value = model.D_MOD_DT;
parameters[26].Value = model.C_MATRL_CODE_SLAB;
parameters[27].Value = model.C_MATRL_NAME_SLAB;
parameters[28].Value = model.C_SLAB_SIZE;
parameters[29].Value = model.N_SLAB_LENGTH;
parameters[30].Value = model.N_SLAB_PW;
parameters[31].Value = model.C_MATRL_CODE_KP;
parameters[32].Value = model.C_MATRL_NAME_KP;
parameters[33].Value = model.C_KP_SIZE;
parameters[34].Value = model.N_KP_LENGTH;
parameters[35].Value = model.N_KP_PW;
parameters[36].Value = model.C_ROUTE;
parameters[37].Value = model.N_GROUP;
parameters[38].Value = model.N_SORT;
parameters[39].Value = model.C_XC;
parameters[40].Value = model.C_SL;
parameters[41].Value = model.C_WL;
parameters[42].Value = model.C_ORDERNO;
parameters[43].Value = model.C_CONNO;
parameters[44].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TPP_INITIALIZE_ORDER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TPP_INITIALIZE_ORDER(");
strSql.Append("C_INITIALIZE_ID,C_ORDER_ID,N_WGT,N_MACH_WGT,C_DESIGN_NO,N_STATUS,N_FLAG,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_RH,C_LF,C_KP,N_HL_TIME,C_HL,N_DFP_HL_TIME,C_DFP_HL,C_XM,C_ROLL_STA_ID,C_CCM_STA_ID,N_MACH_WGT_CCM,N_LGPC_STATUS,N_EXEC_STATUS,N_ROLL_PROD_WGT,N_SMS_PROD_WGT)");
strSql.Append(" values (");
strSql.Append(":C_INITIALIZE_ID,:C_ORDER_ID,:N_WGT,:N_MACH_WGT,:C_DESIGN_NO,:N_STATUS,:N_FLAG,:C_REMARK,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT,:C_RH,:C_LF,:C_KP,:N_HL_TIME,:C_HL,:N_DFP_HL_TIME,:C_DFP_HL,:C_XM,:C_ROLL_STA_ID,:C_CCM_STA_ID,:N_MACH_WGT_CCM,:N_LGPC_STATUS,:N_EXEC_STATUS,:N_ROLL_PROD_WGT,:N_SMS_PROD_WGT)");
OracleParameter[] parameters =
{
new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Int16, 15),
new OracleParameter(":N_MACH_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_FLAG", OracleDbType.Int16, 2),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_RH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LF", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":N_HL_TIME", OracleDbType.Int16, 10),
new OracleParameter(":C_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Int16, 10),
new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Int16, 15),
new OracleParameter(":N_LGPC_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_EXEC_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Int16, 15),
new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Int16, 15)
};
parameters[0].Value = model.C_INITIALIZE_ID;
parameters[1].Value = model.C_ORDER_ID;
parameters[2].Value = model.N_WGT;
parameters[3].Value = model.N_MACH_WGT;
parameters[4].Value = model.C_DESIGN_NO;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.N_FLAG;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.C_EMP_NAME;
parameters[10].Value = model.D_MOD_DT;
parameters[11].Value = model.C_RH;
parameters[12].Value = model.C_LF;
parameters[13].Value = model.C_KP;
parameters[14].Value = model.N_HL_TIME;
parameters[15].Value = model.C_HL;
parameters[16].Value = model.N_DFP_HL_TIME;
parameters[17].Value = model.C_DFP_HL;
parameters[18].Value = model.C_XM;
parameters[19].Value = model.C_ROLL_STA_ID;
parameters[20].Value = model.C_CCM_STA_ID;
parameters[21].Value = model.N_MACH_WGT_CCM;
parameters[22].Value = model.N_LGPC_STATUS;
parameters[23].Value = model.N_EXEC_STATUS;
parameters[24].Value = model.N_ROLL_PROD_WGT;
parameters[25].Value = model.N_SMS_PROD_WGT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TPP_INITIALIZE_ORDER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TPP_INITIALIZE_ORDER set ");
strSql.Append("C_INITIALIZE_ID=:C_INITIALIZE_ID,");
strSql.Append("C_ORDER_ID=:C_ORDER_ID,");
strSql.Append("N_WGT=:N_WGT,");
strSql.Append("N_MACH_WGT=:N_MACH_WGT,");
strSql.Append("C_DESIGN_NO=:C_DESIGN_NO,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("N_FLAG=:N_FLAG,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_RH=:C_RH,");
strSql.Append("C_LF=:C_LF,");
strSql.Append("C_KP=:C_KP,");
strSql.Append("N_HL_TIME=:N_HL_TIME,");
strSql.Append("C_HL=:C_HL,");
strSql.Append("N_DFP_HL_TIME=:N_DFP_HL_TIME,");
strSql.Append("C_DFP_HL=:C_DFP_HL,");
strSql.Append("C_XM=:C_XM,");
strSql.Append("C_ROLL_STA_ID=:C_ROLL_STA_ID,");
strSql.Append("C_CCM_STA_ID=:C_CCM_STA_ID,");
strSql.Append("N_MACH_WGT_CCM=:N_MACH_WGT_CCM,");
strSql.Append("N_LGPC_STATUS=:N_LGPC_STATUS,");
strSql.Append("N_EXEC_STATUS=:N_EXEC_STATUS,");
strSql.Append("N_ROLL_PROD_WGT=:N_ROLL_PROD_WGT,");
strSql.Append("N_SMS_PROD_WGT=:N_SMS_PROD_WGT");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_WGT", OracleDbType.Int16, 15),
new OracleParameter(":N_MACH_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_FLAG", OracleDbType.Int16, 2),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_RH", OracleDbType.Varchar2, 100),
new OracleParameter(":C_LF", OracleDbType.Varchar2, 100),
new OracleParameter(":C_KP", OracleDbType.Varchar2, 100),
new OracleParameter(":N_HL_TIME", OracleDbType.Int16, 10),
new OracleParameter(":C_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Int16, 10),
new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Int16, 15),
new OracleParameter(":N_LGPC_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_EXEC_STATUS", OracleDbType.Int16, 2),
new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Int16, 15),
new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Int16, 15),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_INITIALIZE_ID;
parameters[1].Value = model.C_ORDER_ID;
parameters[2].Value = model.N_WGT;
parameters[3].Value = model.N_MACH_WGT;
parameters[4].Value = model.C_DESIGN_NO;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.N_FLAG;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.C_EMP_ID;
parameters[9].Value = model.C_EMP_NAME;
parameters[10].Value = model.D_MOD_DT;
parameters[11].Value = model.C_RH;
parameters[12].Value = model.C_LF;
parameters[13].Value = model.C_KP;
parameters[14].Value = model.N_HL_TIME;
parameters[15].Value = model.C_HL;
parameters[16].Value = model.N_DFP_HL_TIME;
parameters[17].Value = model.C_DFP_HL;
parameters[18].Value = model.C_XM;
parameters[19].Value = model.C_ROLL_STA_ID;
parameters[20].Value = model.C_CCM_STA_ID;
parameters[21].Value = model.N_MACH_WGT_CCM;
parameters[22].Value = model.N_LGPC_STATUS;
parameters[23].Value = model.N_EXEC_STATUS;
parameters[24].Value = model.N_ROLL_PROD_WGT;
parameters[25].Value = model.N_SMS_PROD_WGT;
parameters[26].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 轧钢计划撤销
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_reset_area_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.No == MessageBox.Show("是否确认撤回？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1))
{
return;
}
DataRow dr = gv_ZGJH.GetDataRow(gv_ZGJH.FocusedRowHandle);
Mod_TPP_INITIALIZE_ORDER mod = bll_ini_order.GetModel(dr["C_INITIALIZE_ITEM_ID"].ToString());
if (mod != null)
{
mod.N_ROLL_PROD_WGT = mod.N_ROLL_PROD_WGT - Convert.ToDecimal(dr["N_WGT"].ToString());
if (mod.N_ROLL_PROD_WGT == 0)
{
mod.N_EXEC_STATUS = 0;
}
bll_TRP_PLAN_ROLL.Delete(dr["C_ID"].ToString());
#region 重新计算顺序
bll_TRP_PLAN_ROLL.Update(dr["C_STA_ID"].ToString(), dr["C_INITIALIZE_ID"].ToString(), Convert.ToInt32(dr["N_SORT"].ToString()));
#endregion
#region 重新计算计划时间
int count = bll_TRP_PLAN_ROLL.GetFACount(cbo_FA.EditValue.ToString(), dr["C_STA_ID"].ToString());//该方案下该工位计划数量
int startNum = 1;
startNum = Convert.ToInt32(dr["N_SORT"].ToString());
mod.N_ROLL_PROD_WGT = mod.N_WGT - Convert.ToDecimal(dr["N_ROLL_PROD_WGT"]);
mod.N_EXEC_STATUS = 0;
bll_ini_order.Update(mod);
for (int i = startNum; i <= count; i++)
{
Mod_TRP_PLAN_ROLL mod_TRP_PLAN_ROLL = bll_TRP_PLAN_ROLL.GetModel(i, dr["C_INITIALIZE_ID"].ToString(), dr["C_STA_ID"].ToString());
if (i > 1)
{
DataTable bdt = bll_TRP_PLAN_ROLL.GetList(Convert.ToInt32(mod_TRP_PLAN_ROLL.N_SORT - 1), mod_TRP_PLAN_ROLL.C_INITIALIZE_ITEM_ID, mod_TRP_PLAN_ROLL.C_STA_ID).Tables[0];
DateTime enddt = Convert.ToDateTime(bdt.Rows[0]["D_P_END_TIME"]);//上一计划结束时间
DataTable hggdt = bll_TPB_CHANGESPEC_TIME.GetList(1, mod_TRP_PLAN_ROLL.C_STA_ID, bdt.Rows[0]["C_SPEC"].ToString(), mod_TRP_PLAN_ROLL.C_SPEC).Tables[0];
if (hggdt.Rows.Count > 0)
{
mod_TRP_PLAN_ROLL.D_P_START_TIME = enddt.AddMinutes(Convert.ToDouble(hggdt.Rows[0]["N_TIME"]));
}
else
{
mod_TRP_PLAN_ROLL.D_P_START_TIME = enddt;
}
}
else
{
mod_TRP_PLAN_ROLL.D_P_START_TIME = Convert.ToDateTime(bll_TPP_INITIALIZE_ITEM.GetListByNAME(cbo_FA.Text).Tables[0].Rows[0]["D_ROLL_START_TIME"]);
}
DataTable dataTable = bll_TPB_STATION_CAPACITY.GetList(1, "", mod_TRP_PLAN_ROLL.C_STA_ID, mod_TRP_PLAN_ROLL.C_STL_GRD, mod_TRP_PLAN_ROLL.C_SPEC, mod_TRP_PLAN_ROLL.C_STD_CODE).Tables[0];
string cn = "";
if (dataTable.Rows.Count > 0)
{
cn = dataTable.Rows[0]["N_CAPACITY"].ToString();
}
else
{
cn = "60";
}
double db = Convert.ToDouble(mod_TRP_PLAN_ROLL.N_WGT) / Convert.ToDouble(cn);
DateTime dt = Convert.ToDateTime(mod_TRP_PLAN_ROLL.D_P_START_TIME);
dt = dt.AddHours(Convert.ToDouble(db));
mod_TRP_PLAN_ROLL.D_P_END_TIME = dt;
bll_TRP_PLAN_ROLL.Update(mod_TRP_PLAN_ROLL);
}
MessageBox.Show("撤销成功！");
Query();
Query1();
gv_DDFA_Click();
#endregion
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void PLANADD(int item)
{
DataRow dr = gv_DDFA.GetDataRow(item);
int count = bll_TRP_PLAN_ROLL.GetFACount(cbo_FA.EditValue.ToString(), cbo_GW1.EditValue.ToString());//该方案下该工位计划数量
Mod_TRP_PLAN_ROLL mod_TRP_PLAN_ROLL = new Mod_TRP_PLAN_ROLL();
mod_TRP_PLAN_ROLL.C_INITIALIZE_ID = cbo_FA.EditValue.ToString();
mod_TRP_PLAN_ROLL.C_INITIALIZE_ITEM_ID = dr["C_ID"].ToString();
mod_TRP_PLAN_ROLL.N_SORT = count + 1;
mod_TRP_PLAN_ROLL.C_SPEC = dr["C_SPEC"].ToString();
mod_TRP_PLAN_ROLL.C_STD_CODE = dr["C_STD_CODE"].ToString();
mod_TRP_PLAN_ROLL.C_STL_GRD = dr["C_STL_GRD"].ToString();
mod_TRP_PLAN_ROLL.C_ORDER_NO = dr["C_ORDER_NO"].ToString();
mod_TRP_PLAN_ROLL.C_MAT_NAME = dr["C_MAT_NAME"].ToString();
mod_TRP_PLAN_ROLL.C_MAT_CODE = dr["C_MAT_CODE"].ToString();
mod_TRP_PLAN_ROLL.N_WGT = Convert.ToDecimal(dr["N_WGT"]);
if (dr["C_ROLL_STA_ID"] == null || dr["C_ROLL_STA_ID"].ToString() == "")
{
MessageBox.Show(mod_TRP_PLAN_ROLL.C_STL_GRD + "未分配产线!");
return;
}
mod_TRP_PLAN_ROLL.C_STA_ID = dr["C_ROLL_STA_ID"].ToString();
if (txt_wgt1.Enabled == true)
{
mod_TRP_PLAN_ROLL.N_ROLL_PROD_WGT = Convert.ToDecimal(txt_wgt1.Text);
}
else
{
mod_TRP_PLAN_ROLL.N_ROLL_PROD_WGT = Convert.ToDecimal(dr["N_WGT"]) - Convert.ToDecimal(dr["N_ROLL_PROD_WGT"]);
}
if (mod_TRP_PLAN_ROLL.N_WGT <= 0)
{
return;
}
if (count > 0)
{
DataTable bdt = bll_TRP_PLAN_ROLL.GetList(Convert.ToInt32(mod_TRP_PLAN_ROLL.N_SORT - 1), mod_TRP_PLAN_ROLL.C_INITIALIZE_ID, mod_TRP_PLAN_ROLL.C_STA_ID).Tables[0];
if (bdt.Rows.Count > 0)
{
DateTime enddt = Convert.ToDateTime(bdt.Rows[0]["D_P_END_TIME"]);//上一计划结束时间
DataTable hggdt = bll_TPB_CHANGESPEC_TIME.GetList(1, mod_TRP_PLAN_ROLL.C_STA_ID, bdt.Rows[0]["C_SPEC"].ToString(), mod_TRP_PLAN_ROLL.C_SPEC).Tables[0];
if (hggdt.Rows.Count > 0)
{
mod_TRP_PLAN_ROLL.D_P_START_TIME = enddt.AddMinutes(Convert.ToDouble(hggdt.Rows[0]["N_TIME"]));
}
else
{
mod_TRP_PLAN_ROLL.D_P_START_TIME = enddt;
}
}
}
else
{
mod_TRP_PLAN_ROLL.D_P_START_TIME = DateTime.Now;
}
int cn = 0;
if (!string.IsNullOrEmpty(dr["N_MACH_WGT"].ToString()))
{
cn = Convert.ToInt32(dr["N_MACH_WGT"].ToString());
}
if (cn == 0)
{
cn = 50;
}
double db = Convert.ToDouble(mod_TRP_PLAN_ROLL.N_WGT) / Convert.ToDouble(cn);
DateTime dt = Convert.ToDateTime(mod_TRP_PLAN_ROLL.D_P_START_TIME);
dt = dt.AddHours(Convert.ToDouble(db));
mod_TRP_PLAN_ROLL.D_P_END_TIME = dt;
Mod_TPP_INITIALIZE_ORDER mod_TPP_INITIALIZE_ORDER = bll_ini_order.GetModel(mod_TRP_PLAN_ROLL.C_INITIALIZE_ITEM_ID);
mod_TPP_INITIALIZE_ORDER.N_EXEC_STATUS = 1;
mod_TPP_INITIALIZE_ORDER.N_ROLL_PROD_WGT += mod_TRP_PLAN_ROLL.N_WGT;
bll_ini_order.Update(mod_TPP_INITIALIZE_ORDER); //变更方案计划表数据
bll_TRP_PLAN_ROLL.Add(mod_TRP_PLAN_ROLL); //变更计划表
//DataTable itemdt = bll_TPP_INITIALIZE_ITEM.GetListByNAME(cbo_FA.Text).Tables[0];
////Mod_TPP_INITIALIZE_ITEM mod_TPP_INITIALIZE_ITEM = bll_TPP_INITIALIZE_ITEM.GetModel(itemdt.Rows[0]["C_ID"].ToString());
////mod_TPP_INITIALIZE_ITEM.N_Z_WGT = (mod_TPP_INITIALIZE_ITEM.N_Z_WGT.ToString() == DBNull.Value.ToString() ? 0 : mod_TPP_INITIALIZE_ITEM.N_Z_WGT) + mod_TRP_PLAN_ROLL.N_WGT;
////mod_TPP_INITIALIZE_ITEM.D_ROLL_END_TIME = mod_TRP_PLAN_ROLL.D_P_END_TIME;
////bll_TPP_INITIALIZE_ITEM.Update(mod_TPP_INITIALIZE_ITEM);//变更方案表
//bll_TPP_INITIALIZE_STA.UpdateBySTAFID(cbo_FA.Text, cbo_GW1.EditValue.ToString(), Convert.ToInt32(txt_wgt1.Text));
}
/// <summary>
/// 初始化订单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_csh_Click(object sender, EventArgs e)
{
if (this.rbtn_type.SelectedIndex == 0)
{
DataTable dtdchs = dtwchs.Clone(); //将选中的订单复制到当前DataTable
int[] rownumber = this.gv_wini_order.GetSelectedRows(); //获取选中行号数组；
if (rownumber.Length > 0)
{
for (int i = 0; i < rownumber.Length; i++)
{
int selectedHandle = rownumber[i];
DataRow dr = dtdchs.NewRow();
dr.ItemArray = this.gv_wini_order.GetDataRow(i).ItemArray;
dtdchs.Rows.Add(dr);
}
dtdchs.DefaultView.Sort = " D_DELIVERY_DT, C_LEV "; //将选中的订单按照排产目标进行排序
dtdchs = dtdchs.DefaultView.ToTable(); //获取的需要初始化的表
#region 初始化订单
if (dtdchs.Rows.Count == 0)
{
MessageBox.Show("没有待处理订单！");
return;
}
//将初始化的订单信息添加到表TPP_INITIALIZE_ORDER（初始化订单表）
for (int j = 0; j < dtdchs.Rows.Count; j++)
{
//获取当前方案排产的工位 TPP_INITIALIZE_STA
//自动分配轧线 TPB_LINE_SPEC TPB_N_GRD
//自动分配到连铸 V_GZ_CCM（钢种连铸匹配数据）
//匹配轧线及时产量
//匹配连铸机时产量
Mod_TPP_INITIALIZE_ORDER mod = new Mod_TPP_INITIALIZE_ORDER();
mod.C_INITIALIZE_ID = this.lbl_fazj.Text;
mod.C_ORDER_ID = dtdchs.Rows[j]["C_ID"].ToString();
mod.N_WGT = Convert.ToDecimal(dtdchs.Rows[j]["N_WGT"].ToString());
mod.C_EMP_NAME = RV.UI.UserInfo.userName;
string strSpec = dtdchs.Rows[j]["C_SPEC"].ToString(); //订单规格
string strGZ = dtdchs.Rows[j]["C_STL_GRD"].ToString(); //订单规格
string strBZ = dtdchs.Rows[j]["C_STD_CODE"].ToString(); //订单标准
//自动分配轧钢产线
DataTable dtsta = bll_line_spec.GetLineByWhere(strSpec, this.lbl_fazj.Text, strGZ, strBZ);
if (dtsta.Rows.Count > 0)
{
mod.C_ROLL_STA_ID = dtsta.Rows[0]["C_STA_ID"].ToString();//
mod.N_MACH_WGT = Convert.ToDecimal(dtsta.Rows[0]["N_CAPACITY"].ToString());
}
//自动分配连铸产线
DataTable dtccm = bll_slab_spec.GetOrderCCM(strGZ, strBZ, this.lbl_fazj.Text);
if (dtccm.Rows.Count > 0)
{
mod.C_CCM_STA_ID = dtccm.Rows[0]["C_STA_ID"].ToString();
mod.N_MACH_WGT_CCM = Convert.ToDecimal(dtccm.Rows[0]["N_CAPACITY"].ToString());
#region 获取钢坯物料信息
DataTable dt = bllslabmatch.GetOrderSlabSize(strGZ, strBZ, "").Tables[0];
if (dt.Rows.Count > 0)
{
mod.C_SLAB_SIZE = dt.Rows[0]["C_SLAB_SIZE"].ToString();
mod.N_SLAB_LENGTH = Convert.ToDecimal(dt.Rows[0]["C_COLD_LEN"].ToString());
mod.N_SLAB_PW = Convert.ToDecimal(dt.Rows[0]["C_THE_WEIGHT"].ToString().Trim() == ""?"0": dt.Rows[0]["C_THE_WEIGHT"].ToString());
mod.C_KP_SIZE = dt.Rows[0]["C_SLAB_SIZE_KP"].ToString();
mod.N_KP_LENGTH = Convert.ToDecimal(dt.Rows[0]["C_COLD_LEN_KP"].ToString());
mod.N_KP_PW = Convert.ToDecimal(dt.Rows[0]["C_THE_WEIGHT_KP"].ToString().Trim() == ""?"0": dt.Rows[0]["C_THE_WEIGHT_KP"].ToString().Trim());
}
#endregion
#region 匹配开坯物料信息
#endregion
}
bll_ini_order.Add(mod);
}
btn_query_order_wcsh_Click(null, null);
MessageBox.Show("订单已初始化！");
#endregion
}
else
{
MessageBox.Show("您没有选择需要初始化的订单！");
return;
}
}
else
{
MessageBox.Show("当前订单已初始化！");
return;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TPP_INITIALIZE_ORDER model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TPP_INITIALIZE_ORDER model)
{
return(dal.Add(model));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Save2_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(cbo_FA.Text.Trim()))
{
MessageBox.Show("请选择方案号！");
return;
}
if (string.IsNullOrEmpty(btnEdit_Std.Text.Trim()))
{
MessageBox.Show("请选择执行标准！");
return;
}
if (string.IsNullOrEmpty(txt_Std_Grd.Text.Trim()))
{
MessageBox.Show("请填写钢种！");
return;
}
if (string.IsNullOrEmpty(cbo_CC.Text.Trim()) || cbo_CC.Text == "全部")
{
MessageBox.Show("请选择连铸！");
return;
}
if (string.IsNullOrEmpty(txt_Wgt.Text.Trim()))
{
MessageBox.Show("请填写重量！");
return;
}
else
{
double result = 0;
if (!double.TryParse(txt_Wgt.Text.Trim(), out result))
{
MessageBox.Show("填写的重量不符合规范！");
return;
}
}
Mod_TMO_ORDER modeOrder = new Mod_TMO_ORDER();
modeOrder.C_ORDER_NO = "SD-" + DateTime.Now.ToString("yyyyMMddHHmmss"); //订单号
modeOrder.C_CON_NO = "SD-" + DateTime.Now.ToString("yyyyMMddHHmmss"); //合同号
modeOrder.C_STL_GRD = txt_Std_Grd.Text.Trim(); //钢种
modeOrder.C_STD_CODE = btnEdit_Std.Text.Trim(); //执行标准
modeOrder.N_STATUS = 2; //订单状态
modeOrder.N_WGT = Convert.ToDecimal(txt_Wgt.Text.Trim()); //订单重量
modeOrder.N_TYPE = 6; //6钢坯；8线材
modeOrder.C_EMP_ID = RV.UI.UserInfo.userID;
modeOrder.C_MAT_CODE = txt_MatCode.Text.Trim(); //物料编码
modeOrder.C_MAT_NAME = txt_MatName.Text.Trim(); //物料名称
modeOrder.C_SPEC = txt_Spec.Text.Trim(); //断面
if (bll_TMO_ORDER.Add(modeOrder))
{
string s_id = bll_TMO_ORDER.Get_ID(modeOrder.C_ORDER_NO, modeOrder.C_CON_NO, modeOrder.C_STL_GRD, modeOrder.C_STD_CODE);
Mod_TPP_INITIALIZE_ORDER modINITIALIZEORDER = new Mod_TPP_INITIALIZE_ORDER();
modINITIALIZEORDER.C_INITIALIZE_ID = cbo_FA.EditValue.ToString();
modINITIALIZEORDER.C_ORDER_ID = s_id;
modINITIALIZEORDER.N_WGT = Convert.ToDecimal(txt_Wgt.Text.Trim());//订单重量
modINITIALIZEORDER.C_CCM_STA_ID = cbo_CC.EditValue.ToString();
modINITIALIZEORDER.C_EMP_ID = RV.UI.UserInfo.userID;
bll_ini_order.Add(modINITIALIZEORDER);
MessageBox.Show("订单手动增加成功！");
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "手动添加订单");//添加操作日志
}
}
