private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex >= 0)
{
Data0005 = data0005List[e.RowIndex];
this.DialogResult = DialogResult.OK;
}
}
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0005 data0005)
{
// Validate input
if (data0005 == null)
{
return(0);
}
return(data0005Dal.Add(cmd, conn, trans, data0005));
}
public int Delete(DATA0005 data0005)
{
// Validate input
if (data0005 == null)
{
return(0);
}
return(data0005Dal.Delete(data0005));
}
/// <summary>
/// 向数据库中插入一条新记录。
/// </summary>
/// <param name="DATA0005">data0005对象</param>
/// <returns>新插入记录的编号</returns>
public int Add(DATA0005 data0005)
{
// Validate input
if (data0005 == null)
{
return(0);
}
return(data0005Dal.Add(data0005));
}
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0005 data0005)
{
// Validate input
if (data0005 == null)
{
return;
}
data0005Dal.Update(cmd, conn, trans, data0005);
}
///<sumary>
/// 删除
///</sumary>
/// <param name="data0005">对象</param>
///<returns>返回INT类型号, 0为操作成功, 非0操作失败.</returns>
public int Delete(DATA0005 data0005)
{
#region 调用SQL存储过程进行删除
string sql = "sp_DATA0005_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 = data0005.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 + ";DATA0005,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="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);
}
///<sumary>
/// 通过SQL语句获取数据对象
///</sumary>
/// <param name="sqlWhere">sqlWhere参数条件</param>
///<returns>IList<DATA0005>数据集合</returns>
public IList <DATA0005> FindBySql(string sqlWhere)
{
#region SQL
string sql = @"select
isNull(rkey,0) as rkey
,
isNull(empl_code,'') as empl_code
,
isNull(employee_name,'') as employee_name
,
isNull(abbr_name,'') as abbr_name
,
isNull(employee_id,'') as employee_id
,
isNull(address_line_1,'') as address_line_1
,
isNull(address_line_2,'') as address_line_2
,
isNull(address_line_3,'') as address_line_3
,
isNull(state,'') as state
,
isNull(zip,'') as zip
,
isNull(phone,'') as phone
,
isNull(note_pad_pointer,0) as note_pad_pointer
,
isNull(pay_rate_1,0) as pay_rate_1
,
isNull(pay_rate_2,0) as pay_rate_2
,
isNull(pay_rate_3,0) as pay_rate_3
,
isNull(start_time_1,0) as start_time_1
,
isNull(start_time_2,0) as start_time_2
,
isNull(start_time_3,0) as start_time_3
,
isNull(active_flag,'') as active_flag
,
isNull(buyer_flag,'') as buyer_flag
,
isNull(inactive_date,'1900-1-1') as inactive_date
,
isNull(tpostion,'') as tpostion
,
isNull(email,'') as email
,
isNull(empl_password,0) as empl_password
from DATA0005 with (nolock)" ;
if (sqlWhere.Length > 0)
{
sql = sql + " where " + sqlWhere;
}
#endregion
IList <DATA0005> resultList = new List <DATA0005>();
#region 操作
try
{
using (DataTable tb = dbHelper.GetDataSet(sql))
{
foreach (DataRow row in tb.Rows)
{
DATA0005 data0005 = new DATA0005();
data0005.RKEY = decimal.Parse(row["RKEY"].ToString());
data0005.EMPL_CODE = row["EMPL_CODE"].ToString();
data0005.EMPLOYEE_NAME = row["EMPLOYEE_NAME"].ToString();
data0005.ABBR_NAME = row["ABBR_NAME"].ToString();
data0005.EMPLOYEE_ID = row["EMPLOYEE_ID"].ToString();
data0005.ADDRESS_LINE_1 = row["ADDRESS_LINE_1"].ToString();
data0005.ADDRESS_LINE_2 = row["ADDRESS_LINE_2"].ToString();
data0005.ADDRESS_LINE_3 = row["ADDRESS_LINE_3"].ToString();
data0005.STATE = row["STATE"].ToString();
data0005.ZIP = row["ZIP"].ToString();
data0005.PHONE = row["PHONE"].ToString();
data0005.NOTE_PAD_POINTER = decimal.Parse(row["NOTE_PAD_POINTER"].ToString());
data0005.PAY_RATE_1 = decimal.Parse(row["PAY_RATE_1"].ToString());
data0005.PAY_RATE_2 = decimal.Parse(row["PAY_RATE_2"].ToString());
data0005.PAY_RATE_3 = decimal.Parse(row["PAY_RATE_3"].ToString());
data0005.START_TIME_1 = decimal.Parse(row["START_TIME_1"].ToString());
data0005.START_TIME_2 = decimal.Parse(row["START_TIME_2"].ToString());
data0005.START_TIME_3 = decimal.Parse(row["START_TIME_3"].ToString());
data0005.ACTIVE_FLAG = row["ACTIVE_FLAG"].ToString();
data0005.BUYER_FLAG = row["BUYER_FLAG"].ToString();
data0005.INACTIVE_DATE = DateTime.Parse(row["INACTIVE_DATE"].ToString());
data0005.TPOSTION = row["TPOSTION"].ToString();
data0005.EMAIL = row["EMAIL"].ToString();
data0005.EMPL_PASSWORD = (Byte[])(row["EMPL_PASSWORD"]);
resultList.Add(data0005);
}
}
}
catch (Exception e)
{
log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";FindBySql function:" + e.Message, e);
throw e;
}
#endregion
return(resultList);
}
///<sumary>
/// 通过主键获取数据对象
///</sumary>
/// <param name="RKEY">rkey</param>
///<returns>DATA0005对象</returns>
public DATA0005 getDATA0005ByRKEY(decimal rkey)
{
#region SQL
string sql = @"select top 1
isNull(rkey,0) as rkey
,
isNull(empl_code,'') as empl_code
,
isNull(employee_name,'') as employee_name
,
isNull(abbr_name,'') as abbr_name
,
isNull(employee_id,'') as employee_id
,
isNull(address_line_1,'') as address_line_1
,
isNull(address_line_2,'') as address_line_2
,
isNull(address_line_3,'') as address_line_3
,
isNull(state,'') as state
,
isNull(zip,'') as zip
,
isNull(phone,'') as phone
,
isNull(note_pad_pointer,0) as note_pad_pointer
,
isNull(pay_rate_1,0) as pay_rate_1
,
isNull(pay_rate_2,0) as pay_rate_2
,
isNull(pay_rate_3,0) as pay_rate_3
,
isNull(start_time_1,0) as start_time_1
,
isNull(start_time_2,0) as start_time_2
,
isNull(start_time_3,0) as start_time_3
,
isNull(active_flag,'') as active_flag
,
isNull(buyer_flag,'') as buyer_flag
,
isNull(inactive_date,'1900-1-1') as inactive_date
,
isNull(tpostion,'') as tpostion
,
isNull(email,'') as email
,
isNull(empl_password,0) as empl_password
from DATA0005 with (nolock) where RKEY='{0}'" ;
#endregion
///定义返回对象
DATA0005 data0005 = null;
#region 数据库操作
try
{
data0005 = new DATA0005();
using (DataTable tb = dbHelper.GetDataSet(string.Format(sql, rkey)))
{
foreach (DataRow row in tb.Rows)
{
data0005.RKEY = decimal.Parse(row["RKEY"].ToString());
data0005.EMPL_CODE = row["EMPL_CODE"].ToString();
data0005.EMPLOYEE_NAME = row["EMPLOYEE_NAME"].ToString();
data0005.ABBR_NAME = row["ABBR_NAME"].ToString();
data0005.EMPLOYEE_ID = row["EMPLOYEE_ID"].ToString();
data0005.ADDRESS_LINE_1 = row["ADDRESS_LINE_1"].ToString();
data0005.ADDRESS_LINE_2 = row["ADDRESS_LINE_2"].ToString();
data0005.ADDRESS_LINE_3 = row["ADDRESS_LINE_3"].ToString();
data0005.STATE = row["STATE"].ToString();
data0005.ZIP = row["ZIP"].ToString();
data0005.PHONE = row["PHONE"].ToString();
data0005.NOTE_PAD_POINTER = decimal.Parse(row["NOTE_PAD_POINTER"].ToString());
data0005.PAY_RATE_1 = decimal.Parse(row["PAY_RATE_1"].ToString());
data0005.PAY_RATE_2 = decimal.Parse(row["PAY_RATE_2"].ToString());
data0005.PAY_RATE_3 = decimal.Parse(row["PAY_RATE_3"].ToString());
data0005.START_TIME_1 = decimal.Parse(row["START_TIME_1"].ToString());
data0005.START_TIME_2 = decimal.Parse(row["START_TIME_2"].ToString());
data0005.START_TIME_3 = decimal.Parse(row["START_TIME_3"].ToString());
data0005.ACTIVE_FLAG = row["ACTIVE_FLAG"].ToString();
data0005.BUYER_FLAG = row["BUYER_FLAG"].ToString();
data0005.INACTIVE_DATE = DateTime.Parse(row["INACTIVE_DATE"].ToString());
data0005.TPOSTION = row["TPOSTION"].ToString();
data0005.EMAIL = row["EMAIL"].ToString();
data0005.EMPL_PASSWORD = (Byte[])(row["EMPL_PASSWORD"]);
}
}
}
catch (Exception e)
{
//Console.WriteLine(e.Message);
log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";get function:" + e.Message, e);
}
#endregion
return(data0005);
}
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0005 data0005)
{
#region 创建语法
StringBuilder strSql = new StringBuilder();
strSql.Append("update DATA0005 set ");
strSql.Append("EMPL_CODE=@EMPL_CODE,");
strSql.Append("EMPLOYEE_NAME=@EMPLOYEE_NAME,");
strSql.Append("ABBR_NAME=@ABBR_NAME,");
strSql.Append("EMPLOYEE_ID=@EMPLOYEE_ID,");
strSql.Append("ADDRESS_LINE_1=@ADDRESS_LINE_1,");
strSql.Append("ADDRESS_LINE_2=@ADDRESS_LINE_2,");
strSql.Append("ADDRESS_LINE_3=@ADDRESS_LINE_3,");
strSql.Append("STATE=@STATE,");
strSql.Append("ZIP=@ZIP,");
strSql.Append("PHONE=@PHONE,");
strSql.Append("NOTE_PAD_POINTER=@NOTE_PAD_POINTER,");
strSql.Append("PAY_RATE_1=@PAY_RATE_1,");
strSql.Append("PAY_RATE_2=@PAY_RATE_2,");
strSql.Append("PAY_RATE_3=@PAY_RATE_3,");
strSql.Append("START_TIME_1=@START_TIME_1,");
strSql.Append("START_TIME_2=@START_TIME_2,");
strSql.Append("START_TIME_3=@START_TIME_3,");
strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG,");
strSql.Append("BUYER_FLAG=@BUYER_FLAG,");
strSql.Append("INACTIVE_DATE=@INACTIVE_DATE,");
strSql.Append("TPOSTION=@TPOSTION,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("EMPL_PASSWORD=@EMPL_PASSWORD");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Decimal, 9),
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 = data0005.RKEY;
parameters[1].Value = data0005.EMPL_CODE;
parameters[2].Value = data0005.EMPLOYEE_NAME;
parameters[3].Value = data0005.ABBR_NAME;
parameters[4].Value = data0005.EMPLOYEE_ID;
parameters[5].Value = data0005.ADDRESS_LINE_1;
parameters[6].Value = data0005.ADDRESS_LINE_2;
parameters[7].Value = data0005.ADDRESS_LINE_3;
parameters[8].Value = data0005.STATE;
parameters[9].Value = data0005.ZIP;
parameters[10].Value = data0005.PHONE;
parameters[11].Value = data0005.NOTE_PAD_POINTER;
parameters[12].Value = data0005.PAY_RATE_1;
parameters[13].Value = data0005.PAY_RATE_2;
parameters[14].Value = data0005.PAY_RATE_3;
parameters[15].Value = data0005.START_TIME_1;
parameters[16].Value = data0005.START_TIME_2;
parameters[17].Value = data0005.START_TIME_3;
parameters[18].Value = data0005.ACTIVE_FLAG;
parameters[19].Value = data0005.BUYER_FLAG;
if (data0005.INACTIVE_DATE == DateTime.Parse("1900-1-1") || data0005.INACTIVE_DATE == DateTime.Parse("0001-1-1"))
{
parameters[20].Value = null;
}
else
{
parameters[20].Value = data0005.INACTIVE_DATE;
}
parameters[21].Value = data0005.TPOSTION;
parameters[22].Value = data0005.EMAIL;
parameters[23].Value = data0005.EMPL_PASSWORD;
#endregion
#region 操作
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandText = strSql.ToString();
cmd.Transaction = trans;
cmd.CommandType = CommandType.Text;//cmdType;
if (parameters != null)
{
foreach (SqlParameter parameter in parameters)
{
if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) &&
(parameter.Value == null))
{
parameter.Value = DBNull.Value;
}
cmd.Parameters.Add(parameter);
}
}
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
#endregion
}
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0005 data0005)
{
#region 创建SQL语法
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DATA0005(");
strSql.Append("EMPL_CODE,EMPLOYEE_NAME,ABBR_NAME,EMPLOYEE_ID,ADDRESS_LINE_1,ADDRESS_LINE_2,ADDRESS_LINE_3,STATE,ZIP,PHONE,NOTE_PAD_POINTER,PAY_RATE_1,PAY_RATE_2,PAY_RATE_3,START_TIME_1,START_TIME_2,START_TIME_3,ACTIVE_FLAG,BUYER_FLAG,INACTIVE_DATE,TPOSTION,EMAIL,EMPL_PASSWORD");
strSql.Append(" ) values (");
strSql.Append("@EMPL_CODE,@EMPLOYEE_NAME,@ABBR_NAME,@EMPLOYEE_ID,@ADDRESS_LINE_1,@ADDRESS_LINE_2,@ADDRESS_LINE_3,@STATE,@ZIP,@PHONE,@NOTE_PAD_POINTER,@PAY_RATE_1,@PAY_RATE_2,@PAY_RATE_3,@START_TIME_1,@START_TIME_2,@START_TIME_3,@ACTIVE_FLAG,@BUYER_FLAG,@INACTIVE_DATE,@TPOSTION,@EMAIL,@EMPL_PASSWORD");
strSql.Append(");select @@IDENTITY");
SqlParameter[] parameters =
{
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 = data0005.EMPL_CODE;
parameters[1].Value = data0005.EMPLOYEE_NAME;
parameters[2].Value = data0005.ABBR_NAME;
parameters[3].Value = data0005.EMPLOYEE_ID;
parameters[4].Value = data0005.ADDRESS_LINE_1;
parameters[5].Value = data0005.ADDRESS_LINE_2;
parameters[6].Value = data0005.ADDRESS_LINE_3;
parameters[7].Value = data0005.STATE;
parameters[8].Value = data0005.ZIP;
parameters[9].Value = data0005.PHONE;
parameters[10].Value = data0005.NOTE_PAD_POINTER;
parameters[11].Value = data0005.PAY_RATE_1;
parameters[12].Value = data0005.PAY_RATE_2;
parameters[13].Value = data0005.PAY_RATE_3;
parameters[14].Value = data0005.START_TIME_1;
parameters[15].Value = data0005.START_TIME_2;
parameters[16].Value = data0005.START_TIME_3;
parameters[17].Value = data0005.ACTIVE_FLAG;
parameters[18].Value = data0005.BUYER_FLAG;
if (data0005.INACTIVE_DATE == DateTime.Parse("1900-1-1") || data0005.INACTIVE_DATE == DateTime.Parse("0001-1-1"))
{
parameters[19].Value = null;
}
else
{
parameters[19].Value = data0005.INACTIVE_DATE;
}
parameters[20].Value = data0005.TPOSTION;
parameters[21].Value = data0005.EMAIL;
parameters[22].Value = data0005.EMPL_PASSWORD;
#endregion
#region 操作
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.Connection = conn;
cmd.CommandText = strSql.ToString();
cmd.Transaction = trans;
cmd.CommandType = CommandType.Text;//cmdType;
if (parameters != null)
{
foreach (SqlParameter parameter in parameters)
{
if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) &&
(parameter.Value == null))
{
parameter.Value = DBNull.Value;
}
cmd.Parameters.Add(parameter);
}
}
int indentity = 0;
object obj = cmd.ExecuteScalar();
cmd.Parameters.Clear();
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
indentity = 0;
}
else
{
indentity = int.Parse(obj.ToString());
}
#endregion
return(indentity);
}
