/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_WGD_HANDLER GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_STA_ID,C_WGD_ID,C_STOVE,C_BATCH_NO,C_PLAN_ID,D_MOD_DT,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,C_PACK,C_FREE_TERM,C_FREE_TERM2,C_MRSX,C_MAT_CODE,C_MAT_DESC,C_PCLX,C_NEWMRSX,C_NEWPCLX,C_NEW_STD_CODE,C_NEW_STL_GRD,C_NEW_SPEC,C_NEW_PACK,C_NEW_FREE_TERM,C_NEW_FREE_TERM2,C_NEW_MAT_CODE,C_NEW_MAT_DESC,C_SX,C_NEW_SX from TRC_ROLL_WGD_HANDLER ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_ROLL_WGD_HANDLER model = new Mod_TRC_ROLL_WGD_HANDLER();
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 Update(Mod_TRC_ROLL_WGD_HANDLER model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_WGD_HANDLER model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_WGD_HANDLER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_ROLL_WGD_HANDLER(");
strSql.Append("C_STA_ID,C_WGD_ID,C_STOVE,C_BATCH_NO,C_PLAN_ID,D_MOD_DT,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,C_PACK,C_FREE_TERM,C_FREE_TERM2,C_MRSX,C_MAT_CODE,C_MAT_DESC,C_PCLX,C_NEWMRSX,C_NEWPCLX,C_NEW_STD_CODE,C_NEW_STL_GRD,C_NEW_SPEC,C_NEW_PACK,C_NEW_FREE_TERM,C_NEW_FREE_TERM2,C_NEW_MAT_CODE,C_NEW_MAT_DESC,C_SX,C_NEW_SX)");
strSql.Append(" values (");
strSql.Append(":C_STA_ID,:C_WGD_ID,:C_STOVE,:C_BATCH_NO,:C_PLAN_ID,:D_MOD_DT,:N_STATUS,:C_STD_CODE,:C_STL_GRD,:C_SPEC,:C_PACK,:C_FREE_TERM,:C_FREE_TERM2,:C_MRSX,:C_MAT_CODE,:C_MAT_DESC,:C_PCLX,:C_NEWMRSX,:C_NEWPCLX,:C_NEW_STD_CODE,:C_NEW_STL_GRD,:C_NEW_SPEC,:C_NEW_PACK,:C_NEW_FREE_TERM,:C_NEW_FREE_TERM2,:C_NEW_MAT_CODE,:C_NEW_MAT_DESC,:C_SX,:C_NEW_SX)");
OracleParameter[] parameters =
{
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_WGD_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STOVE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PLAN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 15),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PACK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FREE_TERM", OracleDbType.Varchar2, 300),
new OracleParameter(":C_FREE_TERM2", OracleDbType.Varchar2, 300),
new OracleParameter(":C_MRSX", OracleDbType.Varchar2, 10),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PCLX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEWMRSX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEWPCLX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_PACK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_FREE_TERM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_FREE_TERM2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_SX", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_STA_ID;
parameters[1].Value = model.C_WGD_ID;
parameters[2].Value = model.C_STOVE;
parameters[3].Value = model.C_BATCH_NO;
parameters[4].Value = model.C_PLAN_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.C_STD_CODE;
parameters[8].Value = model.C_STL_GRD;
parameters[9].Value = model.C_SPEC;
parameters[10].Value = model.C_PACK;
parameters[11].Value = model.C_FREE_TERM;
parameters[12].Value = model.C_FREE_TERM2;
parameters[13].Value = model.C_MRSX;
parameters[14].Value = model.C_MAT_CODE;
parameters[15].Value = model.C_MAT_DESC;
parameters[16].Value = model.C_PCLX;
parameters[17].Value = model.C_NEWMRSX;
parameters[18].Value = model.C_NEWPCLX;
parameters[19].Value = model.C_NEW_STD_CODE;
parameters[20].Value = model.C_NEW_STL_GRD;
parameters[21].Value = model.C_NEW_SPEC;
parameters[22].Value = model.C_NEW_PACK;
parameters[23].Value = model.C_NEW_FREE_TERM;
parameters[24].Value = model.C_NEW_FREE_TERM2;
parameters[25].Value = model.C_NEW_MAT_CODE;
parameters[26].Value = model.C_NEW_MAT_DESC;
parameters[27].Value = model.C_SX;
parameters[28].Value = model.C_NEW_SX;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_WGD_HANDLER DataRowToModel(DataRow row)
{
Mod_TRC_ROLL_WGD_HANDLER model = new Mod_TRC_ROLL_WGD_HANDLER();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_STA_ID"] != null)
{
model.C_STA_ID = row["C_STA_ID"].ToString();
}
if (row["C_WGD_ID"] != null)
{
model.C_WGD_ID = row["C_WGD_ID"].ToString();
}
if (row["C_STOVE"] != null)
{
model.C_STOVE = row["C_STOVE"].ToString();
}
if (row["C_BATCH_NO"] != null)
{
model.C_BATCH_NO = row["C_BATCH_NO"].ToString();
}
if (row["C_PLAN_ID"] != null)
{
model.C_PLAN_ID = row["C_PLAN_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_STD_CODE"] != null)
{
model.C_STD_CODE = row["C_STD_CODE"].ToString();
}
if (row["C_STL_GRD"] != null)
{
model.C_STL_GRD = row["C_STL_GRD"].ToString();
}
if (row["C_SPEC"] != null)
{
model.C_SPEC = row["C_SPEC"].ToString();
}
if (row["C_PACK"] != null)
{
model.C_PACK = row["C_PACK"].ToString();
}
if (row["C_FREE_TERM"] != null)
{
model.C_FREE_TERM = row["C_FREE_TERM"].ToString();
}
if (row["C_FREE_TERM2"] != null)
{
model.C_FREE_TERM2 = row["C_FREE_TERM2"].ToString();
}
if (row["C_MRSX"] != null)
{
model.C_MRSX = row["C_MRSX"].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_PCLX"] != null)
{
model.C_PCLX = row["C_PCLX"].ToString();
}
if (row["C_NEWMRSX"] != null)
{
model.C_NEWMRSX = row["C_NEWMRSX"].ToString();
}
if (row["C_NEWPCLX"] != null)
{
model.C_NEWPCLX = row["C_NEWPCLX"].ToString();
}
if (row["C_NEW_STD_CODE"] != null)
{
model.C_NEW_STD_CODE = row["C_NEW_STD_CODE"].ToString();
}
if (row["C_NEW_STL_GRD"] != null)
{
model.C_NEW_STL_GRD = row["C_NEW_STL_GRD"].ToString();
}
if (row["C_NEW_SPEC"] != null)
{
model.C_NEW_SPEC = row["C_NEW_SPEC"].ToString();
}
if (row["C_NEW_PACK"] != null)
{
model.C_NEW_PACK = row["C_NEW_PACK"].ToString();
}
if (row["C_NEW_FREE_TERM"] != null)
{
model.C_NEW_FREE_TERM = row["C_NEW_FREE_TERM"].ToString();
}
if (row["C_NEW_FREE_TERM2"] != null)
{
model.C_NEW_FREE_TERM2 = row["C_NEW_FREE_TERM2"].ToString();
}
if (row["C_NEW_MAT_CODE"] != null)
{
model.C_NEW_MAT_CODE = row["C_NEW_MAT_CODE"].ToString();
}
if (row["C_NEW_MAT_DESC"] != null)
{
model.C_NEW_MAT_DESC = row["C_NEW_MAT_DESC"].ToString();
}
if (row["C_SX"] != null)
{
model.C_SX = row["C_SX"].ToString();
}
if (row["C_NEW_SX"] != null)
{
model.C_NEW_SX = row["C_NEW_SX"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_ROLL_WGD_HANDLER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_ROLL_WGD_HANDLER set ");
strSql.Append("C_STA_ID=:C_STA_ID,");
strSql.Append("C_WGD_ID=:C_WGD_ID,");
strSql.Append("C_STOVE=:C_STOVE,");
strSql.Append("C_BATCH_NO=:C_BATCH_NO,");
strSql.Append("C_PLAN_ID=:C_PLAN_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_STD_CODE=:C_STD_CODE,");
strSql.Append("C_STL_GRD=:C_STL_GRD,");
strSql.Append("C_SPEC=:C_SPEC,");
strSql.Append("C_PACK=:C_PACK,");
strSql.Append("C_FREE_TERM=:C_FREE_TERM,");
strSql.Append("C_FREE_TERM2=:C_FREE_TERM2,");
strSql.Append("C_MRSX=:C_MRSX,");
strSql.Append("C_MAT_CODE=:C_MAT_CODE,");
strSql.Append("C_MAT_DESC=:C_MAT_DESC");
strSql.Append("C_PCLX=:C_PCLX");
strSql.Append("C_NEWMRSX=:C_NEWMRSX");
strSql.Append("C_NEWPCLX=:C_NEWPCLX");
strSql.Append("C_NEW_STD_CODE=:C_NEW_STD_CODE,");
strSql.Append("C_NEW_STL_GRD=:C_NEW_STL_GRD,");
strSql.Append("C_NEW_SPEC=:C_NEW_SPEC,");
strSql.Append("C_NEW_PACK=:C_NEW_PACK,");
strSql.Append("C_NEW_FREE_TERM=:C_NEW_FREE_TERM,");
strSql.Append("C_NEW_FREE_TERM2=:C_NEW_FREE_TERM2");
strSql.Append("C_NEW_MAT_CODE=:C_NEW_MAT_CODE,");
strSql.Append("C_NEW_MAT_DESC=:C_NEW_MAT_DESC");
strSql.Append("C_SX=:C_SX,");
strSql.Append("C_NEW_SX=:C_NEW_SX");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_WGD_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STOVE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PLAN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 15),
new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PACK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FREE_TERM", OracleDbType.Varchar2, 300),
new OracleParameter(":C_FREE_TERM2", OracleDbType.Varchar2, 300),
new OracleParameter(":C_MRSX", OracleDbType.Varchar2, 10),
new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_PCLX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEWMRSX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEWPCLX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_STD_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_STL_GRD", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_SPEC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_PACK", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_FREE_TERM", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_FREE_TERM2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_NEW_SX", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_STA_ID;
parameters[1].Value = model.C_WGD_ID;
parameters[2].Value = model.C_STOVE;
parameters[3].Value = model.C_BATCH_NO;
parameters[4].Value = model.C_PLAN_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.C_STD_CODE;
parameters[8].Value = model.C_STL_GRD;
parameters[9].Value = model.C_SPEC;
parameters[10].Value = model.C_PACK;
parameters[11].Value = model.C_FREE_TERM;
parameters[12].Value = model.C_FREE_TERM2;
parameters[13].Value = model.C_MRSX;
parameters[14].Value = model.C_MAT_CODE;
parameters[15].Value = model.C_MAT_DESC;
parameters[16].Value = model.C_PCLX;
parameters[17].Value = model.C_NEWMRSX;
parameters[18].Value = model.C_NEWPCLX;
parameters[19].Value = model.C_NEW_STD_CODE;
parameters[20].Value = model.C_NEW_STL_GRD;
parameters[21].Value = model.C_NEW_SPEC;
parameters[22].Value = model.C_NEW_PACK;
parameters[23].Value = model.C_NEW_FREE_TERM;
parameters[24].Value = model.C_NEW_FREE_TERM2;
parameters[25].Value = model.C_NEW_MAT_CODE;
parameters[26].Value = model.C_NEW_MAT_DESC;
parameters[27].Value = model.C_SX;
parameters[28].Value = model.C_NEW_SX;
parameters[29].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 完工单处理
/// </summary>
/// <param name="id">完工单主键id</param>
/// <param name="staID">工位</param>
/// <param name="stove">炉号</param>
/// <param name="batchNo">批号</param>
/// <param name="planID">计划号</param>
/// <param name="grd">钢种</param>
/// <param name="std">执行标准</param>
/// <param name="spec">规格</param>
/// <param name="pack">包装标准</param>
/// <param name="zyx">自由项</param>
/// <param name="zyx2">自由项2</param>
/// <param name="mrsx">批次属性</param>
/// <param name="matCode">物料编码</param>
/// <param name="matDesc">物料名称</param>
/// <param name="pclx">批次类型</param>
/// <param name="newMrsx">确认批次属性</param>
/// <param name="newPclx">确认批次类型</param>
/// <param name="status">状态1 完工 2改判 3撤销</param>
/// <param name="newStd"></param>
/// <param name="newGrd"></param>
/// <param name="newSpec"></param>
/// <param name="newMatCode"></param>
/// <param name="newMatDesc"></param>
/// <param name="newZyx"></param>
/// <param name="newZyx2"></param>
/// <param name="newPack"></param>
/// <param name="start"></param>
/// <param name="status"></param>
/// <returns></returns>
public string WgdHandler(string id, string staID, string stove, string batchNo, string planID,
string grd, string std, string spec, string pack, string zyx, string zyx2, string mrsx, string matCode,
string matDesc, string pclx, string newMrsx, string newPclx, string newStd, string newGrd, string newSpec, string newMatCode, string newMatDesc, string newZyx, string newZyx2, string newPack, DateTime start, int status, string sx, string itemID)
{
string result = "1";
try
{
TransactionHelper.BeginTransaction();
Mod_TRC_ROLL_WGD_HANDLER model = new Mod_TRC_ROLL_WGD_HANDLER();
model.C_WGD_ID = id;
model.C_STA_ID = staID;
model.C_STOVE = stove;
model.C_BATCH_NO = batchNo;
model.C_PLAN_ID = planID;
model.D_MOD_DT = start;
model.C_STD_CODE = std;
model.C_STL_GRD = grd;
model.C_SPEC = spec;
model.C_PACK = pack;
model.C_FREE_TERM = zyx;
model.C_FREE_TERM2 = zyx2;
model.C_MRSX = mrsx;
model.C_MAT_CODE = matCode;
model.C_MAT_DESC = matDesc;
model.C_PCLX = pclx;
model.N_STATUS = status;
model.C_NEWMRSX = newMrsx;
model.C_NEWPCLX = newPclx;
model.C_NEW_STL_GRD = newGrd;
model.C_NEW_SPEC = newSpec;
model.C_NEW_STD_CODE = newStd;
model.C_NEW_MAT_CODE = newMatCode;
model.C_NEW_MAT_DESC = newMatDesc;
model.C_NEW_PACK = newPack;
model.C_NEW_FREE_TERM = newZyx;
model.C_NEW_FREE_TERM2 = newZyx2;
model.C_SX = sx;
string zpdjbz = "0";
if (newMrsx == "DP")
{
zpdjbz = "1";
}
if (!wgdHandlerDal.Add(model))
{
TransactionHelper.RollBack();
return("0");
}
if (status == 1)
{
if (!dal.UpdateWgd(model.C_WGD_ID, model.C_NEWMRSX, model.C_NEWPCLX, 1, model.C_SX, zpdjbz))
{
TransactionHelper.RollBack();
return("0");
}
}
else
{
if (!dal.UpdateWgd(model.C_WGD_ID, model.C_NEWMRSX, model.C_NEWPCLX, newGrd, newSpec, newStd, newMatCode, newMatDesc, newZyx, newZyx2, 1, model.C_SX, zpdjbz))
{
TransactionHelper.RollBack();
return("0");
}
}
//出口才更新子表
if (newPclx == "1")
{
if (!dal.UpdateWgdItem(itemID, sx, 1))
{
TransactionHelper.RollBack();
return("0");
}
}
TransactionHelper.Commit();
Mod_TRC_ROLL_WGD_HANDLER_LOG modelLog = new Mod_TRC_ROLL_WGD_HANDLER_LOG();
modelLog.C_WGD_ID = id;
modelLog.C_STA_ID = staID;
modelLog.C_STOVE = stove;
modelLog.C_BATCH_NO = batchNo;
modelLog.C_PLAN_ID = planID;
modelLog.D_MOD_DT = DateTime.Now;
modelLog.C_STD_CODE = std;
modelLog.C_STL_GRD = grd;
modelLog.C_SPEC = spec;
modelLog.C_PACK = pack;
modelLog.C_FREE_TERM = zyx;
modelLog.C_FREE_TERM2 = zyx2;
modelLog.C_MRSX = mrsx;
modelLog.C_MAT_CODE = matCode;
modelLog.C_MAT_DESC = matDesc;
modelLog.C_PCLX = pclx;
modelLog.N_STATUS = status;
modelLog.C_NEWMRSX = newMrsx;
modelLog.C_NEWPCLX = newPclx;
modelLog.C_NEW_STL_GRD = newGrd;
modelLog.C_NEW_SPEC = newSpec;
modelLog.C_NEW_STD_CODE = newStd;
modelLog.C_NEW_MAT_CODE = newMatCode;
modelLog.C_NEW_MAT_DESC = newMatDesc;
modelLog.C_NEW_PACK = newPack;
modelLog.C_NEW_FREE_TERM = newZyx;
modelLog.C_NEW_FREE_TERM2 = newZyx2;
modelLog.C_SX = sx;
wgdHandlerLogDal.Add(modelLog);
}
catch (Exception ex)
{
TransactionHelper.RollBack();
return("0");
}
return(result);
}
