/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_PRESENT_SAMPLES_JSZX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQC_PRESENT_SAMPLES_JSZX("); strSql.Append("C_BATCH_NO,C_TICK_NO,C_STL_GRD,C_SPEC,N_ENTRUST_TYPE,N_STATUS,C_REMARK,C_EMP_ID_SY,D_MOD_DT_SY,C_EMP_ID_JS,D_MOD_DT_JS,C_EMP_ID_ZY,D_MOD_DT_ZY,C_EQ_NAME,C_EQ_NUMBER,C_EQ_CODE,N_SAMPLES_NUM,D_MOD_DT)"); strSql.Append(" values ("); strSql.Append(":C_BATCH_NO,:C_TICK_NO,:C_STL_GRD,:C_SPEC,:N_ENTRUST_TYPE,:N_STATUS,:C_REMARK,:C_EMP_ID_SY,:D_MOD_DT_SY,:C_EMP_ID_JS,:D_MOD_DT_JS,:C_EMP_ID_ZY,:D_MOD_DT_ZY,:C_EQ_NAME,:C_EQ_NUMBER,:C_EQ_CODE,:N_SAMPLES_NUM,:D_MOD_DT)"); 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(":N_ENTRUST_TYPE", OracleDbType.Decimal, 1), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID_SY", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_SY", OracleDbType.Date), new OracleParameter(":C_EMP_ID_JS", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_JS", OracleDbType.Date), new OracleParameter(":C_EMP_ID_ZY", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_ZY", OracleDbType.Date), new OracleParameter(":C_EQ_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_EQ_NUMBER", OracleDbType.Varchar2, 100), new OracleParameter(":C_EQ_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":N_SAMPLES_NUM", OracleDbType.Decimal, 5), new OracleParameter(":D_MOD_DT", OracleDbType.Date) }; 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.N_ENTRUST_TYPE; parameters[5].Value = model.N_STATUS; parameters[6].Value = model.C_REMARK; parameters[7].Value = model.C_EMP_ID_SY; parameters[8].Value = model.D_MOD_DT_SY; parameters[9].Value = model.C_EMP_ID_JS; parameters[10].Value = model.D_MOD_DT_JS; parameters[11].Value = model.C_EMP_ID_ZY; parameters[12].Value = model.D_MOD_DT_ZY; parameters[13].Value = model.C_EQ_NAME; parameters[14].Value = model.C_EQ_NUMBER; parameters[15].Value = model.C_EQ_CODE; parameters[16].Value = model.N_SAMPLES_NUM; parameters[17].Value = model.D_MOD_DT; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_PRESENT_SAMPLES_JSZX GetModel_Trans(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_BATCH_NO,C_TICK_NO,C_STL_GRD,C_SPEC,N_ENTRUST_TYPE,N_STATUS,C_REMARK,C_EMP_ID_SY,D_MOD_DT_SY,C_EMP_ID_JS,D_MOD_DT_JS,C_EMP_ID_ZY,D_MOD_DT_ZY,C_EQ_NAME,C_EQ_NUMBER,C_EQ_CODE,N_SAMPLES_NUM,D_MOD_DT from TQC_PRESENT_SAMPLES_JSZX "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TQC_PRESENT_SAMPLES_JSZX model = new Mod_TQC_PRESENT_SAMPLES_JSZX(); DataSet ds = TransactionHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_PRESENT_SAMPLES_JSZX DataRowToModel(DataRow row) { Mod_TQC_PRESENT_SAMPLES_JSZX model = new Mod_TQC_PRESENT_SAMPLES_JSZX(); 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["N_ENTRUST_TYPE"] != null && row["N_ENTRUST_TYPE"].ToString() != "") { model.N_ENTRUST_TYPE = decimal.Parse(row["N_ENTRUST_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_SY"] != null) { model.C_EMP_ID_SY = row["C_EMP_ID_SY"].ToString(); } if (row["D_MOD_DT_SY"] != null && row["D_MOD_DT_SY"].ToString() != "") { model.D_MOD_DT_SY = DateTime.Parse(row["D_MOD_DT_SY"].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_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_EQ_NAME"] != null) { model.C_EQ_NAME = row["C_EQ_NAME"].ToString(); } if (row["C_EQ_NUMBER"] != null) { model.C_EQ_NUMBER = row["C_EQ_NUMBER"].ToString(); } if (row["C_EQ_CODE"] != null) { model.C_EQ_CODE = row["C_EQ_CODE"].ToString(); } if (row["N_SAMPLES_NUM"] != null && row["N_SAMPLES_NUM"].ToString() != "") { model.N_SAMPLES_NUM = decimal.Parse(row["N_SAMPLES_NUM"].ToString()); } if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "") { model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update_Trans(Mod_TQC_PRESENT_SAMPLES_JSZX model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQC_PRESENT_SAMPLES_JSZX 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("N_ENTRUST_TYPE=:N_ENTRUST_TYPE,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_EMP_ID_SY=:C_EMP_ID_SY,"); strSql.Append("D_MOD_DT_SY=:D_MOD_DT_SY,"); strSql.Append("C_EMP_ID_JS=:C_EMP_ID_JS,"); strSql.Append("D_MOD_DT_JS=:D_MOD_DT_JS,"); strSql.Append("C_EMP_ID_ZY=:C_EMP_ID_ZY,"); strSql.Append("D_MOD_DT_ZY=:D_MOD_DT_ZY,"); strSql.Append("C_EQ_NAME=:C_EQ_NAME,"); strSql.Append("C_EQ_NUMBER=:C_EQ_NUMBER,"); strSql.Append("C_EQ_CODE=:C_EQ_CODE,"); strSql.Append("N_SAMPLES_NUM=:N_SAMPLES_NUM,"); strSql.Append("D_MOD_DT=:D_MOD_DT"); 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(":N_ENTRUST_TYPE", OracleDbType.Decimal, 1), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID_SY", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_SY", OracleDbType.Date), new OracleParameter(":C_EMP_ID_JS", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_JS", OracleDbType.Date), new OracleParameter(":C_EMP_ID_ZY", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_ZY", OracleDbType.Date), new OracleParameter(":C_EQ_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_EQ_NUMBER", OracleDbType.Varchar2, 100), new OracleParameter(":C_EQ_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":N_SAMPLES_NUM", OracleDbType.Decimal, 5), new OracleParameter(":D_MOD_DT", OracleDbType.Date), 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.N_ENTRUST_TYPE; parameters[5].Value = model.N_STATUS; parameters[6].Value = model.C_REMARK; parameters[7].Value = model.C_EMP_ID_SY; parameters[8].Value = model.D_MOD_DT_SY; parameters[9].Value = model.C_EMP_ID_JS; parameters[10].Value = model.D_MOD_DT_JS; parameters[11].Value = model.C_EMP_ID_ZY; parameters[12].Value = model.D_MOD_DT_ZY; parameters[13].Value = model.C_EQ_NAME; parameters[14].Value = model.C_EQ_NUMBER; parameters[15].Value = model.C_EQ_CODE; parameters[16].Value = model.N_SAMPLES_NUM; parameters[17].Value = model.D_MOD_DT; parameters[18].Value = model.C_ID; int rows = TransactionHelper.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_JS_SY_Click(object sender, EventArgs e) { try { bool IS_Success = true; string userID = RV.UI.UserInfo.userID; int[] rownumber = gv_SYXX.GetSelectedRows();//获取选中行号数组; if (rownumber.Length > 0) { ArrayList SQLStringList = new ArrayList(); for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = gv_SYXX.GetRowCellValue(selectedHandle, "取样主表主键").ToString(); Mod_TQC_PRESENT_SAMPLES_JSZX modJSZX = bllTqcPresentSamplesJszx.GetModel(strID); if (modJSZX != null) { if (modJSZX.N_ENTRUST_TYPE == 3) { MessageBox.Show("批号:" + modJSZX.C_BATCH_NO + "钩号:" + modJSZX.C_TICK_NO + "已经接收送样,不能重复操作!"); IS_Success = false; break; } } SQLStringList.Add(" update tqc_present_samples_jszx set N_ENTRUST_TYPE=3,C_EMP_ID_ZY='" + userID + "',D_MOD_DT_ZY=SYSDATE where C_ID='" + strID + "' "); Mod_TQC_PRESENT_SAMPLES mod = bllTqcPresentSamples.GetModel(strID); if (mod != null) { DataTable dt_GroupID = bllTqcPresentSamplesName.Get_PHYSICS_GROUP_ID(strID, "技术中心", gv_SYXX.GetRowCellValue(selectedHandle, "执行标准").ToString(), gv_SYXX.GetRowCellValue(selectedHandle, "钢种").ToString()).Tables[0]; if (dt_GroupID.Rows.Count > 0) { for (int kk = 0; kk < dt_GroupID.Rows.Count; kk++) { SQLStringList.Add(" insert into tqc_physics_result_main(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,C_PRESENT_SAMPLES_ID)values('" + mod.C_BATCH_NO + "','" + mod.C_TICK_NO + "','" + mod.C_STL_GRD + "','" + mod.C_SPEC + "','" + mod.C_EMP_ID + "',to_date('" + mod.D_MOD_DT + "','yyyy-mm-dd hh24:mi:ss'),'" + userID + "',SYSDATE,'" + mod.C_EMP_ID_JS + "',to_date('" + mod.D_MOD_DT_JS + "','yyyy-mm-dd hh24:mi:ss'),'" + dt_GroupID.Rows[kk]["C_PHYSICS_GROUP_ID"].ToString() + "','0','" + strID + "' ) "); } } else { string strGroupID = bllTqcPresentSamplesName.Get_GroupID(); if (!string.IsNullOrEmpty(strGroupID)) { SQLStringList.Add(" insert into tqc_physics_result_main(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,C_PRESENT_SAMPLES_ID)values('" + mod.C_BATCH_NO + "','" + mod.C_TICK_NO + "','" + mod.C_STL_GRD + "','" + mod.C_SPEC + "','" + mod.C_EMP_ID + "',to_date('" + mod.D_MOD_DT + "','yyyy-mm-dd hh24:mi:ss'),'" + userID + "',SYSDATE,'" + mod.C_EMP_ID_JS + "',to_date('" + mod.D_MOD_DT_JS + "','yyyy-mm-dd hh24:mi:ss'),'" + strGroupID + "','0','" + strID + "' ) "); } else { MessageBox.Show("取样名称和性能分组没有匹配关系,或者性能分组与执行标准钢种没有匹配关系!"); IS_Success = false; break; } } } } if (IS_Success) { if (bllTqcPresentSamplesName.SaveSamp(SQLStringList)) { Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "生成制样信息");//添加操作日志 MessageBox.Show("保存成功!"); BindSYXX_CG(); BindJYXX_CG(); } } } else { MessageBox.Show("请选择需要制样的信息!"); return; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_PRESENT_SAMPLES_JSZX model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_PRESENT_SAMPLES_JSZX model) { return(dal.Add(model)); }
/// <summary> /// 保存性能值 /// </summary> /// <returns></returns> public string Cancle_Sample(int[] rownumber, DataTable dt) { try { string result = "1"; TransactionHelper.BeginTransaction(); string strUserID = RV.UI.UserInfo.userID; DateTime time = RV.UI.ServerTime.timeNow(); Dal_TQC_PRESENT_SAMPLES_JSZX dalJSZX = new Dal_TQC_PRESENT_SAMPLES_JSZX(); Dal_TQC_PHYSICS_RESULT_MAIN dalMain = new Dal_TQC_PHYSICS_RESULT_MAIN(); Dal_TQC_PHYSICS_RESULT dalResult = new Dal_TQC_PHYSICS_RESULT(); for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = dt.Rows[selectedHandle]["取样主表主键"].ToString(); Mod_TQC_PRESENT_SAMPLES_JSZX modJSZX = dalJSZX.GetModel_Trans(strID); if (modJSZX != null) { modJSZX.N_ENTRUST_TYPE = 2; modJSZX.C_EMP_ID_ZY = ""; modJSZX.D_MOD_DT_ZY = null; if (!dalJSZX.Update_Trans(modJSZX)) { TransactionHelper.RollBack(); return("取消接样失败!"); } Mod_TQC_PHYSICS_RESULT_MAIN modMain = dalMain.GetModel_Main(modJSZX.C_ID); if (modMain != null) { int count = dalResult.Get_Count(modMain.C_ID); if (count > 0) { TransactionHelper.RollBack(); return(modMain.C_BATCH_NO + "已录入性能值,不能取消接样!"); } else { if (!dalMain.Delete_Trans(modMain.C_ID)) { TransactionHelper.RollBack(); return("取消接样失败!"); } } } } } TransactionHelper.Commit(); return(result); } catch (Exception ex) { TransactionHelper.RollBack(); return(ex.Message); } }