/// <summary>
/// 新增员工变动
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddEmpChange(EmpChange model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OA_EmpChange(");
strSql.Append("EmpChangeID,EmpID,ChangeDate,ChangeType,OldPostID,NewPostID,ChangeReason,DeptManagerID,DeptView,HRManagerID,HRView,ManagerID,MView,State,CreatorID,CreateTime)");
strSql.Append(" values (");
strSql.Append("@EmpChangeID,@EmpID,@ChangeDate,@ChangeType,@OldPostID,@NewPostID,@ChangeReason,@DeptManagerID,@DeptView,@HRManagerID,@HRView,@ManagerID,@MView,@State,@CreatorID,@CreateTime)");
SqlParameter[] parameters =
{
new SqlParameter("@EmpChangeID", SqlDbType.VarChar, 36),
new SqlParameter("@EmpID", SqlDbType.VarChar, 36),
new SqlParameter("@ChangeDate", SqlDbType.Char, 8),
new SqlParameter("@ChangeType", SqlDbType.Char, 1),
new SqlParameter("@OldPostID", SqlDbType.VarChar, 36),
new SqlParameter("@NewPostID", SqlDbType.VarChar, 36),
new SqlParameter("@ChangeReason", SqlDbType.NVarChar, 200),
new SqlParameter("@DeptManagerID", SqlDbType.VarChar, 36),
new SqlParameter("@DeptView", SqlDbType.NVarChar, 200),
new SqlParameter("@HRManagerID", SqlDbType.VarChar, 36),
new SqlParameter("@HRView", SqlDbType.NVarChar, 200),
new SqlParameter("@ManagerID", SqlDbType.VarChar, 36),
new SqlParameter("@MView", SqlDbType.NVarChar, 200),
new SqlParameter("@State", SqlDbType.Char, 1),
new SqlParameter("@CreatorID", SqlDbType.VarChar, 36),
new SqlParameter("@CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.EmpChangeID;
parameters[1].Value = model.EmpID;
parameters[2].Value = model.ChangeDate;
parameters[3].Value = model.ChangeType;
parameters[4].Value = model.OldPostID;
parameters[5].Value = model.NewPostID;
parameters[6].Value = model.ChangeReason;
parameters[7].Value = model.DeptManagerID;
parameters[8].Value = model.DeptView;
parameters[9].Value = model.HRManagerID;
parameters[10].Value = model.HRView;
parameters[11].Value = model.ManagerID;
parameters[12].Value = model.MView;
parameters[13].Value = model.State;
parameters[14].Value = model.CreatorID;
parameters[15].Value = model.CreateTime;
return(DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters));
}
/// <summary>
/// 新增员工变动
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddEmpChange(EmpChange model)
{
return(iEmpChangeDAL.AddEmpChange(model));
}
/// <summary>
/// 获取模型
/// </summary>
/// <param name="EmpChangeID"></param>
/// <returns></returns>
public EmpChange GetModel(string EmpChangeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 EmpChangeID,EmpID,ChangeDate,ChangeType,OldPostID,NewPostID,ChangeReason,DeptManagerID,DeptView,HRManagerID,HRView,ManagerID,MView,State,CreatorID,CreateTime from OA_EmpChange ");
strSql.Append(" where EmpChangeID=@EmpChangeID ");
SqlParameter[] parameters =
{
new SqlParameter("@EmpChangeID", SqlDbType.VarChar, 36)
};
parameters[0].Value = EmpChangeID;
EmpChange model = new EmpChange();
DataSet ds = DBAccess.ExecuteDataset(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["EmpChangeID"] != null && ds.Tables[0].Rows[0]["EmpChangeID"].ToString() != "")
{
model.EmpChangeID = ds.Tables[0].Rows[0]["EmpChangeID"].ToString();
}
if (ds.Tables[0].Rows[0]["EmpID"] != null && ds.Tables[0].Rows[0]["EmpID"].ToString() != "")
{
model.EmpID = ds.Tables[0].Rows[0]["EmpID"].ToString();
}
if (ds.Tables[0].Rows[0]["ChangeDate"] != null && ds.Tables[0].Rows[0]["ChangeDate"].ToString() != "")
{
model.ChangeDate = ds.Tables[0].Rows[0]["ChangeDate"].ToString();
}
if (ds.Tables[0].Rows[0]["ChangeType"] != null && ds.Tables[0].Rows[0]["ChangeType"].ToString() != "")
{
model.ChangeType = ds.Tables[0].Rows[0]["ChangeType"].ToString();
}
if (ds.Tables[0].Rows[0]["OldPostID"] != null && ds.Tables[0].Rows[0]["OldPostID"].ToString() != "")
{
model.OldPostID = ds.Tables[0].Rows[0]["OldPostID"].ToString();
}
if (ds.Tables[0].Rows[0]["NewPostID"] != null && ds.Tables[0].Rows[0]["NewPostID"].ToString() != "")
{
model.NewPostID = ds.Tables[0].Rows[0]["NewPostID"].ToString();
}
if (ds.Tables[0].Rows[0]["ChangeReason"] != null && ds.Tables[0].Rows[0]["ChangeReason"].ToString() != "")
{
model.ChangeReason = ds.Tables[0].Rows[0]["ChangeReason"].ToString();
}
if (ds.Tables[0].Rows[0]["DeptManagerID"] != null && ds.Tables[0].Rows[0]["DeptManagerID"].ToString() != "")
{
model.DeptManagerID = ds.Tables[0].Rows[0]["DeptManagerID"].ToString();
}
if (ds.Tables[0].Rows[0]["DeptView"] != null && ds.Tables[0].Rows[0]["DeptView"].ToString() != "")
{
model.DeptView = ds.Tables[0].Rows[0]["DeptView"].ToString();
}
if (ds.Tables[0].Rows[0]["HRManagerID"] != null && ds.Tables[0].Rows[0]["HRManagerID"].ToString() != "")
{
model.HRManagerID = ds.Tables[0].Rows[0]["HRManagerID"].ToString();
}
if (ds.Tables[0].Rows[0]["HRView"] != null && ds.Tables[0].Rows[0]["HRView"].ToString() != "")
{
model.HRView = ds.Tables[0].Rows[0]["HRView"].ToString();
}
if (ds.Tables[0].Rows[0]["ManagerID"] != null && ds.Tables[0].Rows[0]["ManagerID"].ToString() != "")
{
model.ManagerID = ds.Tables[0].Rows[0]["ManagerID"].ToString();
}
if (ds.Tables[0].Rows[0]["MView"] != null && ds.Tables[0].Rows[0]["MView"].ToString() != "")
{
model.MView = ds.Tables[0].Rows[0]["MView"].ToString();
}
if (ds.Tables[0].Rows[0]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = ds.Tables[0].Rows[0]["State"].ToString();
}
if (ds.Tables[0].Rows[0]["CreatorID"] != null && ds.Tables[0].Rows[0]["CreatorID"].ToString() != "")
{
model.CreatorID = ds.Tables[0].Rows[0]["CreatorID"].ToString();
}
if (ds.Tables[0].Rows[0]["CreateTime"] != null && ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
