/// <summary>
/// 申请
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Apply_Click(object sender, EventArgs e)
{
try
{
int[] rownumber = gv_XL.GetSelectedRows();//获取选中行号数组；
if (rownumber.Length == 0)
{
MessageBox.Show("请选择需要借料的信息！");
return;
}
for (int i = 0; i < rownumber.Length; i++)
{
DataRow dr = gv_XL.GetDataRow(rownumber[i]);
Mod_TQC_UPDATE_MATERIAL mod = bll_Update.GetModel(dr["C_ID"].ToString());
mod.C_TYPE = "1";
mod.C_EMP_ID = RV.UI.UserInfo.UserID;
mod.D_MOD_DT = RV.UI.ServerTime.timeNow();
if (bll_Update.Update(mod))
{
Mod_TQC_UPDATE_MATERIAL_LOG mod_log = new Mod_TQC_UPDATE_MATERIAL_LOG();
mod_log.C_ROLL_PRODUCT_ID = dr["C_ROLL_PRODUCT_ID"].ToString();
mod_log.C_TYPE = "1";
mod_log.C_EMP_ID = RV.UI.UserInfo.UserID;
bll_Update_Log.Add(mod_log);
}
}
MessageBox.Show("借料成功！");
Query1();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 申请
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Apply_Click(object sender, EventArgs e)
{
try
{
DataRow dr = gv_SJXX.GetDataRow(this.gv_SJXX.FocusedRowHandle);
if (dr == null)
{
return;
}
Mod_TQC_UPD_MATERIAL_MAIN mod = new Mod_TQC_UPD_MATERIAL_MAIN();
mod.C_BATCH_NO = dr["批号"].ToString();
mod.C_REMARK = txt_CZYJ.Text.Trim();
mod.C_EMP_ID = RV.UI.UserInfo.UserID;
mod.D_MOD_DT = RV.UI.ServerTime.timeNow();
#region 检测是否重复添加
System.Collections.Hashtable ht = new System.Collections.Hashtable();
ht.Add("C_BATCH_NO", mod.C_BATCH_NO);
ht.Add("N_STATUS", 1);
if (Common.CheckRepeat.CheckTable("TQC_UPD_MATERIAL_MAIN", ht) > 0)
{
if (DialogResult.OK != MessageBox.Show("该批号已申请'" + mod.C_BATCH_NO + "'，是否确认继续申请！", "提示", MessageBoxButtons.OKCancel))
{
return;
}
else
{
DataTable dt = bll_Update.GetList_CXXL(dr["批号"].ToString()).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
Mod_TQC_UPDATE_MATERIAL mod_update = bll_Update.GetModel(dt.Rows[i]["C_ID"].ToString());
mod_update.N_STATUS = 0;
mod_update.C_EMP_ID = RV.UI.UserInfo.UserID;
mod_update.D_MOD_DT = RV.UI.ServerTime.timeNow();
bll_Update.Update(mod_update);
}
}
}
#endregion
if (bllUpdMain.Add(mod))
{
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加修料申请");//添加操作日志
MessageBox.Show("申请成功！");
Query();
Query1();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update_Trans(Mod_TQC_UPDATE_MATERIAL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TQC_UPDATE_MATERIAL set ");
strSql.Append("C_ROLL_PRODUCT_ID=:C_ROLL_PRODUCT_ID,");
strSql.Append("C_TYPE=:C_TYPE,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("N_WGT=:N_WGT,");
strSql.Append("N_WGT_DIFFERENCE=:N_WGT_DIFFERENCE,");
strSql.Append("C_SFHG=:C_SFHG");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ROLL_PRODUCT_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 6),
new OracleParameter(":N_WGT_DIFFERENCE", OracleDbType.Decimal, 6),
new OracleParameter(":C_SFHG", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ROLL_PRODUCT_ID;
parameters[1].Value = model.C_TYPE;
parameters[2].Value = model.N_STATUS;
parameters[3].Value = model.C_REMARK;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.N_WGT;
parameters[7].Value = model.N_WGT_DIFFERENCE;
parameters[8].Value = model.C_SFHG;
parameters[9].Value = model.C_ID;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQC_UPDATE_MATERIAL DataRowToModel(DataRow row)
{
Mod_TQC_UPDATE_MATERIAL model = new Mod_TQC_UPDATE_MATERIAL();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_ROLL_PRODUCT_ID"] != null)
{
model.C_ROLL_PRODUCT_ID = row["C_ROLL_PRODUCT_ID"].ToString();
}
if (row["C_TYPE"] != null)
{
model.C_TYPE = row["C_TYPE"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].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["N_WGT"] != null && row["N_WGT"].ToString() != "")
{
model.N_WGT = decimal.Parse(row["N_WGT"].ToString());
}
if (row["N_WGT_DIFFERENCE"] != null && row["N_WGT_DIFFERENCE"].ToString() != "")
{
model.N_WGT_DIFFERENCE = decimal.Parse(row["N_WGT_DIFFERENCE"].ToString());
}
if (row["C_SFHG"] != null)
{
model.C_SFHG = row["C_SFHG"].ToString();
}
}
return(model);
}
/// <summary>
/// 申请
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Apply_Click(object sender, EventArgs e)
{
try
{
int[] rownumber = gv_XL.GetSelectedRows();//获取选中行号数组；
if (rownumber.Length == 0)
{
MessageBox.Show("请选择需要确认的信息！");
return;
}
string strs = "";
string rollID = "";
for (int i = 0; i < rownumber.Length; i++)
{
int selectedHandle = rownumber[i];
strs = strs + gv_XL.GetRowCellValue(selectedHandle, "C_ROLL_PRODUCT_ID").ToString() + ",";
rollID = rollID + gv_XL.GetRowCellValue(selectedHandle, "C_ID").ToString() + ",";
}
for (int i = 0; i < rownumber.Length; i++)
{
DataRow dr = gv_XL.GetDataRow(rownumber[i]);
Mod_TQC_UPDATE_MATERIAL mod = bll_Update.GetModel(dr["C_ID"].ToString());
Mod_TRC_ROLL_PRODCUT mod_roll = bll_roll_product.GetModel(dr["C_ROLL_PRODUCT_ID"].ToString());
decimal? wgt = mod_roll.N_WGT;
DataTable dt = bll_Interface_FR.Get_TM_XL_List(dr["C_BATCH_NO"].ToString(), dr["C_TICK_NO"].ToString()).Tables[0];
if (dt.Rows.Count <= 0)
{
MessageBox.Show("条码库存查不到该批次！");
return;
}
}
int obj = bll.TransaTSXX(strs, "2", "", rollID, "");
if (obj == 1)
{
MessageBox.Show("确认成功！");
Query1();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add_Trans(Mod_TQC_UPDATE_MATERIAL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TQC_UPDATE_MATERIAL(");
strSql.Append("C_ROLL_PRODUCT_ID,C_TYPE,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,N_WGT,N_WGT_DIFFERENCE,C_SFHG)");
strSql.Append(" values (");
strSql.Append(":C_ROLL_PRODUCT_ID,:C_TYPE,:N_STATUS,:C_REMARK,:C_EMP_ID,:D_MOD_DT,:N_WGT,:N_WGT_DIFFERENCE,:C_SFHG)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ROLL_PRODUCT_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TYPE", OracleDbType.Varchar2, 100),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":N_WGT", OracleDbType.Decimal, 6),
new OracleParameter(":N_WGT_DIFFERENCE", OracleDbType.Decimal, 6),
new OracleParameter(":C_SFHG", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ROLL_PRODUCT_ID;
parameters[1].Value = model.C_TYPE;
parameters[2].Value = model.N_STATUS;
parameters[3].Value = model.C_REMARK;
parameters[4].Value = model.C_EMP_ID;
parameters[5].Value = model.D_MOD_DT;
parameters[6].Value = model.N_WGT;
parameters[7].Value = model.N_WGT_DIFFERENCE;
parameters[8].Value = model.C_SFHG;
int rows = TransactionHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TQC_UPDATE_MATERIAL GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_ROLL_PRODUCT_ID,C_TYPE,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,N_WGT,N_WGT_DIFFERENCE,C_SFHG from TQC_UPDATE_MATERIAL ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TQC_UPDATE_MATERIAL model = new Mod_TQC_UPDATE_MATERIAL();
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="sender"></param>
/// <param name="e"></param>
private void btn_FJSQ_Click(object sender, EventArgs e)
{
try
{
int result = 0;
if (!int.TryParse(txt_Num.Text.Trim(), out result))
{
MessageBox.Show("数量只能填写整数！");
return;
}
if (Convert.ToInt32(txt_Num.Text.Trim()) == 0)
{
MessageBox.Show("请输入取样数量！");
return;
}
if (image_Count.Text.Trim() == "")
{
MessageBox.Show("请选择复检次数！");
return;
}
DataRow dr = this.gv_SJXX.GetDataRow(this.gv_SJXX.FocusedRowHandle);
DataRow dr_right = this.gv_right.GetDataRow(this.gv_right.FocusedRowHandle);
if (dr == null)
{
return;
}
if (dr_right == null)
{
return;
}
int cou = bll_recheck.GetRecordCount(dr["C_BATCH_NO"].ToString());
if (cou > 0)
{
if (DialogResult.OK != MessageBox.Show("该批号已申请'" + cou + "'件，是否确认继续申请！", "提示", MessageBoxButtons.OKCancel))
{
return;
}
}
string strItemName = "";
DataTable dt = bll_item_result.Get_Item(dr["C_STOVE"].ToString(), dr["C_BATCH_NO"].ToString(), dr_right["C_CODE"].ToString()).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
Mod_TQC_COMPRE_ITEM_RESULT mod = bll_item_result.GetModel(dt.Rows[i]["C_ID"].ToString());
strItemName += mod.C_ITEM_NAME + ";";
}
if (Convert.ToInt32(txt_Num.Text.Trim()) > 0)
{
for (int i = 0; i < Convert.ToInt32(txt_Num.Text.Trim()); i++)
{
Mod_TQC_RECHECK model = new Mod_TQC_RECHECK();
model.C_PHYSICS_CODE = dr_right["C_CODE"].ToString();
model.C_PHYSICS_NAME = dr_right["C_NAME"].ToString();
model.C_STOVE = dr["C_STOVE"].ToString();
model.C_BATCH_NO = dr["C_BATCH_NO"].ToString();
model.C_STL_GRD = dr["C_STL_GRD"].ToString();
model.C_SPEC = dr["C_SPEC"].ToString();
model.C_STD_CODE = dr["C_STD_CODE"].ToString();
model.C_ITEM_NAME = strItemName;
model.C_SHIFT = imcbo_Shift.Text.Trim();
model.C_GROUP = imcbo_Group.Text.Trim();
model.C_DISPOSAL = txt_CLYJ.Text.Trim();
model.N_RECHECK = Convert.ToDecimal(image_Count.Text.Trim());
model.C_EMP_ID = RV.UI.UserInfo.userID;
bll_recheck.Add(model);
}
Mod_TQC_UPD_MATERIAL_MAIN mod_UpdMaterial = new Mod_TQC_UPD_MATERIAL_MAIN();
mod_UpdMaterial.C_BATCH_NO = dr["C_BATCH_NO"].ToString();
mod_UpdMaterial.C_REMARK = txt_CLYJ.Text.Trim();
mod_UpdMaterial.C_EMP_ID = RV.UI.UserInfo.UserID;
mod_UpdMaterial.D_MOD_DT = RV.UI.ServerTime.timeNow();
#region 检测是否重复添加
System.Collections.Hashtable ht = new System.Collections.Hashtable();
ht.Add("C_BATCH_NO", mod_UpdMaterial.C_BATCH_NO);
ht.Add("N_STATUS", 1);
if (Common.CheckRepeat.CheckTable("TQC_UPD_MATERIAL_MAIN", ht) > 0)
{
if (DialogResult.OK != MessageBox.Show(" 批号'" + mod_UpdMaterial.C_BATCH_NO + "'已申请修料，是否确认继续申请！", "提示", MessageBoxButtons.OKCancel))
{
return;
}
else
{
DataTable dts = bll_Update.GetList_CXXL(dr["C_BATCH_NO"].ToString()).Tables[0];
for (int s = 0; s < dt.Rows.Count; s++)
{
Mod_TQC_UPDATE_MATERIAL mod_update = bll_Update.GetModel(dts.Rows[s]["C_ID"].ToString());
mod_update.N_STATUS = 0;
mod_update.C_EMP_ID = RV.UI.UserInfo.UserID;
mod_update.D_MOD_DT = RV.UI.ServerTime.timeNow();
bll_Update.Update(mod_update);
}
}
}
#endregion
bllUpdMaterial.Add(mod_UpdMaterial);
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加复检申请信息");//添加操作日志
Query_SQ();
MessageBox.Show("申请成功！");
txt_Num.Text = "";
image_Count.Text = "";
}
else
{
MessageBox.Show("请选择需要申请的信息！");
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TQC_UPDATE_MATERIAL model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TQC_UPDATE_MATERIAL model)
{
return(dal.Add(model));
}
/// <summary>
/// 库检申请
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_KJSQ_Click(object sender, EventArgs e)
{
try
{
int[] rownumber = gv_SJXX.GetSelectedRows();//获取选中行号数组；
if (rownumber.Length == 0)
{
MessageBox.Show("请选择需要保存的信息！");
return;
}
DataRow row = gv_SJXX.GetDataRow(rownumber[0]);
if (imgcbo_YYMC.EditValue == null)
{
MessageBox.Show("库检原因不能为空！", "提示");
return;
}
if (imgcbo_ZRBM.EditValue == null)
{
MessageBox.Show("责任单位不能为空！", "提示");
return;
}
if (imgcbo_CZYJ.EditValue == null)
{
MessageBox.Show("处置意见不能为空！", "提示");
return;
}
if (DialogResult.OK != MessageBox.Show("是否确认保存已选中的数据？", "提示", MessageBoxButtons.OKCancel))
{
return;
}
for (int i = 0; i < rownumber.Length; i++)
{
DataRow dr = gv_SJXX.GetDataRow(rownumber[i]);
if (dr["C_BATCH_NO"].ToString() != row["C_BATCH_NO"].ToString())
{
MessageBox.Show("请选择相同的批号！");
return;
}
Mod_TQC_WAREHOUSE_CHECK_ROLL mod = new Mod_TQC_WAREHOUSE_CHECK_ROLL();
mod.C_ROLL_ID = dr["C_ID"].ToString();
mod.C_STOVE = dr["C_STOVE"].ToString();
mod.C_BATCH_NO = dr["C_BATCH_NO"].ToString();
mod.C_TICK_NO = dr["C_TICK_NO"].ToString();
mod.C_STL_GRD = dr["C_STL_GRD"].ToString();
mod.N_WGT = Convert.ToDecimal(dr["N_WGT"]);
mod.C_STD_CODE = dr["C_STD_CODE"].ToString();
mod.C_SPEC = dr["C_SPEC"].ToString();
mod.C_MAT_CODE = dr["C_MAT_CODE"].ToString();
mod.C_MAT_NAME = dr["C_MAT_DESC"].ToString();
mod.D_WAREHOUSE_IN = Convert.ToDateTime(dr["D_MOD_DT"]);
mod.C_SHIFT = dr["C_SHIFT"].ToString();
mod.C_GROUP = dr["C_GROUP"].ToString();
mod.C_REASON_NAME = imgcbo_YYMC.Text;
mod.C_REASON_CODE = imgcbo_YYMC.EditValue.ToString();
mod.C_REASON_DEPMT_ID = imgcbo_ZRBM.Text;
mod.C_REASON_DEPMT_DESC = imgcbo_ZRBM.Text;
mod.C_SUGGESTION = imgcbo_CZYJ.Text;
mod.C_REMARK = txt_Remark.Text;
mod.C_EMP_ID = RV.UI.UserInfo.UserID;
mod.D_MOD_DT = RV.UI.ServerTime.timeNow();
if (bll_we_check_roll.Add(mod))
{
Mod_TRC_ROLL_PRODCUT mod_roll = bll_TRC_Roll_Product.GetModel(dr["C_ID"].ToString());
mod_roll.C_IS_DEPOT = "Y";
bll_TRC_Roll_Product.Update(mod_roll);
}
}
Mod_TQC_UPD_MATERIAL_MAIN mod_UpdMaterial = new Mod_TQC_UPD_MATERIAL_MAIN();
mod_UpdMaterial.C_BATCH_NO = row["C_BATCH_NO"].ToString();
mod_UpdMaterial.C_REMARK = txt_Remark.Text.Trim();
mod_UpdMaterial.C_EMP_ID = RV.UI.UserInfo.UserID;
mod_UpdMaterial.D_MOD_DT = RV.UI.ServerTime.timeNow();
#region 检测是否重复添加
System.Collections.Hashtable ht = new System.Collections.Hashtable();
ht.Add("C_BATCH_NO", mod_UpdMaterial.C_BATCH_NO);
ht.Add("N_STATUS", 1);
if (Common.CheckRepeat.CheckTable("TQC_UPD_MATERIAL_MAIN", ht) > 0)
{
if (DialogResult.OK != MessageBox.Show(" 批号'" + mod_UpdMaterial.C_BATCH_NO + "'已申请修料，是否确认继续申请！", "提示", MessageBoxButtons.OKCancel))
{
return;
}
else
{
DataTable dt = bll_Update.GetList_CXXL(row["C_BATCH_NO"].ToString()).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
Mod_TQC_UPDATE_MATERIAL mod_update = bll_Update.GetModel(dt.Rows[i]["C_ID"].ToString());
mod_update.N_STATUS = 0;
mod_update.C_EMP_ID = RV.UI.UserInfo.UserID;
mod_update.D_MOD_DT = RV.UI.ServerTime.timeNow();
bll_Update.Update(mod_update);
}
}
}
#endregion
bllUpdMaterial.Add(mod_UpdMaterial);
MessageBox.Show("申请成功！", "提示");
Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "线材库检申请");//添加操作日志
btn_Query_Main_Click(null, null);
btn_Query1_Click(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void str()
{
try
{
int[] rownumber = gv_XL.GetSelectedRows();//获取选中行号数组；
if (rownumber.Length == 0)
{
MessageBox.Show("请选择需要还料的信息！");
return;
}
for (int i = 0; i < rownumber.Length; i++)
{
DataRow dr = gv_XL.GetDataRow(rownumber[i]);
Mod_TQC_UPDATE_MATERIAL mod = bll_Update.GetModel(dr["C_ID"].ToString());
Mod_TRC_ROLL_PRODCUT mod_roll = bll_roll_product.GetModel(dr["C_ROLL_PRODUCT_ID"].ToString());
decimal? wgt = mod_roll.N_WGT;
DataTable dt = bll_Interface_FR.Get_TM_XL_List(dr["C_BATCH_NO"].ToString(), dr["C_TICK_NO"].ToString()).Tables[0];
if (dt.Rows.Count <= 0)
{
MessageBox.Show("条码库存查不到该批次！");
return;
}
mod.C_TYPE = "2";
mod.N_WGT = wgt;
mod.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]);
if (mod.N_WGT_DIFFERENCE == 0)
{
if (DialogResult.OK != MessageBox.Show("批号：'" + dr["C_BATCH_NO"].ToString() + "',钩号：'" + dr["C_TICK_NO"].ToString() + "',条码重量未修改，是否继续还料", "提示", MessageBoxButtons.OKCancel))
{
break;
}
}
mod.C_EMP_ID = RV.UI.UserInfo.UserID;
mod.D_MOD_DT = RV.UI.ServerTime.timeNow();
if (bll_Update.Update(mod))
{
Mod_TQC_UPDATE_MATERIAL_LOG mod_log = new Mod_TQC_UPDATE_MATERIAL_LOG();
mod_roll.N_WGT = Convert.ToDecimal(dt.Rows[0]["ZL"]);
mod_roll.C_EMP_ID = RV.UI.UserInfo.UserID;
mod_roll.D_MOD_DT = RV.UI.ServerTime.timeNow();
bll_roll_product.Update(mod_roll);
mod_log.N_WGT = wgt;
mod_log.N_WGT_DIFFERENCE = wgt - mod_roll.N_WGT;
mod_log.C_ROLL_PRODUCT_ID = dr["C_ROLL_PRODUCT_ID"].ToString();
mod_log.C_TYPE = "2";
mod_log.C_EMP_ID = RV.UI.UserInfo.UserID;
bll_Update_Log.Add(mod_log);
}
}
MessageBox.Show("还料成功！");
Query1();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 修料
/// </summary>
/// <param name="strs">线材实绩主键</param>
/// <param name="Type">修料状态</param>
/// <param name="PCINFO">特殊信息</param>
/// <returns></returns>
public int TransaTSXX(string strs, string Type, string PCINFO, string rollID, string strSFHG)
{
try
{
Dal_TRC_ROLL_PRODCUT dalTrcRollProduct = new Dal_TRC_ROLL_PRODCUT();
Dal_TQC_UPDATE_MATERIAL dal_Update = new Dal_TQC_UPDATE_MATERIAL();
Dal_TQC_UPDATE_MATERIAL_LOG dal_update_log = new Dal_TQC_UPDATE_MATERIAL_LOG();
Dal_TQC_UPD_MATERIAL_MAIN dalUpdMain = new Dal_TQC_UPD_MATERIAL_MAIN();
Dal_Interface_FR dalInterface_FR = new Dal_Interface_FR();
Dal_TQC_SPECIFIC_CONTENT_LOG dalLog = new Dal_TQC_SPECIFIC_CONTENT_LOG();
TransactionHelper.BeginTransaction();
TransactionHelper_SQL.BeginTransaction();
string strUserID = RV.UI.UserInfo.UserID;
DateTime dTime = RV.UI.ServerTime.timeNow();
string[] strs_Product_ID = strs.Substring(0, strs.Length - 1).Split(',');
string[] strs_ID = null;
if (rollID != "")
{
strs_ID = rollID.Substring(0, rollID.Length - 1).Split(',');
}
if (strs_Product_ID.Length == 0)
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
for (int i = 0; i < strs_Product_ID.Length; i++)
{
Mod_TRC_ROLL_PRODCUT modProduct = dalTrcRollProduct.GetModel(strs_Product_ID[i]);
Mod_TQC_UPDATE_MATERIAL_LOG mod_log = new Mod_TQC_UPDATE_MATERIAL_LOG();
decimal? wgt = modProduct.N_WGT;
DataTable dt = dalInterface_FR.Get_TM_XL_List(modProduct.C_BATCH_NO, modProduct.C_TICK_NO).Tables[0];
if (dt == null)
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
if (rollID == "")
{
Mod_TQC_UPDATE_MATERIAL mod = new Mod_TQC_UPDATE_MATERIAL();
mod.C_ROLL_PRODUCT_ID = modProduct.C_ID;
mod.C_TYPE = Type;
mod.C_EMP_ID = strUserID;
mod.C_SFHG = strSFHG;
mod_log.C_TYPE = mod.C_TYPE;
dalUpdMain.Update_BATCH_NO(modProduct.C_BATCH_NO);
if (!dal_Update.Add_Trans(mod))
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
}
else
{
Mod_TQC_UPDATE_MATERIAL mod = dal_Update.GetModel(strs_ID[i]);
if (Type == "2")
{
if (mod.C_TYPE == "3")
{
mod.C_TYPE = "6";
PCINFO = "0";
Mod_TQC_UPDATE_MATERIAL_LOG mod_logs = new Mod_TQC_UPDATE_MATERIAL_LOG();
mod_logs.C_TYPE = "2";
mod_logs.N_WGT = wgt;
mod_logs.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]);
mod_logs.C_SFHG = mod.C_SFHG;
mod_logs.C_ROLL_PRODUCT_ID = modProduct.C_ID;
mod_logs.C_EMP_ID = strUserID;
if (!dal_update_log.Add_Trans(mod_logs))
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
}
else
{
mod.C_TYPE = Type;
}
}
if (Type == "3")
{
if (mod.C_TYPE == "2")
{
mod.C_TYPE = "6";
PCINFO = "0";
Mod_TQC_UPDATE_MATERIAL_LOG mod_logs = new Mod_TQC_UPDATE_MATERIAL_LOG();
mod_logs.C_TYPE = "3";
mod_logs.N_WGT = wgt;
mod_logs.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]);
mod_logs.C_SFHG = mod.C_SFHG;
mod_logs.C_ROLL_PRODUCT_ID = modProduct.C_ID;
mod_logs.C_EMP_ID = strUserID;
if (!dal_update_log.Add_Trans(mod_logs))
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
}
else
{
mod.C_TYPE = Type;
}
}
mod.C_EMP_ID = strUserID;
mod.D_MOD_DT = dTime;
mod.N_WGT = wgt;
mod.C_SFHG = strSFHG;
mod.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]);
mod_log.C_TYPE = mod.C_TYPE;
mod_log.N_WGT = wgt;
mod_log.N_WGT_DIFFERENCE = wgt - Convert.ToDecimal(dt.Rows[0]["ZL"]);
mod_log.C_SFHG = mod.C_SFHG;
modProduct.N_WGT = Convert.ToDecimal(dt.Rows[0]["ZL"]);
if (!dal_Update.Update_Trans(mod))
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
}
if (PCINFO == "0")
{
if (modProduct.C_PCINFO.Contains("待修料;"))
{
modProduct.C_PCINFO = modProduct.C_PCINFO.Replace("待修料;", "");
}
}
else
{
if (modProduct.C_PCINFO == "")
{
modProduct.C_PCINFO = PCINFO + ";";
}
else if (modProduct.C_PCINFO.Contains("待修料"))
{
modProduct.C_PCINFO = modProduct.C_PCINFO;
}
else
{
modProduct.C_PCINFO = modProduct.C_PCINFO + PCINFO + ";";
}
}
modProduct.C_EMP_ID = strUserID;
modProduct.C_PLANT_DESC = dTime.ToString();
if (!dalTrcRollProduct.Update_Trans_XL(modProduct))
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
mod_log.C_ROLL_PRODUCT_ID = modProduct.C_ID;
mod_log.C_EMP_ID = strUserID;
if (!dal_update_log.Add_Trans(mod_log))
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
string strDJ = "";
if (string.IsNullOrEmpty(modProduct.C_JUDGE_LEV_ZH))
{
strDJ = "DP";
}
else
{
strDJ = modProduct.C_JUDGE_LEV_ZH;
}
string sql = "";
sql += "insert into ReZJB_GPD(Barcode,WGDH,CK,HW,PCH,WLH,WLMC,SX,PH,GG,BB,GH,ZL,BZ,RQ,RKType,RKRY,WeightRQ,ProduceData,PCInfo,vfree0,vfree3,GPTYPE,ZJBstatus,CAPPK,vfree1,vfree2,insertts) values('" + modProduct.C_BARCODE + "','" + modProduct.C_TRC_ROLL_MAIN_ID + "','" + modProduct.C_LINEWH_CODE + "','" + modProduct.C_LINEWH_LOC_CODE + "','" + modProduct.C_BATCH_NO + "','" + modProduct.C_MAT_CODE + "','" + modProduct.C_MAT_DESC + "','" + strDJ + "','" + modProduct.C_STL_GRD + "','" + modProduct.C_SPEC + "mm','" + modProduct.C_GROUP + "','" + modProduct.C_TICK_NO + "','" + modProduct.N_WGT + "','" + modProduct.C_STD_CODE + "','" + modProduct.D_RKRQ + "','" + modProduct.C_MOVE_DESC + "','" + modProduct.C_RKRY + "','" + modProduct.D_WEIGHT_DT + "','" + modProduct.D_PRODUCE_DATE + "','" + modProduct.C_PCINFO + "','" + modProduct.C_STOVE + "','" + modProduct.C_BZYQ + "','','0','" + modProduct.C_ID + "','" + modProduct.C_ZYX1 + "','" + modProduct.C_ZYX2 + "','" + RV.UI.ServerTime.timeNow() + "')";
if (TransactionHelper_SQL.ExecuteSql(sql) == 0)
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
else
{
if (rollID != "")
{
Mod_TQC_UPDATE_MATERIAL mod = dal_Update.GetModel(strs_ID[i]);
if (Type == "2")
{
if (mod.C_TYPE == "3")
{
Mod_TQC_SPECIFIC_CONTENT_LOG modLog = new Mod_TQC_SPECIFIC_CONTENT_LOG();
modLog.C_BATCH_NO = modProduct.C_BATCH_NO;
modLog.C_CONTENT = "取消待修料";
modLog.C_TICK_NO = modProduct.C_TICK_NO;
modLog.C_EMP_ID = strUserID;
if (!dalLog.Add_Trans(modLog))
{
TransactionHelper.RollBack();
TransactionHelper_SQL.RollBack();
return(0);
}
}
}
if (Type == "3")
{
if (mod.C_TYPE == "2")
{
Mod_TQC_SPECIFIC_CONTENT_LOG modLog = new Mod_TQC_SPECIFIC_CONTENT_LOG();
modLog.C_BATCH_NO = modProduct.C_BATCH_NO;
modLog.C_CONTENT = "取消待修料";
modLog.C_TICK_NO = modProduct.C_TICK_NO;
modLog.C_EMP_ID = strUserID;
if (!dalLog.Add_Trans(modLog))
{
TransactionHelper.RollBack();
TransactionHelper_SQL.RollBack();
return(0);
}
}
}
}
}
}
TransactionHelper_SQL.Commit();
TransactionHelper.Commit();
return(1);
}
catch (Exception ex)
{
TransactionHelper_SQL.RollBack();
TransactionHelper.RollBack();
return(0);
}
}
