/// <summary>
/// 修磨确认
/// </summary>
/// <param name="id">主键</param>
/// <param name="num">总支数</param>
/// <param name="factNum">修磨支数</param>
/// <param name="xmbz">修磨标准</param>
/// <param name="sta">工位</param>
/// <param name="remark">说明</param>
/// <param name="emp">修磨人</param>
/// <param name="hg">货管</param>
/// <param name="batchNo">批次号</param>
/// <param name="slbwhCode">仓库编码</param>
/// <param name="grinWheel">砂轮</param>
/// <returns></returns>
public string RegroundConfirm(string id, string num, string factNum, string xmbz,
string sta, string remark, string emp, string hg, string batchNo, string quality, string hw,
string slbwhCode, string grinWheel, string group, string shift, DateTime operation, string area)
{
string result = "1";
TransactionHelper.BeginTransaction();
try
{
Mod_TRC_PLAN_REGROUND_HANDLER model = new Mod_TRC_PLAN_REGROUND_HANDLER();
model.C_REGROUND_ID = id;
model.C_EMP_NAME = emp;
model.C_STA_ID = sta;
model.C_XMBZ = xmbz;
model.N_TOTAL_QUA = int.Parse(num);
model.N_QUA = int.Parse(factNum);
model.C_BATCH_NO = batchNo;
model.C_QUALITY = quality;
model.C_HW = hw;
model.C_HG = hg;
model.N_STATUS = 1;
model.C_CAUSE = remark;
model.C_GRINDING_WHEEL = grinWheel;
model.C_SHIFT = shift;
model.C_GROUP = group;
model.D_DT = operation;
if (!handlerDal.Add(model))
{
TransactionHelper.RollBack();
return("0");
}
string columnName = "";
if (area == "1")
{
columnName = General.NameType[xmbz];
}
else
{
columnName = General.NameTypes[xmbz];
}
if (!dal.UpdateRegroundProcedure(id, columnName, int.Parse(factNum), 1))
{
TransactionHelper.RollBack();
return("0");
}
TransactionHelper.Commit();
dal.UpdateRegroundType();
}
catch (Exception ex)
{
TransactionHelper.RollBack();
return("0");
}
return(result);
}
/// <summary>
/// 探伤确认
/// </summary>
/// <param name="id">主键</param>
/// <param name="num">总支数</param>
/// <param name="factNum">探伤支数</param>
/// <param name="notNum">未探支数</param>
/// <param name="notBz">不合格原因</param>
/// <param name="sta">工位</param>
/// <param name="remark">备注</param>
/// <param name="emp">探伤人</param>
/// <param name="batchNo">批号</param>
/// <param name="hw">货位</param>
/// <param name="slbwhCode">仓库编号</param>
/// <param name="notCause">未探原因</param>
/// <returns></returns>
public string ShotBlastingConfirm(string id, string num, string factNum, string notNum, string notBz,
string sta, string remark, string emp, string batchNo, string hw, string notCause, string group, string shift, DateTime operation)
{
string result = "1";
TransactionHelper.BeginTransaction();
try
{
Mod_TRC_PLAN_REGROUND_HANDLER model = new Mod_TRC_PLAN_REGROUND_HANDLER();
model.C_REGROUND_ID = id;
model.C_EMP_NAME = emp;
model.C_STA_ID = sta;
model.C_XMBZ = notBz;
model.N_TOTAL_QUA = int.Parse(num);
model.N_QUA = int.Parse(factNum);
model.C_BATCH_NO = batchNo;
model.C_HW = hw;
model.C_REMARK = remark;
model.N_STATUS = 2;
model.N_NOT_QUA = int.Parse(notNum);
model.C_CAUSE = notCause;
model.C_GROUP = group;
model.C_SHIFT = shift;
model.D_DT = operation;
if (!handlerDal.Add(model))
{
TransactionHelper.RollBack();
return("0");
}
TransactionHelper.Commit();
}
catch (Exception ex)
{
TransactionHelper.RollBack();
return("0");
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_PLAN_REGROUND_HANDLER GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_REGROUND_ID,C_REGROUND_ITEM_ID,C_EMP_NAME,D_DT,C_STA_ID,C_XMBZ,N_TOTAL_QUA,N_QUA,C_BATCH_NO,C_REMARK,C_QUALITY,C_HW,C_HG,C_CAUSE,N_NOT_QUA,C_SHIFT,C_GROUP,N_STATUS,N_STEP,C_STEPNAME,C_GRINDING_WHEEL from TRC_PLAN_REGROUND_HANDLER ");
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_HANDLER model = new Mod_TRC_PLAN_REGROUND_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_PLAN_REGROUND_HANDLER model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_PLAN_REGROUND_HANDLER model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TRC_PLAN_REGROUND_HANDLER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TRC_PLAN_REGROUND_HANDLER(");
strSql.Append("C_REGROUND_ID,C_REGROUND_ITEM_ID,C_EMP_NAME,D_DT,C_STA_ID,C_XMBZ,N_TOTAL_QUA,N_QUA,C_BATCH_NO,C_REMARK,C_QUALITY,C_HW,C_HG,C_CAUSE,N_NOT_QUA,C_SHIFT,C_GROUP,N_STATUS,N_STEP,C_STEPNAME,C_GRINDING_WHEEL)");
strSql.Append(" values (");
strSql.Append(":C_REGROUND_ID,:C_REGROUND_ITEM_ID,:C_EMP_NAME,:D_DT,:C_STA_ID,:C_XMBZ,:N_TOTAL_QUA,:N_QUA,:C_BATCH_NO,:C_REMARK,:C_QUALITY,:C_HW,:C_HG,:C_CAUSE,:N_NOT_QUA,:C_SHIFT,:C_GROUP,:N_STATUS,:N_STEP,:C_STEPNAME,:C_GRINDING_WHEEL)");
OracleParameter[] parameters =
{
new OracleParameter(":C_REGROUND_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REGROUND_ITEM_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_DT", OracleDbType.Date),
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XMBZ", OracleDbType.Varchar2, 100),
new OracleParameter(":N_TOTAL_QUA", OracleDbType.Decimal, 5),
new OracleParameter(":N_QUA", OracleDbType.Decimal, 5),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_QUALITY", OracleDbType.Varchar2, 100),
new OracleParameter(":C_HW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_HG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CAUSE", OracleDbType.Varchar2, 500),
new OracleParameter(":N_NOT_QUA", OracleDbType.Decimal, 5),
new OracleParameter(":C_SHIFT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GROUP", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 2),
new OracleParameter(":N_STEP", OracleDbType.Decimal, 2),
new OracleParameter(":C_STEPNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GRINDING_WHEEL", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_REGROUND_ID;
parameters[1].Value = model.C_REGROUND_ITEM_ID;
parameters[2].Value = model.C_EMP_NAME;
parameters[3].Value = model.D_DT;
parameters[4].Value = model.C_STA_ID;
parameters[5].Value = model.C_XMBZ;
parameters[6].Value = model.N_TOTAL_QUA;
parameters[7].Value = model.N_QUA;
parameters[8].Value = model.C_BATCH_NO;
parameters[9].Value = model.C_REMARK;
parameters[10].Value = model.C_QUALITY;
parameters[11].Value = model.C_HW;
parameters[12].Value = model.C_HG;
parameters[13].Value = model.C_CAUSE;
parameters[14].Value = model.N_NOT_QUA;
parameters[15].Value = model.C_SHIFT;
parameters[16].Value = model.C_GROUP;
parameters[17].Value = model.N_STATUS;
parameters[18].Value = model.N_STEP;
parameters[19].Value = model.C_STEPNAME;
parameters[20].Value = model.C_GRINDING_WHEEL;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TRC_PLAN_REGROUND_HANDLER DataRowToModel(DataRow row)
{
Mod_TRC_PLAN_REGROUND_HANDLER model = new Mod_TRC_PLAN_REGROUND_HANDLER();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_REGROUND_ID"] != null)
{
model.C_REGROUND_ID = row["C_REGROUND_ID"].ToString();
}
if (row["C_REGROUND_ITEM_ID"] != null)
{
model.C_REGROUND_ITEM_ID = row["C_REGROUND_ITEM_ID"].ToString();
}
if (row["C_EMP_NAME"] != null)
{
model.C_EMP_NAME = row["C_EMP_NAME"].ToString();
}
if (row["D_DT"] != null && row["D_DT"].ToString() != "")
{
model.D_DT = DateTime.Parse(row["D_DT"].ToString());
}
if (row["C_STA_ID"] != null)
{
model.C_STA_ID = row["C_STA_ID"].ToString();
}
if (row["C_XMBZ"] != null)
{
model.C_XMBZ = row["C_XMBZ"].ToString();
}
if (row["N_TOTAL_QUA"] != null && row["N_TOTAL_QUA"].ToString() != "")
{
model.N_TOTAL_QUA = decimal.Parse(row["N_TOTAL_QUA"].ToString());
}
if (row["N_QUA"] != null && row["N_QUA"].ToString() != "")
{
model.N_QUA = decimal.Parse(row["N_QUA"].ToString());
}
if (row["C_BATCH_NO"] != null)
{
model.C_BATCH_NO = row["C_BATCH_NO"].ToString();
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["C_QUALITY"] != null)
{
model.C_QUALITY = row["C_QUALITY"].ToString();
}
if (row["C_HW"] != null)
{
model.C_HW = row["C_HW"].ToString();
}
if (row["C_HG"] != null)
{
model.C_HG = row["C_HG"].ToString();
}
if (row["C_CAUSE"] != null)
{
model.C_CAUSE = row["C_CAUSE"].ToString();
}
if (row["N_NOT_QUA"] != null && row["N_NOT_QUA"].ToString() != "")
{
model.N_NOT_QUA = decimal.Parse(row["N_NOT_QUA"].ToString());
}
if (row["C_SHIFT"] != null)
{
model.C_SHIFT = row["C_SHIFT"].ToString();
}
if (row["C_GROUP"] != null)
{
model.C_GROUP = row["C_GROUP"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["N_STEP"] != null && row["N_STEP"].ToString() != "")
{
model.N_STEP = decimal.Parse(row["N_STEP"].ToString());
}
if (row["C_STEPNAME"] != null)
{
model.C_STEPNAME = row["C_STEPNAME"].ToString();
}
if (row["C_GRINDING_WHEEL"] != null)
{
model.C_GRINDING_WHEEL = row["C_GRINDING_WHEEL"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TRC_PLAN_REGROUND_HANDLER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TRC_PLAN_REGROUND_HANDLER set ");
strSql.Append("C_REGROUND_ID=:C_REGROUND_ID,");
strSql.Append("C_REGROUND_ITEM_ID=:C_REGROUND_ITEM_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_DT=:D_DT,");
strSql.Append("C_STA_ID=:C_STA_ID,");
strSql.Append("C_XMBZ=:C_XMBZ,");
strSql.Append("N_TOTAL_QUA=:N_TOTAL_QUA,");
strSql.Append("N_QUA=:N_QUA,");
strSql.Append("C_BATCH_NO=:C_BATCH_NO,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_QUALITY=:C_QUALITY,");
strSql.Append("C_HW=:C_HW,");
strSql.Append("C_HG=:C_HG,");
strSql.Append("C_CAUSE=:C_CAUSE,");
strSql.Append("N_NOT_QUA=:N_NOT_QUA,");
strSql.Append("C_SHIFT=:C_SHIFT,");
strSql.Append("C_GROUP=:C_GROUP");
strSql.Append("N_STATUS=:N_STATUS");
strSql.Append("N_STEP=:N_STEP");
strSql.Append("C_STEPNAME=:C_STEPNAME");
strSql.Append("C_GRINDING_WHEEL=:C_GRINDING_WHEEL");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_REGROUND_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REGROUND_ITEM_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100),
new OracleParameter(":D_DT", OracleDbType.Date),
new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_XMBZ", OracleDbType.Varchar2, 100),
new OracleParameter(":N_TOTAL_QUA", OracleDbType.Decimal, 5),
new OracleParameter(":N_QUA", OracleDbType.Decimal, 5),
new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_QUALITY", OracleDbType.Varchar2, 100),
new OracleParameter(":C_HW", OracleDbType.Varchar2, 100),
new OracleParameter(":C_HG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CAUSE", OracleDbType.Varchar2, 500),
new OracleParameter(":N_NOT_QUA", OracleDbType.Decimal, 5),
new OracleParameter(":C_SHIFT", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GROUP", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 2),
new OracleParameter(":N_STEP", OracleDbType.Decimal, 2),
new OracleParameter(":C_STEPNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":C_GRINDING_WHEEL", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_REGROUND_ID;
parameters[1].Value = model.C_REGROUND_ITEM_ID;
parameters[2].Value = model.C_EMP_NAME;
parameters[3].Value = model.D_DT;
parameters[4].Value = model.C_STA_ID;
parameters[5].Value = model.C_XMBZ;
parameters[6].Value = model.N_TOTAL_QUA;
parameters[7].Value = model.N_QUA;
parameters[8].Value = model.C_BATCH_NO;
parameters[9].Value = model.C_REMARK;
parameters[10].Value = model.C_QUALITY;
parameters[11].Value = model.C_HW;
parameters[12].Value = model.C_HG;
parameters[13].Value = model.C_CAUSE;
parameters[14].Value = model.N_NOT_QUA;
parameters[15].Value = model.C_SHIFT;
parameters[16].Value = model.C_GROUP;
parameters[17].Value = model.N_STATUS;
parameters[18].Value = model.N_STEP;
parameters[19].Value = model.C_STEPNAME;
parameters[20].Value = model.C_GRINDING_WHEEL;
parameters[21].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
