/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="FOUNDERPCB_OPERATION_LOG">founderpcb_operation_log对象</param> /// <returns>新插入记录的编号</returns> public int Add(FOUNDERPCB_OPERATION_LOG founderpcb_operation_log) { #region 调用SQL存储过程进行添加 string sql = "sp_FOUNDERPCB_OPERATION_LOG_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@PRO_RKEY", SqlDbType.Decimal, 9), new SqlParameter("@MODULE_ID", SqlDbType.VarChar, 10), new SqlParameter("@MODULE_NAME", SqlDbType.VarChar, 30), new SqlParameter("@ACTION", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 1000), new SqlParameter("@DO_DATE", SqlDbType.DateTime, 8) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = founderpcb_operation_log.RKEY; parameters[3].Value = founderpcb_operation_log.PRO_RKEY; parameters[4].Value = founderpcb_operation_log.MODULE_ID; parameters[5].Value = founderpcb_operation_log.MODULE_NAME; parameters[6].Value = founderpcb_operation_log.ACTION; parameters[7].Value = founderpcb_operation_log.MEMO; if (founderpcb_operation_log.DO_DATE == DateTime.Parse("1900-1-1") || founderpcb_operation_log.DO_DATE == DateTime.Parse("0001-1-1")) { parameters[8].Value = null; } else { parameters[8].Value = founderpcb_operation_log.DO_DATE; } #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); founderpcb_operation_log.RKEY = decimal.Parse(parameters[2].Value.ToString()); //log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";FOUNDERPCB_OPERATION_LOG,save successful"); } catch (Exception e) { ///message ID result = 2; // log.Error("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";"+e.Message,e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="FOUNDERPCB_SYSTEM_PARA">founderpcb_system_para对象</param> /// <returns>新插入记录的编号</returns> public int Add(FOUNDERPCB_SYSTEM_PARA founderpcb_system_para) { #region 调用SQL存储过程进行添加 string sql = "sp_FOUNDERPCB_SYSTEM_PARA_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@PARA_ID", SqlDbType.Int, 4), new SqlParameter("@DESCRIPTION", SqlDbType.VarChar, 30), new SqlParameter("@PARAMETER_VALUES", SqlDbType.VarChar, 200), new SqlParameter("@CREATE_DATE", SqlDbType.DateTime, 8) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = founderpcb_system_para.RKEY; parameters[3].Value = founderpcb_system_para.PARA_ID; parameters[4].Value = founderpcb_system_para.DESCRIPTION; parameters[5].Value = founderpcb_system_para.PARAMETER_VALUES; if (founderpcb_system_para.CREATE_DATE == DateTime.Parse("1900-1-1") || founderpcb_system_para.CREATE_DATE == DateTime.Parse("0001-1-1")) { parameters[6].Value = null; } else { parameters[6].Value = founderpcb_system_para.CREATE_DATE; } #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); founderpcb_system_para.RKEY = decimal.Parse(parameters[2].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";FOUNDERPCB_SYSTEM_PARA,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0497">data0497对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0497 data0497) { #region 调用SQL存储过程进行添加 string sql = "sp_DATA0497_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@APPROVAL_ROUTE_CODE", SqlDbType.VarChar, 10), new SqlParameter("@APPROVAL_ROUTE_DESC", SqlDbType.VarChar, 30), new SqlParameter("@ABBR_NAME", SqlDbType.VarChar, 10), new SqlParameter("@APPROVAL_TYPE", SqlDbType.Decimal, 9), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9), new SqlParameter("@FROM_VALUE", SqlDbType.Decimal, 13), new SqlParameter("@TO_VALUE", SqlDbType.Decimal, 13) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = data0497.RKEY; parameters[3].Value = data0497.APPROVAL_ROUTE_CODE; parameters[4].Value = data0497.APPROVAL_ROUTE_DESC; parameters[5].Value = data0497.ABBR_NAME; parameters[6].Value = data0497.APPROVAL_TYPE; parameters[7].Value = data0497.ACTIVE_FLAG; parameters[8].Value = data0497.FROM_VALUE; parameters[9].Value = data0497.TO_VALUE; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); data0497.RKEY = decimal.Parse(parameters[2].Value.ToString()); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";DATA0497,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0011">data0011对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0011 data0011) { #region 调用SQL存储过程进行添加 string sql = "sp_DATA0011_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@FILE_POINTER", SqlDbType.Decimal, 9), new SqlParameter("@SOURCE_TYPE", SqlDbType.Decimal, 9), new SqlParameter("@NOTE_PAD_LINE_1", SqlDbType.VarChar, 70), new SqlParameter("@NOTE_PAD_LINE_2", SqlDbType.VarChar, 70), new SqlParameter("@NOTE_PAD_LINE_3", SqlDbType.VarChar, 70), new SqlParameter("@NOTE_PAD_LINE_4", SqlDbType.VarChar, 70) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = data0011.RKEY; parameters[3].Value = data0011.FILE_POINTER; parameters[4].Value = data0011.SOURCE_TYPE; parameters[5].Value = data0011.NOTE_PAD_LINE_1; parameters[6].Value = data0011.NOTE_PAD_LINE_2; parameters[7].Value = data0011.NOTE_PAD_LINE_3; parameters[8].Value = data0011.NOTE_PAD_LINE_4; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); data0011.RKEY = decimal.Parse(parameters[2].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";DATA0011,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0003">data0003对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0003 data0003) { #region 调用SQL存储过程进行添加 string sql = "sp_DATA0003_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@TDATE", SqlDbType.DateTime,8), new SqlParameter("@FLAG", SqlDbType.VarChar, 1) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = data0003.RKEY; if (data0003.TDATE == DateTime.Parse("1900-1-1") || data0003.TDATE == DateTime.Parse("0001-1-1")) { parameters[3].Value = null; } else { parameters[3].Value = data0003.TDATE; } parameters[4].Value = data0003.FLAG; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); data0003.RKEY = decimal.Parse(parameters[2].Value.ToString()); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";DATA0003,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="FOUNDERPCB_FRIGHTE_01">founderpcb_frighte_01对象</param> /// <returns>新插入记录的编号</returns> public int Add(FOUNDERPCB_FRIGHTE_01 founderpcb_frighte_01) { #region 调用SQL存储过程进行添加 string sql = "sp_FOUNDERPCB_FRIGHTE_01_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@UP_MODULE_ID", SqlDbType.VarChar, 50), new SqlParameter("@MODULE_ID", SqlDbType.VarChar, 50), new SqlParameter("@MODULE_ENGLISH", SqlDbType.VarChar, 50), new SqlParameter("@MODULE_NAME", SqlDbType.VarChar, 50), new SqlParameter("@MODULE_DESC", SqlDbType.VarChar, 500) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = founderpcb_frighte_01.RKEY; parameters[3].Value = founderpcb_frighte_01.UP_MODULE_ID; parameters[4].Value = founderpcb_frighte_01.MODULE_ID; parameters[5].Value = founderpcb_frighte_01.MODULE_ENGLISH; parameters[6].Value = founderpcb_frighte_01.MODULE_NAME; parameters[7].Value = founderpcb_frighte_01.MODULE_DESC; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); founderpcb_frighte_01.RKEY = decimal.Parse(parameters[2].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";FOUNDERPCB_FRIGHTE_01,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="FOUNDERPCB_GROUP_D">founderpcb_group_d对象</param> /// <returns>新插入记录的编号</returns> public int Add(FOUNDERPCB_GROUP_D founderpcb_group_d) { #region 调用SQL存储过程进行添加 string sql = "sp_FOUNDERPCB_GROUP_D_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@PRO_RKEY", SqlDbType.Decimal, 9), new SqlParameter("@SORT", SqlDbType.Int, 4), new SqlParameter("@SRCE_PTR", SqlDbType.VarChar, 20), new SqlParameter("@PERMISSION", SqlDbType.VarChar, 6) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = founderpcb_group_d.RKEY; parameters[3].Value = founderpcb_group_d.PRO_RKEY; parameters[4].Value = founderpcb_group_d.SORT; parameters[5].Value = founderpcb_group_d.SRCE_PTR; parameters[6].Value = founderpcb_group_d.PERMISSION; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); founderpcb_group_d.RKEY = decimal.Parse(parameters[2].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";FOUNDERPCB_GROUP_D,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0498">data0498对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0498 data0498) { #region 调用SQL存储过程进行添加 string sql = "sp_DATA0498_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@APPROVAL_ROUTE_PTR", SqlDbType.Decimal, 9), new SqlParameter("@APPROVAL_STEP_NO", SqlDbType.Decimal, 9), new SqlParameter("@APPROVAL_STEP_DESC", SqlDbType.VarChar, 30) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = data0498.RKEY; parameters[3].Value = data0498.APPROVAL_ROUTE_PTR; parameters[4].Value = data0498.APPROVAL_STEP_NO; parameters[5].Value = data0498.APPROVAL_STEP_DESC; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); data0498.RKEY = decimal.Parse(parameters[2].Value.ToString()); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";DATA0498,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0004">data0004对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0004 data0004) { #region 调用SQL存储过程进行添加 string sql = "sp_DATA0004_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@CONTROL_NO_LENGTH", SqlDbType.Decimal, 9), new SqlParameter("@SEED_VALUE", SqlDbType.VarChar, 20), new SqlParameter("@SEED_FLAG", SqlDbType.Decimal, 9) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = data0004.RKEY; parameters[3].Value = data0004.CONTROL_NO_LENGTH; parameters[4].Value = data0004.SEED_VALUE; parameters[5].Value = data0004.SEED_FLAG; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); data0004.RKEY = decimal.Parse(parameters[2].Value.ToString()); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";DATA0004,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="FOUNDERPCB_MENU_EXT">founderpcb_menu_ext对象</param> /// <returns>新插入记录的编号</returns> public int Add(FOUNDERPCB_MENU_EXT founderpcb_menu_ext) { #region 调用SQL存储过程进行添加 string sql = "sp_FOUNDERPCB_MENU_EXT_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@ClassName", SqlDbType.VarChar, 100), new SqlParameter("@ImgIndex", SqlDbType.Int, 4), new SqlParameter("@Runnable", SqlDbType.Bit, 1) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = founderpcb_menu_ext.RKEY; parameters[3].Value = founderpcb_menu_ext.CLASSNAME; parameters[4].Value = founderpcb_menu_ext.IMGINDEX; parameters[5].Value = founderpcb_menu_ext.RUNNABLE; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); founderpcb_menu_ext.RKEY = decimal.Parse(parameters[2].Value.ToString()); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";FOUNDERPCB_MENU_EXT,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
///<sumary> /// 删除 ///</sumary> /// <param name="data0002">对象</param> ///<returns>返回INT类型号, 0为操作成功, 非0操作失败.</returns> public int Delete(DATA0002 data0002) { #region 调用SQL存储过程进行删除 string sql = "sp_DATA0002_Delete"; //========================= SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), new SqlParameter("@RKEY", SqlDbType.Decimal, 9) }; parameters[0].Value = 1; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Value = data0002.RKEY; //========================= #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";DATA0002,delete successful"); } catch (Exception e) { result = 2; log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="FOUNDERPCB_USER">founderpcb_user对象</param> /// <returns>新插入记录的编号</returns> public int Add(FOUNDERPCB_USER founderpcb_user) { #region 调用SQL存储过程进行添加 string sql = "sp_FOUNDERPCB_USER_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@LOGIN_ID", SqlDbType.VarChar, 30), new SqlParameter("@PRO_RKEY", SqlDbType.Decimal, 9), new SqlParameter("@NAME", SqlDbType.VarChar, 20), new SqlParameter("@DEPT", SqlDbType.VarChar, 100), new SqlParameter("@POSITION", SqlDbType.VarChar, 30), new SqlParameter("@TEL_NUMBER", SqlDbType.VarChar, 30), new SqlParameter("@MOBILE", SqlDbType.VarChar, 30), new SqlParameter("@ADDR", SqlDbType.VarChar, 200), new SqlParameter("@DATA0073RKEY", SqlDbType.Decimal, 9), new SqlParameter("@ROLE", SqlDbType.Int, 4), new SqlParameter("@SYS_VERSION", SqlDbType.VarChar, 20), new SqlParameter("@CREATE_DATE", SqlDbType.DateTime, 8) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = founderpcb_user.RKEY; parameters[3].Value = founderpcb_user.LOGIN_ID; parameters[4].Value = founderpcb_user.PRO_RKEY; parameters[5].Value = founderpcb_user.NAME; parameters[6].Value = founderpcb_user.DEPT; parameters[7].Value = founderpcb_user.POSITION; parameters[8].Value = founderpcb_user.TEL_NUMBER; parameters[9].Value = founderpcb_user.MOBILE; parameters[10].Value = founderpcb_user.ADDR; parameters[11].Value = founderpcb_user.DATA0073RKEY; parameters[12].Value = founderpcb_user.ROLE; parameters[13].Value = founderpcb_user.SYS_VERSION; if (founderpcb_user.CREATE_DATE == DateTime.Parse("1900-1-1") || founderpcb_user.CREATE_DATE == DateTime.Parse("0001-1-1")) { parameters[14].Value = null; } else { parameters[14].Value = founderpcb_user.CREATE_DATE; } #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); founderpcb_user.RKEY = decimal.Parse(parameters[2].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";FOUNDERPCB_USER,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0073">data0073对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0073 data0073) { #region 调用SQL存储过程进行添加 string sql = "sp_DATA0073_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@USER_ID", SqlDbType.VarChar, 5), new SqlParameter("@USER_FULL_NAME", SqlDbType.VarChar, 30), new SqlParameter("@USER_LOGIN_NAME", SqlDbType.VarChar, 10), new SqlParameter("@USER_PASSWORD", SqlDbType.Binary, 12), new SqlParameter("@USER_STATION", SqlDbType.Decimal, 9), new SqlParameter("@USER_GROUP_FLAG", SqlDbType.Decimal, 9), new SqlParameter("@LANGUAGE_FLAG", SqlDbType.VarChar, 1), new SqlParameter("@GROUP_PTR", SqlDbType.Decimal, 9), new SqlParameter("@DEF_PRINTER_PTR", SqlDbType.Decimal, 9), new SqlParameter("@EMPLOYEE_PTR", SqlDbType.Decimal, 9), new SqlParameter("@NETWORK_ID", SqlDbType.VarChar, 8), new SqlParameter("@NODE_ID", SqlDbType.VarChar, 12), new SqlParameter("@SESSION_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = data0073.RKEY; parameters[3].Value = data0073.USER_ID; parameters[4].Value = data0073.USER_FULL_NAME; parameters[5].Value = data0073.USER_LOGIN_NAME; parameters[6].Value = data0073.USER_PASSWORD; parameters[7].Value = data0073.USER_STATION; parameters[8].Value = data0073.USER_GROUP_FLAG; parameters[9].Value = data0073.LANGUAGE_FLAG; parameters[10].Value = data0073.GROUP_PTR; parameters[11].Value = data0073.DEF_PRINTER_PTR; parameters[12].Value = data0073.EMPLOYEE_PTR; parameters[13].Value = data0073.NETWORK_ID; parameters[14].Value = data0073.NODE_ID; parameters[15].Value = data0073.SESSION_ID; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); data0073.RKEY = decimal.Parse(parameters[2].Value.ToString()); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";DATA0073,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="GREEKB_LOGIN_LOG">GREEKB_login_log对象</param> /// <returns>新插入记录的编号</returns> public int Add(GREEKB_LOGIN_LOG GREEKB_login_log) { #region 调用SQL存储过程进行添加 string sql = "sp_GREEKB_LOGIN_LOG_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@PRO_RKEY", SqlDbType.Decimal, 9), new SqlParameter("@LOGIN_ID", SqlDbType.VarChar, 30), new SqlParameter("@LOGIN_NAME", SqlDbType.VarChar, 20), new SqlParameter("@LOGIN_IP", SqlDbType.VarChar, 20), new SqlParameter("@LOGIN_DATE", SqlDbType.DateTime, 8), new SqlParameter("@LOGIN_OUT", SqlDbType.DateTime, 8) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = GREEKB_login_log.RKEY; parameters[3].Value = GREEKB_login_log.PRO_RKEY; parameters[4].Value = GREEKB_login_log.LOGIN_ID; parameters[5].Value = GREEKB_login_log.LOGIN_NAME; parameters[6].Value = GREEKB_login_log.LOGIN_IP; if (GREEKB_login_log.LOGIN_DATE == DateTime.Parse("1900-1-1") || GREEKB_login_log.LOGIN_DATE == DateTime.Parse("0001-1-1")) { parameters[7].Value = null; } else { parameters[7].Value = GREEKB_login_log.LOGIN_DATE; } if (GREEKB_login_log.LOGIN_OUT == DateTime.Parse("1900-1-1") || GREEKB_login_log.LOGIN_OUT == DateTime.Parse("0001-1-1")) { parameters[8].Value = null; } else { parameters[8].Value = GREEKB_login_log.LOGIN_OUT; } #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); GREEKB_login_log.RKEY = decimal.Parse(parameters[2].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";GREEKB_LOGIN_LOG,save successful"); } catch (Exception e) { ///message ID result = 2; // log.Error("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";"+e.Message,e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0005">data0005对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0005 data0005) { #region 调用SQL存储过程进行添加 string sql = "sp_DATA0005_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@EMPL_CODE", SqlDbType.VarChar, 5), new SqlParameter("@EMPLOYEE_NAME", SqlDbType.VarChar, 30), new SqlParameter("@ABBR_NAME", SqlDbType.VarChar, 10), new SqlParameter("@EMPLOYEE_ID", SqlDbType.VarChar, 15), new SqlParameter("@ADDRESS_LINE_1", SqlDbType.VarChar, 30), new SqlParameter("@ADDRESS_LINE_2", SqlDbType.VarChar, 30), new SqlParameter("@ADDRESS_LINE_3", SqlDbType.VarChar, 30), new SqlParameter("@STATE", SqlDbType.VarChar, 3), new SqlParameter("@ZIP", SqlDbType.VarChar, 10), new SqlParameter("@PHONE", SqlDbType.VarChar, 30), new SqlParameter("@NOTE_PAD_POINTER", SqlDbType.Decimal, 9), new SqlParameter("@PAY_RATE_1", SqlDbType.Decimal, 13), new SqlParameter("@PAY_RATE_2", SqlDbType.Decimal, 13), new SqlParameter("@PAY_RATE_3", SqlDbType.Decimal, 13), new SqlParameter("@START_TIME_1", SqlDbType.Decimal, 9), new SqlParameter("@START_TIME_2", SqlDbType.Decimal, 9), new SqlParameter("@START_TIME_3", SqlDbType.Decimal, 9), new SqlParameter("@ACTIVE_FLAG", SqlDbType.VarChar, 1), new SqlParameter("@BUYER_FLAG", SqlDbType.VarChar, 1), new SqlParameter("@INACTIVE_DATE", SqlDbType.DateTime, 8), new SqlParameter("@TPOSTION", SqlDbType.VarChar, 40), new SqlParameter("@EMAIL", SqlDbType.VarChar, 40), new SqlParameter("@EMPL_PASSWORD", SqlDbType.Binary, 12) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = data0005.RKEY; parameters[3].Value = data0005.EMPL_CODE; parameters[4].Value = data0005.EMPLOYEE_NAME; parameters[5].Value = data0005.ABBR_NAME; parameters[6].Value = data0005.EMPLOYEE_ID; parameters[7].Value = data0005.ADDRESS_LINE_1; parameters[8].Value = data0005.ADDRESS_LINE_2; parameters[9].Value = data0005.ADDRESS_LINE_3; parameters[10].Value = data0005.STATE; parameters[11].Value = data0005.ZIP; parameters[12].Value = data0005.PHONE; parameters[13].Value = data0005.NOTE_PAD_POINTER; parameters[14].Value = data0005.PAY_RATE_1; parameters[15].Value = data0005.PAY_RATE_2; parameters[16].Value = data0005.PAY_RATE_3; parameters[17].Value = data0005.START_TIME_1; parameters[18].Value = data0005.START_TIME_2; parameters[19].Value = data0005.START_TIME_3; parameters[20].Value = data0005.ACTIVE_FLAG; parameters[21].Value = data0005.BUYER_FLAG; if (data0005.INACTIVE_DATE == DateTime.Parse("1900-1-1") || data0005.INACTIVE_DATE == DateTime.Parse("0001-1-1")) { parameters[22].Value = null; } else { parameters[22].Value = data0005.INACTIVE_DATE; } parameters[23].Value = data0005.TPOSTION; parameters[24].Value = data0005.EMAIL; parameters[25].Value = data0005.EMPL_PASSWORD; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); data0005.RKEY = decimal.Parse(parameters[2].Value.ToString()); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";DATA0005,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0001">data0001对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0001 data0001) { #region 调用SQL存储过程进行添加 string sql = "sp_DATA0001_Add"; ///存储过程名 SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), ///new SqlParameter("@RKEY",SqlDbType.Decimal,9), new SqlParameter("@RKEY", SqlDbType.Float), new SqlParameter("@CURR_CODE", SqlDbType.VarChar, 5), new SqlParameter("@CURR_NAME", SqlDbType.VarChar, 20), new SqlParameter("@EXCH_RATE", SqlDbType.Decimal, 13), new SqlParameter("@TDATE", SqlDbType.DateTime, 8), new SqlParameter("@TREADONLY", SqlDbType.Decimal, 5), new SqlParameter("@BASE_TO_OTHER", SqlDbType.Decimal, 13), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9) }; parameters[0].Value = 0; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Direction = ParameterDirection.InputOutput; parameters[2].Value = data0001.RKEY; parameters[3].Value = data0001.CURR_CODE; parameters[4].Value = data0001.CURR_NAME; parameters[5].Value = data0001.EXCH_RATE; if (data0001.TDATE == DateTime.Parse("1900-1-1") || data0001.TDATE == DateTime.Parse("0001-1-1")) { parameters[6].Value = null; } else { parameters[6].Value = data0001.TDATE; } parameters[7].Value = data0001.TREADONLY; parameters[8].Value = data0001.BASE_TO_OTHER; parameters[9].Value = data0001.ACTIVE_FLAG; #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); data0001.RKEY = decimal.Parse(parameters[2].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";DATA0001,save successful"); } catch (Exception e) { ///message ID result = 2; log.Error("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }