/// <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);
}
