/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPP_CAST DataRowToModel(DataRow row)
{
Mod_TPP_CAST model = new Mod_TPP_CAST();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_CAST_NO"] != null)
{
model.C_CAST_NO = row["C_CAST_NO"].ToString();
}
if (row["C_CAST_LS"] != null)
{
model.C_CAST_LS = row["C_CAST_LS"].ToString();
}
if (row["N_CAST_WGT"] != null && row["N_CAST_WGT"].ToString() != "")
{
model.N_CAST_WGT = decimal.Parse(row["N_CAST_WGT"].ToString());
}
if (row["N_SORT"] != null && row["N_SORT"].ToString() != "")
{
model.N_SORT = decimal.Parse(row["N_SORT"].ToString());
}
if (row["C_INITIALIZE_ITEM"] != null)
{
model.C_INITIALIZE_ITEM = row["C_INITIALIZE_ITEM"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].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["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "")
{
model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString());
}
if (row["C_CCM_ID"] != null)
{
model.C_CCM_ID = row["C_CCM_ID"].ToString();
}
if (row["N_SFZJC"] != null && row["N_SFZJC"].ToString() != "")
{
model.N_SFZJC = decimal.Parse(row["N_SFZJC"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TPP_CAST model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TPP_CAST set ");
strSql.Append("C_CAST_NO=:C_CAST_NO,");
strSql.Append("C_CAST_LS=:C_CAST_LS,");
strSql.Append("N_CAST_WGT=:N_CAST_WGT,");
strSql.Append("N_SORT=:N_SORT,");
strSql.Append("C_INITIALIZE_ITEM=:C_INITIALIZE_ITEM,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_CCM_ID=:C_CCM_ID,");
strSql.Append("N_SFZJC=:N_SFZJC");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_CAST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CAST_LS", OracleDbType.Varchar2, 100),
new OracleParameter(":N_CAST_WGT", OracleDbType.Double, 15),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 1),
new OracleParameter(":C_INITIALIZE_ITEM", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_CCM_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SFZJC", OracleDbType.Decimal, 1),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_CAST_NO;
parameters[1].Value = model.C_CAST_LS;
parameters[2].Value = model.N_CAST_WGT;
parameters[3].Value = model.N_SORT;
parameters[4].Value = model.C_INITIALIZE_ITEM;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.C_REMARK;
parameters[7].Value = model.C_EMP_ID;
parameters[8].Value = model.D_MOD_DT;
parameters[9].Value = model.C_CCM_ID;
parameters[10].Value = model.N_SFZJC;
parameters[11].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_CAST model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TPP_CAST(");
strSql.Append("C_CAST_NO,C_CAST_LS,N_CAST_WGT,N_SORT,C_INITIALIZE_ITEM,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_CCM_ID,N_SFZJC)");
strSql.Append(" values (");
strSql.Append(":C_CAST_NO,:C_CAST_LS,:N_CAST_WGT,:N_SORT,:C_INITIALIZE_ITEM,:N_STATUS,:C_REMARK,:C_EMP_ID,:D_MOD_DT,:C_CCM_ID,:N_SFZJC)");
OracleParameter[] parameters =
{
new OracleParameter(":C_CAST_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CAST_LS", OracleDbType.Varchar2, 100),
new OracleParameter(":N_CAST_WGT", OracleDbType.Double, 15),
new OracleParameter(":N_SORT", OracleDbType.Decimal, 3),
new OracleParameter(":C_INITIALIZE_ITEM", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_CCM_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_SFZJC", OracleDbType.Decimal, 1),
};
parameters[0].Value = model.C_CAST_NO;
parameters[1].Value = model.C_CAST_LS;
parameters[2].Value = model.N_CAST_WGT;
parameters[3].Value = model.N_SORT;
parameters[4].Value = model.C_INITIALIZE_ITEM;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.C_REMARK;
parameters[7].Value = model.C_EMP_ID;
parameters[8].Value = model.D_MOD_DT;
parameters[9].Value = model.C_CCM_ID;
parameters[10].Value = model.N_SFZJC;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPP_CAST GetModel(string str_SORT, string C_CCM_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CAST_NO,C_CAST_LS,N_CAST_WGT,N_SORT,C_INITIALIZE_ITEM,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_CCM_ID,N_SFZJC from TPP_CAST ");
strSql.Append(" where N_SORT='" + str_SORT + "' and C_CCM_ID='" + C_CCM_ID + "' and rownum=1 ");
Mod_TPP_CAST model = new Mod_TPP_CAST();
DataSet ds = DbHelperOra.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 修改生产顺序
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_XGZG_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.No == MessageBox.Show("是否确认修改？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1))
{
return;
}
DataRow dr = this.gv_SJXX.GetDataRow(this.gv_SJXX.FocusedRowHandle);
if (dr == null)
{
return;
}
string stype = "";
if (Convert.ToInt32(cbo_SCSX1.Text.ToString()) > Convert.ToInt32(dr["N_SORT"].ToString()))
{
stype = "0";
}
else
{
stype = "1";
}
bll_tpp_cast.Update_SX(dr["C_ID"].ToString(), dr["C_CCM_ID"].ToString(), dr["C_INITIALIZE_ITEM"].ToString(), Convert.ToInt32(cbo_SCSX1.Text.ToString()), Convert.ToInt32(dr["N_SORT"].ToString()), stype);
Mod_TPP_CAST mod = bll_tpp_cast.GetModel(dr["C_ID"].ToString());
mod.N_SORT = Convert.ToInt32(cbo_SCSX1.Text.ToString());
bll_tpp_cast.Update(mod);//修改浇次计划顺序
bll_tpp_cast.Update_LG_Plan(dr["C_INITIALIZE_ITEM"].ToString(), dr["C_CCM_ID"].ToString());
btn_Query_Main_Click(null, null);
MessageBox.Show("修改成功！");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TPP_CAST GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_CAST_NO,C_CAST_LS,N_CAST_WGT,N_SORT,C_INITIALIZE_ITEM,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_CCM_ID,N_SFZJC from TPP_CAST ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TPP_CAST model = new Mod_TPP_CAST();
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>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Save2_Click(object sender, EventArgs e)
{
try
{
if (DialogResult.No == MessageBox.Show("是否确认添加计划？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1))
{
return;
}
string user_id = RV.UI.UserInfo.userID;
for (int i = 0; i < dt_Group.Rows.Count; i++)
{
DataRow dr = dt_Group.Rows[i];
string strLS = dr["整浇次炉数"].ToString();//浇次炉数
if (string.IsNullOrEmpty(strLS))
{
MessageBox.Show("没查到符合条件的浇次炉数信息，不能安排生产计划！");
return;
}
double d_WGT = Convert.ToDouble(dr["整浇次重量"].ToString()) / Convert.ToDouble(strLS);//炉次重量
if (d_WGT <= 0)
{
MessageBox.Show("没查到符合条件的炉次重量，不能安排生产计划！");
return;
}
double jc_wgt = Convert.ToDouble(dr["整浇次重量"].ToString()); //浇次理论总重量
int jc_num = Convert.ToInt32(dr["排产浇次数"].ToString()); //可以排整浇次数
string str_CC_ID = dr["连铸主键"].ToString();
for (int kk = 0; kk < jc_num; kk++)
{
int sort_plan = 1;
int cast_sort = bll_TPP_CAST.GetMaxSort(str_CC_ID) + 1; //该方案下浇次顺序号
string cast_no = bll_TPP_CAST.GetMaxCastNo(str_CC_ID); //获取最大浇次号
if (cast_no == "0")
{
cast_no = DateTime.Now.ToString("yyyyMMdd") + bll_TB_STA.Get_STA_CODE(str_CC_ID).Substring(0, 1) + "00001";
}
else
{
cast_no = (Convert.ToInt64(cast_no) + 1).ToString();
}
#region 浇次计划主表信息
Mod_TPP_CAST modCast = new Mod_TPP_CAST();
modCast.C_CAST_NO = cast_no; //浇次号
modCast.C_CAST_LS = strLS; //浇次炉数
modCast.N_CAST_WGT = Convert.ToDecimal(jc_wgt); //浇次总重量
modCast.N_SORT = cast_sort; //生产顺序
modCast.C_CCM_ID = str_CC_ID; //铸机号主键
modCast.N_SFZJC = 1;
bll_TPP_CAST.Add(modCast);
#endregion
for (int mm = 0; mm < Convert.ToInt32(strLS); mm++)
{
Mod_TMO_ORDER mod_Order = bll_TMO_ORDER.Get_PC_ORDER(dr["组号"].ToString());
if (mod_Order == null)
{
break;
}
string str_PLAN_SMS_ID = bll_TSP_PLAN_SMS.GetMax_PlanID();
if (str_PLAN_SMS_ID == "0")
{
str_PLAN_SMS_ID = DateTime.Now.ToString("yyyyMM") + "00001";
}
else
{
str_PLAN_SMS_ID = (Convert.ToInt64(str_PLAN_SMS_ID) + 1).ToString();
}
Mod_TSP_PLAN_SMS modTspPlanSms = new Mod_TSP_PLAN_SMS();
//modTspPlanSms.C_PLAN_SMS_ID = str_PLAN_SMS_ID;//计划号
modTspPlanSms.C_CAST_NO = cast_no;
modTspPlanSms.N_SORT = sort_plan;
modTspPlanSms.C_CCM_ID = str_CC_ID;
modTspPlanSms.C_CCM_DESC = dr["连铸"].ToString();
modTspPlanSms.C_STD_CODE = dr["连铸代码"].ToString();
modTspPlanSms.C_STL_GRD = dr["C_STL_GRD"].ToString();
//modTspPlanSms.N_WGT_PROD = Convert.ToDecimal(d_WGT);
modTspPlanSms.C_ORDER_NO = mod_Order.C_ORDER_NO;
modTspPlanSms.C_EMP_ID = user_id;
string strEndTime = RV.UI.ServerTime.timeNow().ToString();
if (sort_plan == 1)
{
Mod_TPP_CAST modCastOld = bll_TPP_CAST.GetModel((cast_sort - 1).ToString(), str_CC_ID);
if (modCastOld != null)
{
strEndTime = bll_TSP_PLAN_SMS.Get_EndTime(modCastOld.C_CAST_NO, modCastOld.C_CAST_LS);
if (strEndTime == "0")
{
strEndTime = RV.UI.ServerTime.timeNow().ToString();
}
}
}
else
{
strEndTime = bll_TSP_PLAN_SMS.Get_EndTime(cast_no, (sort_plan - 1).ToString());
if (strEndTime == "0")
{
strEndTime = RV.UI.ServerTime.timeNow().ToString();
}
}
modTspPlanSms.D_P_START_TIME = Convert.ToDateTime(strEndTime);
double scTime = Convert.ToDouble(d_WGT) / Convert.ToDouble(dr["机时产能"].ToString());
modTspPlanSms.D_P_END_TIME = Convert.ToDateTime(modTspPlanSms.D_P_START_TIME).AddHours(scTime);
bll_TSP_PLAN_SMS.Add(modTspPlanSms);
decimal dec_Wgt = Convert.ToDecimal(mod_Order.N_WGT - mod_Order.N_SLAB_MATCH_WGT - mod_Order.N_SMS_PROD_WGT);
////判断计划是否需要跨订单
//if (dec_Wgt >= 0)
//{
// mod_Order.N_SMS_PROD_WGT = Convert.ToDecimal(d_WGT);
// bll_TMO_ORDER.Update(mod_Order);//变更订单排产重量
// #region 添加计划明细
// Mod_TSP_PLAN_SMS_ITEM mod_plan_sms_item = new Mod_TSP_PLAN_SMS_ITEM();
// mod_plan_sms_item.C_PRODUCTION_PLAN_ID = dr["C_ID"].ToString();
// mod_plan_sms_item.C_PLAN_SMS_ID = mod_TSP_PLAN_SMS.C_PLAN_SMS_ID;//计划号
// mod_plan_sms_item.N_WGT = mod_TSP_PLAN_SMS.N_WGT_PROD;//计划重量
// mod_plan_sms_item.C_EMP_ID = user_id;
// bll_TSP_PLAN_SMS_MAIN.Add(mod_plan_sms_item);
// #endregion
//}
//else
//{
// Mod_TPP_INITIALIZE_ORDER mod_TPPINITIALIZEORDER = bll_ini_order.GetModel(dr["C_ID"].ToString());
// mod_TPPINITIALIZEORDER.N_SMS_PROD_WGT = mod_TPPINITIALIZEORDER.N_WGT;
// if (mod_TPPINITIALIZEORDER.N_SMS_PROD_WGT >= 0)
// {
// mod_TPPINITIALIZEORDER.N_LGPC_STATUS = 1;
// }
// bll_ini_order.Update(mod_TPPINITIALIZEORDER);//变更方案计划表数据
// #region 添加计划明细
// Mod_TSP_PLAN_SMS_ITEM mod_plan_sms_item1 = new Mod_TSP_PLAN_SMS_ITEM();
// mod_plan_sms_item1.C_PRODUCTION_PLAN_ID = dr["C_ID"].ToString();
// mod_plan_sms_item1.C_PLAN_SMS_ID = mod_TSP_PLAN_SMS.C_PLAN_SMS_ID;//计划号
// mod_plan_sms_item1.N_WGT = Convert.ToDecimal(dd_wgt + d_WGT);//计划重量
// mod_plan_sms_item1.C_EMP_ID = user_id;
// bll_TSP_PLAN_SMS_MAIN.Add(mod_plan_sms_item1);
// #endregion
// decimal dd = Convert.ToDecimal(d_WGT - (dd_wgt + d_WGT));
// foreach (DataRow dr2 in orderdt.Rows)
// {
// Mod_TPP_INITIALIZE_ORDER mod_TPPINITIALIZEORDER2 = bll_ini_order.GetModel(dr2["C_ID"].ToString());
// if (mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT == mod_TPPINITIALIZEORDER2.N_WGT)
// {
// continue;
// }
// if (mod_TPPINITIALIZEORDER2.N_WGT >= dd)
// {
// mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT = (mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT != null ? mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT : 0) + dd;
// if (mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT >= 0)
// {
// mod_TPPINITIALIZEORDER2.N_LGPC_STATUS = 1;
// }
// bll_ini_order.Update(mod_TPPINITIALIZEORDER2);//变更方案计划表数据
// #region 添加计划明细
// Mod_TSP_PLAN_SMS_ITEM mod_plan_sms_item2 = new Mod_TSP_PLAN_SMS_ITEM();
// mod_plan_sms_item2.C_PRODUCTION_PLAN_ID = dr2["C_ID"].ToString();
// mod_plan_sms_item2.C_PLAN_SMS_ID = mod_TSP_PLAN_SMS.C_PLAN_SMS_ID;//计划号
// mod_plan_sms_item2.N_WGT = dd;//计划重量
// mod_plan_sms_item2.C_EMP_ID = user_id;
// bll_TSP_PLAN_SMS_MAIN.Add(mod_plan_sms_item2);
// #endregion
// break;
// }
// else
// {
// mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT = (mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT != null ? mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT : 0) + mod_TPPINITIALIZEORDER2.N_WGT;
// if (mod_TPPINITIALIZEORDER2.N_SMS_PROD_WGT >= mod_TPPINITIALIZEORDER2.N_WGT)
// {
// mod_TPPINITIALIZEORDER2.N_LGPC_STATUS = 1;
// }
// bll_ini_order.Update(mod_TPPINITIALIZEORDER2);//变更方案计划表数据
// #region 添加计划明细
// Mod_TSP_PLAN_SMS_ITEM mod_plan_sms_item2 = new Mod_TSP_PLAN_SMS_ITEM();
// mod_plan_sms_item2.C_PRODUCTION_PLAN_ID = dr2["C_ID"].ToString();
// mod_plan_sms_item2.C_PLAN_SMS_ID = mod_TSP_PLAN_SMS.C_PLAN_SMS_ID;//计划号
// mod_plan_sms_item2.N_WGT = mod_TPPINITIALIZEORDER2.N_WGT;//计划重量
// mod_plan_sms_item2.C_EMP_ID = user_id;
// bll_TSP_PLAN_SMS_MAIN.Add(mod_plan_sms_item2);
// #endregion
// }
// dd = Convert.ToDecimal(dd - mod_TPPINITIALIZEORDER2.N_WGT);
// }
//}
} //mm
} //kk
} //i
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TPP_CAST model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TPP_CAST model)
{
return(dal.Add(model));
}
