/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_PLAN_REGROUND_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_PLAN_REGROUND_ITEM set ");
strSql.Append("C_PLAN_REGROUND_ID=:C_PLAN_REGROUND_ID,");
strSql.Append("C_SLAB_MAIN_ID=:C_SLAB_MAIN_ID,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("N_STEP=:N_STEP,");
strSql.Append("N_TOTALSTEP=:N_TOTALSTEP,");
strSql.Append("N_STEPNAME=:N_STEPNAME,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT");
strSql.Append("C_STA_ID=:C_STA_ID");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_PLAN_REGROUND_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLAB_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":N_STEP", OracleDbType.Decimal, 2),
new OracleParameter(":N_TOTALSTEP", OracleDbType.Decimal, 2),
new OracleParameter(":N_STEPNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 2),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PLAN_REGROUND_ID;
parameters[1].Value = model.C_SLAB_MAIN_ID;
parameters[2].Value = model.C_REMARK;
parameters[3].Value = model.N_STEP;
parameters[4].Value = model.N_TOTALSTEP;
parameters[5].Value = model.N_STEPNAME;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.C_EMP_ID;
parameters[8].Value = model.D_MOD_DT;
parameters[9].Value = model.C_STA_ID;
parameters[10].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_PLAN_REGROUND_ITEM DataRowToModel(DataRow row)
{
Mod_TRC_PLAN_REGROUND_ITEM model = new Mod_TRC_PLAN_REGROUND_ITEM();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_PLAN_REGROUND_ID"] != null)
{
model.C_PLAN_REGROUND_ID = row["C_PLAN_REGROUND_ID"].ToString();
}
if (row["C_SLAB_MAIN_ID"] != null)
{
model.C_SLAB_MAIN_ID = row["C_SLAB_MAIN_ID"].ToString();
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["N_STEP"] != null && row["N_STEP"].ToString() != "")
{
model.N_STEP = decimal.Parse(row["N_STEP"].ToString());
}
if (row["N_TOTALSTEP"] != null && row["N_TOTALSTEP"].ToString() != "")
{
model.N_TOTALSTEP = decimal.Parse(row["N_TOTALSTEP"].ToString());
}
if (row["N_STEPNAME"] != null)
{
model.N_STEPNAME = row["N_STEPNAME"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].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_STA_ID"] != null && row["C_STA_ID"].ToString() != "")
{
model.C_STA_ID = row["C_STA_ID"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_PLAN_REGROUND_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_PLAN_REGROUND_ITEM(");
strSql.Append("C_PLAN_REGROUND_ID,C_SLAB_MAIN_ID,C_REMARK,N_STEP,N_TOTALSTEP,N_STEPNAME,N_STATUS,C_EMP_ID,D_MOD_DT,C_STA_ID)");
strSql.Append(" values (");
strSql.Append(":C_PLAN_REGROUND_ID,:C_SLAB_MAIN_ID,:C_REMARK,:N_STEP,:N_TOTALSTEP,:N_STEPNAME,:N_STATUS,:C_EMP_ID,:D_MOD_DT,:C_STA_ID)");
OracleParameter[] parameters =
{
new OracleParameter(":C_PLAN_REGROUND_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SLAB_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":N_STEP", OracleDbType.Decimal, 2),
new OracleParameter(":N_TOTALSTEP", OracleDbType.Decimal, 2),
new OracleParameter(":N_STEPNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 2),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_PLAN_REGROUND_ID;
parameters[1].Value = model.C_SLAB_MAIN_ID;
parameters[2].Value = model.C_REMARK;
parameters[3].Value = model.N_STEP;
parameters[4].Value = model.N_TOTALSTEP;
parameters[5].Value = model.N_STEPNAME;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.C_EMP_ID;
parameters[8].Value = model.D_MOD_DT;
parameters[9].Value = model.C_STA_ID;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_PLAN_REGROUND_ITEM GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_PLAN_REGROUND_ID,C_SLAB_MAIN_ID,C_REMARK,N_STEP,N_TOTALSTEP,N_STEPNAME,N_STATUS,C_EMP_ID,D_MOD_DT,C_STA_ID from TRC_PLAN_REGROUND_ITEM ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_PLAN_REGROUND_ITEM model = new Mod_TRC_PLAN_REGROUND_ITEM();
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="stove">炉号</param>
/// <param name="batchNo">批号</param>
/// <param name="grd">钢种</param>
/// <param name="spec">规格</param>
/// <param name="std">执行标准</param>
/// <param name="matCode">物料编码</param>
/// <param name="matName">物料名称</param>
/// <param name="len">长度</param>
/// <param name="factNum">支数</param>
/// <param name="reGroundWork">修磨工序</param>
/// <param name="shift">班次</param>
/// <param name="group">班组</param>
/// <param name="remark">备注</param>
/// <param name="slabwhCode">仓库编码</param>
/// <param name="wgt">重量</param>
/// <param name="grdXMGX"></param>
/// <param name="store">仓库编码</param>
/// <param name="area">区域编码</param>
/// <param name="kw">库位</param>
/// <param name="floor">层</param>
/// <param name="dept">部门</param>
/// <param name="slabArea">钢坯区域</param>
/// <param name="slabLoc">钢坯地址</param>
/// <param name="isxm">是否修磨</param>
/// <param name="gx">标准</param>
/// <param name="gw">工位</param>
/// <param name="sl">砂轮</param>
/// <returns></returns>
public string CreateRegroundPlan(string stove, string batchNo, string grd,
string spec, string std, string matCode, string matName, string len, string factNum,
string reGroundWork, string shift, string group, string remark, string slabwhCode, decimal wgt
, string grdXMGX, string store, string area, string kw, string floor, string dept, string slabArea, string slabLoc, string isxm
, string gx, string gw, string sl, string xlloc, string emp)
{
DataTable dt = dal.GetWaitRegroudSlabs(slabwhCode, batchNo, stove, grd, spec, std, matCode, len, factNum, slabArea, slabLoc, isxm).Tables[0];
string result = "1";
TransactionHelper.BeginTransaction();
try
{
Mod_TRC_PLAN_REGROUND reground = new Mod_TRC_PLAN_REGROUND();
reground.C_ID = Guid.NewGuid().ToString();
reground.C_BATCH_NO = batchNo;
reground.C_STOVE = stove;
reground.C_STL_GRD = grd;
reground.C_MAT_CODE = matCode;
reground.C_MAT_NAME = matName;
reground.C_SPEC = spec;
reground.N_LEN = decimal.Parse(len);
reground.N_QUA = decimal.Parse(factNum);
reground.N_WGT = wgt;
reground.C_STD_CODE = std;
reground.C_REMARK = remark;
reground.C_XMGX = reGroundWork;
var arr = reGroundWork.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries);
reground.N_TOTALSTEP = arr.Length;
reground.N_QUA_VIRTUAL = decimal.Parse(factNum);
reground.C_SLABWH_CODE = store;
reground.C_SLABWH_AREA_CODE = area;
reground.C_SLABWH_LOC_CODE = kw;
reground.C_SLABWH_TIER_CODE = floor;
reground.C_XMGX_GRD = grdXMGX;
reground.C_SLAB_TYPE = dept;
reground.C_EXTEND16 = gx;
reground.C_EXTEND17 = gw;
reground.C_EXTEND18 = sl;
reground.C_EMP_CODE = emp;
reground.C_SLABWH_XLLOC_CODE = xlloc;
if (!dal.Add(reground))
{
TransactionHelper.RollBack();
return("0");
}
if (dt == null || dt.Rows.Count == 0)
{
TransactionHelper.RollBack();
return("0");
}
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < arr.Length; j++)
{
Mod_TRC_PLAN_REGROUND_ITEM item = new Mod_TRC_PLAN_REGROUND_ITEM();
item.C_PLAN_REGROUND_ID = reground.C_ID;
item.C_SLAB_MAIN_ID = dt.Rows[i]["C_ID"].ToString();
item.N_TOTALSTEP = arr.Length;
item.N_STEP = j + 1;
item.N_STEPNAME = arr[j];
item.N_STATUS = item.N_STEP == 1 ? 1 : 0;
item.C_EMP_ID = RV.UI.UserInfo.userID;
if (!itemDal.Add(item))
{
TransactionHelper.RollBack();
return("0");
}
}
}
if (dal.UpdateSlabStatus(dt, "DX", "E", store, area, kw, floor) != int.Parse(factNum))
{
TransactionHelper.RollBack();
return("0");
}
TransactionHelper.Commit();
}
catch (Exception ex)
{
TransactionHelper.RollBack();
return("0");
}
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_PLAN_REGROUND_ITEM model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_PLAN_REGROUND_ITEM model)
{
return(dal.Add(model));
}
