/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_RESULT_MAIN_ZJB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQC_RESULT_MAIN_ZJB("); strSql.Append("C_BATCH_NO,C_TICK_NO,C_STL_GRD,C_SPEC,C_EMP_ID,D_MOD_DT,C_EMP_ID_ZY,D_MOD_DT_ZY,C_EMP_ID_JS,D_MOD_DT_JS,C_PHYSICS_GROUP_ID,C_CHECK_STATE,N_RECHECK,N_STATUS,C_REMARK,C_DISPOSAL ,C_QRZT,C_ITEM_NAME)"); strSql.Append(" values ("); strSql.Append(":C_BATCH_NO,:C_TICK_NO,:C_STL_GRD,:C_SPEC,:C_EMP_ID,:D_MOD_DT,:C_EMP_ID_ZY,:D_MOD_DT_ZY,:C_EMP_ID_JS,:D_MOD_DT_JS,:C_PHYSICS_GROUP_ID,:C_CHECK_STATE,:N_RECHECK,:N_STATUS,:C_REMARK,:C_DISPOSAL ,:C_QRZT,:C_ITEM_NAME)"); OracleParameter[] parameters = { new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_TICK_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_EMP_ID_ZY", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_ZY", OracleDbType.Date), new OracleParameter(":C_EMP_ID_JS", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_JS", OracleDbType.Date), new OracleParameter(":C_PHYSICS_GROUP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CHECK_STATE", OracleDbType.Varchar2, 10), new OracleParameter(":N_RECHECK", OracleDbType.Decimal, 2), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_DISPOSAL", OracleDbType.Varchar2, 100), new OracleParameter(":C_QRZT", OracleDbType.Varchar2, 100), new OracleParameter(":C_ITEM_NAME", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_BATCH_NO; parameters[1].Value = model.C_TICK_NO; parameters[2].Value = model.C_STL_GRD; parameters[3].Value = model.C_SPEC; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.D_MOD_DT; parameters[6].Value = model.C_EMP_ID_ZY; parameters[7].Value = model.D_MOD_DT_ZY; parameters[8].Value = model.C_EMP_ID_JS; parameters[9].Value = model.D_MOD_DT_JS; parameters[10].Value = model.C_PHYSICS_GROUP_ID; parameters[11].Value = model.C_CHECK_STATE; parameters[12].Value = model.N_RECHECK; parameters[13].Value = model.N_STATUS; parameters[14].Value = model.C_REMARK; parameters[15].Value = model.C_DISPOSAL; parameters[16].Value = model.C_QRZT; parameters[17].Value = model.C_ITEM_NAME; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 确认 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_QR_Click(object sender, EventArgs e) { try { int[] rownumber = gv_SQLB.GetSelectedRows();//获取选中行号数组; if (rownumber.Length == 0) { MessageBox.Show("请选择需要确认的信息!"); return; } for (int i = 0; i < rownumber.Length; i++) { DataRow dr = gv_SQLB.GetDataRow(rownumber[i]); Mod_TQC_RESULT_MAIN_ZJB mod_ZJB = bllResultMainZJB.GetModel(dr["C_ID"].ToString()); if (mod_ZJB.N_STATUS == 0) { MessageBox.Show("已确认,请勿重复操作!"); return; } } if (DialogResult.OK != MessageBox.Show("是否确认已选中的数据?", "提示", MessageBoxButtons.OKCancel)) { return; } for (int i = 0; i < rownumber.Length; i++) { DataRow dr = gv_SQLB.GetDataRow(rownumber[i]); Mod_TQC_RESULT_MAIN_ZJB mod_ZJB = bllResultMainZJB.GetModel(dr["C_ID"].ToString()); mod_ZJB.N_STATUS = 0; bllResultMainZJB.Update(mod_ZJB); Mod_TQC_PHYSICS_RESULT_MAIN modPhysicsResultMain = new Mod_TQC_PHYSICS_RESULT_MAIN(); modPhysicsResultMain.C_BATCH_NO = mod_ZJB.C_BATCH_NO; modPhysicsResultMain.C_TICK_NO = mod_ZJB.C_TICK_NO; modPhysicsResultMain.C_STL_GRD = mod_ZJB.C_STL_GRD; modPhysicsResultMain.C_SPEC = mod_ZJB.C_SPEC; modPhysicsResultMain.C_EMP_ID = mod_ZJB.C_EMP_ID; modPhysicsResultMain.D_MOD_DT = mod_ZJB.D_MOD_DT; modPhysicsResultMain.C_EMP_ID_ZY = RV.UI.UserInfo.UserID; modPhysicsResultMain.D_MOD_DT_ZY = RV.UI.ServerTime.timeNow(); modPhysicsResultMain.C_EMP_ID_JS = mod_ZJB.C_EMP_ID_JS; modPhysicsResultMain.D_MOD_DT_JS = mod_ZJB.D_MOD_DT_JS; modPhysicsResultMain.C_PHYSICS_GROUP_ID = mod_ZJB.C_PHYSICS_GROUP_ID; modPhysicsResultMain.C_CHECK_STATE = mod_ZJB.C_CHECK_STATE; modPhysicsResultMain.N_RECHECK = mod_ZJB.N_RECHECK; bllResultMain.Add(modPhysicsResultMain); } Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加物理性能结果信息");//添加操作日志 MessageBox.Show("确认成功!"); Query_SQ(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_RESULT_MAIN_ZJB GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_BATCH_NO,C_TICK_NO,C_STL_GRD,C_SPEC,C_EMP_ID,D_MOD_DT,C_EMP_ID_ZY,D_MOD_DT_ZY,C_EMP_ID_JS,D_MOD_DT_JS,C_PHYSICS_GROUP_ID,C_CHECK_STATE,N_RECHECK,N_STATUS,C_REMARK,C_DISPOSAL ,C_QRZT,C_ITEM_NAME from TQC_RESULT_MAIN_ZJB "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TQC_RESULT_MAIN_ZJB model = new Mod_TQC_RESULT_MAIN_ZJB(); 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_TQC_RESULT_MAIN_ZJB model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_RESULT_MAIN_ZJB model) { return(dal.Add(model)); }
/// <summary> /// 复检确认 /// </summary> /// <param name="dr">需要确认的数据</param> /// <param name="TickNo">钩号</param> /// <returns></returns> public string Recheck_SL(DataTable dt_main, int[] rownumber, string[] str_tick_no, string strQRZT, int Type) { string result = "1"; try { TransactionHelper.BeginTransaction(); string userID = RV.UI.UserInfo.UserID; DateTime dTime = RV.UI.ServerTime.timeNow(); Dal_TQC_RECHECK dalRecheck = new Dal_TQC_RECHECK(); Dal_TQC_PHYSICS_RESULT_MAIN dalPhysicsResultMain = new Dal_TQC_PHYSICS_RESULT_MAIN(); Dal_TQB_PHYSICS_GROUP dalTqbPhysicsGroup = new Dal_TQB_PHYSICS_GROUP(); Dal_TQC_RESULT_MAIN_ZJB dalResultMainZJB = new Dal_TQC_RESULT_MAIN_ZJB(); for (int i = 0; i < rownumber.Length; i++) { Mod_TQC_RECHECK mod = dalRecheck.GetModel(dt_main.Rows[rownumber[i]]["C_ID"].ToString()); mod.N_IS_QR = Type; mod.C_TICK_NO = str_tick_no[i]; mod.C_QR_USER_ID = userID; mod.D_QR_MOD = dTime; if (!dalRecheck.Update_Trans(mod)) { TransactionHelper.RollBack(); return("0"); } else { string str_PHYSICS_GROUP_ID = dalTqbPhysicsGroup.Get_ID(dt_main.Rows[rownumber[i]]["C_PHYSICS_CODE"].ToString()); if (str_PHYSICS_GROUP_ID == "0") { TransactionHelper.RollBack(); return("0"); } Mod_TQC_RESULT_MAIN_ZJB mod_zjb = new Mod_TQC_RESULT_MAIN_ZJB(); mod_zjb.C_BATCH_NO = dt_main.Rows[rownumber[i]]["C_BATCH_NO"].ToString(); mod_zjb.C_TICK_NO = str_tick_no[i]; mod_zjb.C_STL_GRD = dt_main.Rows[rownumber[i]]["C_STL_GRD"].ToString(); mod_zjb.C_SPEC = dt_main.Rows[rownumber[i]]["C_SPEC"].ToString(); mod_zjb.C_EMP_ID = dt_main.Rows[rownumber[i]]["C_EMP_ID"].ToString(); mod_zjb.D_MOD_DT = Convert.ToDateTime(dt_main.Rows[rownumber[i]]["D_MOD_DT"].ToString()); mod_zjb.C_EMP_ID_ZY = userID; mod_zjb.D_MOD_DT_ZY = Convert.ToDateTime(dTime); mod_zjb.C_EMP_ID_JS = userID; mod_zjb.D_MOD_DT_JS = Convert.ToDateTime(dTime); mod_zjb.C_PHYSICS_GROUP_ID = str_PHYSICS_GROUP_ID; mod_zjb.C_CHECK_STATE = "1"; mod_zjb.N_RECHECK = mod.N_RECHECK; mod_zjb.C_ITEM_NAME = mod.C_ITEM_NAME; mod_zjb.C_QRZT = strQRZT; mod_zjb.C_DISPOSAL = mod.C_DISPOSAL; if (!dalResultMainZJB.Add_Trans(mod_zjb)) { TransactionHelper.RollBack(); return("0"); } } } TransactionHelper.Commit(); } catch (Exception ex) { TransactionHelper.RollBack(); return("0"); } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_RESULT_MAIN_ZJB DataRowToModel(DataRow row) { Mod_TQC_RESULT_MAIN_ZJB model = new Mod_TQC_RESULT_MAIN_ZJB(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_BATCH_NO"] != null) { model.C_BATCH_NO = row["C_BATCH_NO"].ToString(); } if (row["C_TICK_NO"] != null) { model.C_TICK_NO = row["C_TICK_NO"].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_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["C_EMP_ID_ZY"] != null) { model.C_EMP_ID_ZY = row["C_EMP_ID_ZY"].ToString(); } if (row["D_MOD_DT_ZY"] != null && row["D_MOD_DT_ZY"].ToString() != "") { model.D_MOD_DT_ZY = DateTime.Parse(row["D_MOD_DT_ZY"].ToString()); } if (row["C_EMP_ID_JS"] != null) { model.C_EMP_ID_JS = row["C_EMP_ID_JS"].ToString(); } if (row["D_MOD_DT_JS"] != null && row["D_MOD_DT_JS"].ToString() != "") { model.D_MOD_DT_JS = DateTime.Parse(row["D_MOD_DT_JS"].ToString()); } if (row["C_PHYSICS_GROUP_ID"] != null) { model.C_PHYSICS_GROUP_ID = row["C_PHYSICS_GROUP_ID"].ToString(); } if (row["C_CHECK_STATE"] != null) { model.C_CHECK_STATE = row["C_CHECK_STATE"].ToString(); } if (row["N_RECHECK"] != null && row["N_RECHECK"].ToString() != "") { model.N_RECHECK = decimal.Parse(row["N_RECHECK"].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_DISPOSAL"] != null) { model.C_DISPOSAL = row["C_DISPOSAL"].ToString(); } if (row["C_QRZT"] != null) { model.C_QRZT = row["C_QRZT"].ToString(); } if (row["C_ITEM_NAME"] != null) { model.C_ITEM_NAME = row["C_ITEM_NAME"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_RESULT_MAIN_ZJB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQC_RESULT_MAIN_ZJB set "); strSql.Append("C_BATCH_NO=:C_BATCH_NO,"); strSql.Append("C_TICK_NO=:C_TICK_NO,"); strSql.Append("C_STL_GRD=:C_STL_GRD,"); strSql.Append("C_SPEC=:C_SPEC,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("D_MOD_DT=:D_MOD_DT,"); strSql.Append("C_EMP_ID_ZY=:C_EMP_ID_ZY,"); strSql.Append("D_MOD_DT_ZY=:D_MOD_DT_ZY,"); strSql.Append("C_EMP_ID_JS=:C_EMP_ID_JS,"); strSql.Append("D_MOD_DT_JS=:D_MOD_DT_JS,"); strSql.Append("C_PHYSICS_GROUP_ID=:C_PHYSICS_GROUP_ID,"); strSql.Append("C_CHECK_STATE=:C_CHECK_STATE,"); strSql.Append("N_RECHECK=:N_RECHECK,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_DISPOSAL=:C_DISPOSAL,"); strSql.Append("C_QRZT=:C_QRZT,"); strSql.Append("C_ITEM_NAME=:C_ITEM_NAME"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_TICK_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_EMP_ID_ZY", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_ZY", OracleDbType.Date), new OracleParameter(":C_EMP_ID_JS", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_JS", OracleDbType.Date), new OracleParameter(":C_PHYSICS_GROUP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CHECK_STATE", OracleDbType.Varchar2, 10), new OracleParameter(":N_RECHECK", OracleDbType.Decimal, 2), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_DISPOSAL", OracleDbType.Varchar2, 100), new OracleParameter(":C_QRZT", OracleDbType.Varchar2, 100), new OracleParameter(":C_ITEM_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_BATCH_NO; parameters[1].Value = model.C_TICK_NO; parameters[2].Value = model.C_STL_GRD; parameters[3].Value = model.C_SPEC; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.D_MOD_DT; parameters[6].Value = model.C_EMP_ID_ZY; parameters[7].Value = model.D_MOD_DT_ZY; parameters[8].Value = model.C_EMP_ID_JS; parameters[9].Value = model.D_MOD_DT_JS; parameters[10].Value = model.C_PHYSICS_GROUP_ID; parameters[11].Value = model.C_CHECK_STATE; parameters[12].Value = model.N_RECHECK; parameters[13].Value = model.N_STATUS; parameters[14].Value = model.C_REMARK; parameters[15].Value = model.C_DISPOSAL; parameters[16].Value = model.C_QRZT; parameters[17].Value = model.C_ITEM_NAME; parameters[18].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }