/// <summary>
/// 得到一个对象实体
/// </summary>
public List <Mod_TRC_ROLL_WGD_ITEM> GetModels(string C_ID)
{
List <Mod_TRC_ROLL_WGD_ITEM> models = new List <Mod_TRC_ROLL_WGD_ITEM>();
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,C_MRSX from TRC_ROLL_WGD_ITEM ");
strSql.Append(" where C_ROLL_WGD_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TRC_ROLL_WGD_ITEM model = new Mod_TRC_ROLL_WGD_ITEM();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
models.Add(DataRowToModel(item));
}
return(models);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_WGD_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_ROLL_WGD_ITEM(");
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,C_MRSX)");
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,:C_MRSX)");
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_MRSX", 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_MRSX;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_ROLL_WGD_ITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_ROLL_WGD_ITEM 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("C_MRSX=:C_MRSX");
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_MRSX", 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_MRSX;
parameters[14].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 DataRowToModel(DataRow row)
{
Mod_TRC_ROLL_WGD_ITEM model = new Mod_TRC_ROLL_WGD_ITEM();
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();
}
if (row["C_MRSX"] != null)
{
model.C_MRSX = row["C_MRSX"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_ROLL_WGD_ITEM model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_ROLL_WGD_ITEM model)
{
return(dal.Add(model));
}
/// <summary>
/// 完工单确认
/// </summary>
/// <param name="stove">炉号</param>
/// <param name="batchNo">批号</param>
/// <param name="planID">计划id</param>
/// <param name="num">支数</param>
/// <param name="wgt">重量</param>
/// <param name="grd">钢种</param>
/// <param name="spec">规格</param>
/// <param name="std">执行标准</param>
/// <param name="id">主表id</param>
/// <param name="staID">工位号</param>
/// <param name="start">start</param>
/// <param name="end">start</param>
/// <param name="shift">班次ID</param>
/// <param name="group">班组ID</param>
/// <param name="shiftName">班次</param>
/// <param name="groupName">班组</param>
/// <param name="castOffQua">甩废</param>
/// <param name="cuttingQua">切废</param>
/// <returns></returns>
public string WgdHandler(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, string shiftName, string groupName, string castOffQua, string cuttingQua)
{
string result = "1";
try
{
TransactionHelper.BeginTransaction();
decimal successQua = num - decimal.Parse(castOffQua) - decimal.Parse(cuttingQua);
wgdDal.UpdateWgd(start, end, num, id, decimal.Parse(castOffQua), decimal.Parse(cuttingQua), successQua, shift, group, shiftName, groupName);
if (!wgdDal.UpdateRollStatus(id, 1))
{
TransactionHelper.RollBack();
return("0");
}
if (dal_TRC_WARM_FURNACE.UpdateWarmFurnaceRolleState(id, 3, 2) == 0)
{
TransactionHelper.RollBack();
return("0");
}
TransactionHelper.Commit();
#region 日志模型
Mod_TRC_ROLL_WGD model = new Mod_TRC_ROLL_WGD();
var planM = planRollItem.GetModel_Item(planID);
model.C_ID = Guid.NewGuid().ToString();
model.C_STA_ID = staID;
model.C_STOVE = stove;
model.C_BATCH_NO = batchNo;
model.C_PLAN_ID = planID;
model.N_QUA_PRODUCE = num;
model.N_WGT_PRODUCE = wgt;
model.N_STATUS = 0;
model.C_STD_CODE = std;
model.C_STL_GRD = grd;
model.C_SPEC = spec;
model.C_MAIN_ID = id;
model.D_PRODUCE_DATE_B = start;
model.D_PRODUCE_DATE_E = RV.UI.ServerTime.timeNow();
model.C_PRODUCE_SHIFT = shift;
model.C_PRODUCE_GROUP = group;
model.C_PRODUCE_EMP_ID = RV.UI.UserInfo.userID;
model.D_MOD_DT = start;
model.D_PRODUCE_DATE = model.D_PRODUCE_DATE_B;
model.C_FREE_TERM = planM.C_FREE_TERM;
model.C_FREE_TERM2 = planM.C_FREE_TERM2;
model.C_PACK = planM.C_PACK;
model.C_AREA = planM.C_AREA;
model.C_PCLX = planM.C_PCLX;
model.C_MAT_CODE = planM.C_MAT_CODE;
model.C_MAT_DESC = planM.C_MAT_NAME;
model.C_PRODUCE_SHIFT_NAME = shiftName;
model.C_PRODUCE_GROUP_NAME = groupName;
Mod_TRC_ROLL_WGD_ITEM itemM = new Mod_TRC_ROLL_WGD_ITEM();
itemM.C_MAIN_ID = model.C_MAIN_ID;
itemM.C_ROLL_WGD_ID = model.C_ID;
itemM.C_BATCH_NO = batchNo;
itemM.N_STATUS = 0;
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;
itemM.C_MRSX = model.C_MRSX;
DataTable dt = wgdDal.Get_Item_List(planM.C_MAT_CODE).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
Mod_TRC_ROLL_WGD_ITEM itemMM = new Mod_TRC_ROLL_WGD_ITEM();
itemMM.C_MAIN_ID = model.C_MAIN_ID;
itemMM.C_ROLL_WGD_ID = model.C_ID;
itemMM.C_BATCH_NO = batchNo;
itemMM.N_STATUS = 0;
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;
itemMM.C_MRSX = model.C_MRSX;
}
}
#endregion
AddLog(stove, batchNo, planID, num, wgt, grd, spec, std, id, staID, start, end, shift, group, model, planM, dt);
}
catch (Exception ex)
{
TransactionHelper.RollBack();
return("0");
}
return(result);
}
