/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_WGD_ITEM_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_ROLL_WGD_ITEM_LOG(");
strSql.Append("C_MAIN_ID,C_ROLL_WGD_ID,C_BATCH_NO,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,C_MAT_CODE,C_MAT_DESC,C_SALE_AREA,C_ZYX1,C_ZYX2,C_BZYQ)");
strSql.Append(" values (");
strSql.Append(":C_MAIN_ID,:C_ROLL_WGD_ID,:C_BATCH_NO,:N_STATUS,:C_STD_CODE,:C_STL_GRD,:C_SPEC,:C_MAT_CODE,:C_MAT_DESC,:C_SALE_AREA,:C_ZYX1,:C_ZYX2,:C_BZYQ)");
OracleParameter[] parameters =
{
new OracleParameter(":C_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_WGD_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
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_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SALE_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZYQ", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_MAIN_ID;
parameters[1].Value = model.C_ROLL_WGD_ID;
parameters[2].Value = model.C_BATCH_NO;
parameters[3].Value = model.N_STATUS;
parameters[4].Value = model.C_STD_CODE;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.C_MAT_CODE;
parameters[8].Value = model.C_MAT_DESC;
parameters[9].Value = model.C_SALE_AREA;
parameters[10].Value = model.C_ZYX1;
parameters[11].Value = model.C_ZYX2;
parameters[12].Value = model.C_BZYQ;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_WGD_ITEM_LOG GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_MAIN_ID,C_ROLL_WGD_ID,C_BATCH_NO,N_STATUS,C_STD_CODE,C_STL_GRD,C_SPEC,C_MAT_CODE,C_MAT_DESC,C_SALE_AREA,C_ZYX1,C_ZYX2,C_BZYQ from TRC_ROLL_WGD_ITEM_LOG ");
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_ITEM_LOG model = new Mod_TRC_ROLL_WGD_ITEM_LOG();
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_ITEM_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_ROLL_WGD_ITEM_LOG set ");
strSql.Append("C_MAIN_ID=:C_MAIN_ID,");
strSql.Append("C_ROLL_WGD_ID=:C_ROLL_WGD_ID,");
strSql.Append("C_BATCH_NO=:C_BATCH_NO,");
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_MAT_CODE=:C_MAT_CODE,");
strSql.Append("C_MAT_DESC=:C_MAT_DESC,");
strSql.Append("C_SALE_AREA=:C_SALE_AREA,");
strSql.Append("C_ZYX1=:C_ZYX1,");
strSql.Append("C_ZYX2=:C_ZYX2,");
strSql.Append("C_BZYQ=:C_BZYQ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_MAIN_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ROLL_WGD_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
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_MAT_CODE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_MAT_DESC", OracleDbType.Varchar2, 100),
new OracleParameter(":C_SALE_AREA", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ZYX2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BZYQ", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_MAIN_ID;
parameters[1].Value = model.C_ROLL_WGD_ID;
parameters[2].Value = model.C_BATCH_NO;
parameters[3].Value = model.N_STATUS;
parameters[4].Value = model.C_STD_CODE;
parameters[5].Value = model.C_STL_GRD;
parameters[6].Value = model.C_SPEC;
parameters[7].Value = model.C_MAT_CODE;
parameters[8].Value = model.C_MAT_DESC;
parameters[9].Value = model.C_SALE_AREA;
parameters[10].Value = model.C_ZYX1;
parameters[11].Value = model.C_ZYX2;
parameters[12].Value = model.C_BZYQ;
parameters[13].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_ROLL_WGD_ITEM_LOG DataRowToModel(DataRow row)
{
Mod_TRC_ROLL_WGD_ITEM_LOG model = new Mod_TRC_ROLL_WGD_ITEM_LOG();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_MAIN_ID"] != null)
{
model.C_MAIN_ID = row["C_MAIN_ID"].ToString();
}
if (row["C_ROLL_WGD_ID"] != null)
{
model.C_ROLL_WGD_ID = row["C_ROLL_WGD_ID"].ToString();
}
if (row["C_BATCH_NO"] != null)
{
model.C_BATCH_NO = row["C_BATCH_NO"].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_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_SALE_AREA"] != null)
{
model.C_SALE_AREA = row["C_SALE_AREA"].ToString();
}
if (row["C_ZYX1"] != null)
{
model.C_ZYX1 = row["C_ZYX1"].ToString();
}
if (row["C_ZYX2"] != null)
{
model.C_ZYX2 = row["C_ZYX2"].ToString();
}
if (row["C_BZYQ"] != null)
{
model.C_BZYQ = row["C_BZYQ"].ToString();
}
}
return(model);
}
private void AddLog(string stove, string batchNo, string planID, int num, decimal wgt, string grd, string spec, string std, string id, string staID, DateTime start, DateTime end, string shift, string group, Mod_TRC_ROLL_WGD model, Mod_TRP_PLAN_ROLL_ITEM planM, DataTable dt)
{
Mod_TRC_ROLL_WGD_LOG modelLog = new Mod_TRC_ROLL_WGD_LOG();
modelLog.C_ID = Guid.NewGuid().ToString();
modelLog.C_STA_ID = staID;
modelLog.C_STOVE = stove;
modelLog.C_BATCH_NO = batchNo;
modelLog.C_PLAN_ID = planID;
modelLog.N_QUA_PRODUCE = num;
modelLog.N_WGT_PRODUCE = wgt;
modelLog.N_STATUS = 2;
modelLog.C_STD_CODE = std;
modelLog.C_STL_GRD = grd;
modelLog.C_SPEC = spec;
modelLog.C_MAIN_ID = id;
modelLog.D_PRODUCE_DATE_B = start;
modelLog.D_PRODUCE_DATE_E = end;
modelLog.C_PRODUCE_SHIFT = shift;
modelLog.C_PRODUCE_GROUP = group;
modelLog.C_PRODUCE_EMP_ID = RV.UI.UserInfo.userID;
modelLog.D_MOD_DT = DateTime.Now;
modelLog.D_PRODUCE_DATE = model.D_PRODUCE_DATE_B;
modelLog.C_FREE_TERM = planM.C_FREE_TERM;
modelLog.C_FREE_TERM2 = planM.C_FREE_TERM2;
modelLog.C_PACK = planM.C_PACK;
modelLog.C_AREA = planM.C_AREA;
modelLog.C_PCLX = planM.C_PCLX;
modelLog.C_MAT_CODE = planM.C_MAT_CODE;
modelLog.C_MAT_DESC = planM.C_MAT_NAME;
wgdDalLog.Add(modelLog);
if (dt != null && dt.Rows.Count > 0)
{
Mod_TRC_ROLL_WGD_ITEM_LOG itemM = new Mod_TRC_ROLL_WGD_ITEM_LOG();
itemM.C_MAIN_ID = model.C_MAIN_ID;
itemM.C_ROLL_WGD_ID = model.C_ID;
itemM.C_BATCH_NO = batchNo;
itemM.N_STATUS = 2;
itemM.C_STL_GRD = model.C_STL_GRD;
itemM.C_STD_CODE = model.C_STD_CODE;
itemM.C_SPEC = model.C_SPEC;
itemM.C_MAT_CODE = planM.C_MAT_CODE;
itemM.C_MAT_DESC = planM.C_MAT_NAME;
itemM.C_ZYX1 = planM.C_FREE_TERM;
itemM.C_ZYX2 = planM.C_FREE_TERM2;
itemM.C_BZYQ = model.C_PACK;
itemM.C_SALE_AREA = model.C_AREA;
wgdItemDalLog.Add(itemM);
foreach (DataRow item in dt.Rows)
{
Mod_TRC_ROLL_WGD_ITEM_LOG itemMM = new Mod_TRC_ROLL_WGD_ITEM_LOG();
itemMM.C_MAIN_ID = model.C_MAIN_ID;
itemMM.C_ROLL_WGD_ID = model.C_ID;
itemMM.C_BATCH_NO = batchNo;
itemMM.N_STATUS = 2;
itemMM.C_STL_GRD = item["钢种"].ToString();
itemMM.C_STD_CODE = item["执行标准"].ToString();
itemMM.C_SPEC = item["规格"].ToString();
itemMM.C_MAT_CODE = item["物料编码"].ToString();
itemMM.C_MAT_DESC = item["物料名称"].ToString();
itemMM.C_ZYX1 = item["自由项1"].ToString();
itemMM.C_ZYX2 = item["自由项2"].ToString();
itemMM.C_BZYQ = model.C_PACK;
itemMM.C_SALE_AREA = model.C_AREA;
wgdItemDalLog.Add(itemMM);
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_ROLL_WGD_ITEM_LOG model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_WGD_ITEM_LOG model)
{
return(dal.Add(model));
}
