public ActionResult AddEmployeeInfoNew()
{
EditEmployeeInfoModel model = new EditEmployeeInfoModel();
// 证件类型
model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName");
// 默认选中驾驶员
model.IsDriver = true;
return(PartialView("_AddEmployeeInfoNew", model));
}
public ActionResult AddEmployeeInfoNew(EditEmployeeInfoModel model)
{
if (ModelState.IsValid)
{
var result = EmployeeInfoBLL.AddEmployeeInfoNew(model, base.CurrentUserID);
base.DoLog(OperationTypeEnum.Add, result, "EmployeeName:" + model.EmployeeName);
return(Json(result));
}
else
{
// 证件类型
model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName");
return(PartialView("_AddEmployeeInfoNew", model));
}
}
public ActionResult EditEmployeeInfoNew(EditEmployeeInfoModel model)
{
// 获取当前员工已经被哪些车使用过 如果对应的员工类型已经关联了相关的车辆 则不能取消绑定
List <VehicleEmployeeInfoDDLModel> list = EmployeeInfoBLL.GetEmployeeInfoUsedToVehicle(model.ID);
if (list != null && list.Count > 0)
{
if (!model.IsDriver)
{
if (list.Find(o => o.Type == 1) != null)
{
ModelState.AddModelError("DriveCode", DataAnnotations.DriverError);
}
}
if (!model.IsCarrier && ModelState.IsValid)
{
if (list.Find(o => o.Type == 2) != null)
{
ModelState.AddModelError("DriveCode", DataAnnotations.CarrierError);
}
}
}
if (ModelState.IsValid)
{
var result = EmployeeInfoBLL.EditEmployeeInfoNew(model, base.CurrentUserID);
base.DoLog(OperationTypeEnum.Edit, result, "ID:" + model.ID);
return(Json(result));
}
else
{
// 证件类型
model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName");
return(PartialView("_EditEmployeeInfoNew", model));
}
}
/// <summary>
/// 获取员工信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static SelectResult <EditEmployeeInfoModel> GetNewEmployeeInfoByID(int id)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ID", SqlDbType.Int),
};
paras[0].Value = id;
string sql = @"SELECT a.ID,EmployeeName,EmployeeGender,ContactPhone,ContactAddress ,CertificateTypeID,CertificateCode
,IsDriver,DriveCode,IsCarrier ,EmergePhone,CarrierCode ,StrucID ,b.StrucName ,a.Remark,
CAST(DriveCodeValidTime AS CHAR(10)) AS DriveCodeValidTime,CAST(CarrieCodeValidTime AS CHAR(10)) AS
CarrieCodeValidTime,a.IsOwners FROM dbo.EmployeeInfo
AS a LEFT JOIN dbo.Structures AS b ON a.StrucID = b.ID WHERE a.ID=@ID";
List <EditEmployeeInfoModel> list = ConvertToList <EditEmployeeInfoModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
EditEmployeeInfoModel data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
}
return(new SelectResult <EditEmployeeInfoModel>()
{
DataResult = data,
Message = msg
});
}
public static OperationResult AddEmployeeInfoNew(EditEmployeeInfoModel model, int currentUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@EmployeeName", SqlDbType.NVarChar, 50),
new SqlParameter("@EmployeeGender", SqlDbType.Bit),
new SqlParameter("@CertificateTypeID", SqlDbType.Int),
new SqlParameter("@CertificateCode", SqlDbType.NVarChar, 20),
new SqlParameter("@ContactPhone", SqlDbType.NVarChar, 20),
new SqlParameter("@ContactAddress", SqlDbType.NVarChar, 200),
new SqlParameter("@IsDriver", SqlDbType.Bit),
new SqlParameter("@DriveCode", SqlDbType.NVarChar, 20),
new SqlParameter("@IsCarrier", SqlDbType.Bit),
new SqlParameter("@EmergePhone", SqlDbType.NVarChar, 20),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@CreateUser", SqlDbType.Int),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@DriveCodeValidTime", SqlDbType.Date),
new SqlParameter("@CarrieCodeValidTime", SqlDbType.Date),
new SqlParameter("@CarrierCode", SqlDbType.NVarChar, 20),
new SqlParameter("@StrucID", SqlDbType.Int),
new SqlParameter("@IsOwners", SqlDbType.Bit),
};
paras[0].Value = model.EmployeeName.Trim();
paras[1].Value = model.EmployeeGender;
paras[2].Value = model.CertificateTypeID;
if (string.IsNullOrWhiteSpace(model.CertificateCode))
{
paras[3].Value = DBNull.Value;
}
else
{
paras[3].Value = model.CertificateCode.Trim();
}
paras[4].Value = model.ContactPhone;
if (string.IsNullOrWhiteSpace(model.ContactAddress))
{
paras[5].Value = DBNull.Value;
}
else
{
paras[5].Value = model.ContactAddress.Trim();
}
paras[6].Value = model.IsDriver;
if (string.IsNullOrEmpty(model.DriveCode))
{
paras[7].Value = DBNull.Value;
}
else
{
paras[7].Value = model.DriveCode.Trim();
}
paras[8].Value = model.IsCarrier;
if (string.IsNullOrEmpty(model.EmergePhone))
{
paras[9].Value = DBNull.Value;
}
else
{
paras[9].Value = model.EmergePhone.Trim();
}
if (string.IsNullOrWhiteSpace(model.Remark))
{
paras[10].Value = DBNull.Value;
}
else
{
paras[10].Value = model.Remark;
}
paras[11].Value = 0;
paras[12].Value = currentUserID;
paras[13].Value = DateTime.Now;
if (string.IsNullOrEmpty(model.DriveCodeValidTime))
{
paras[14].Value = DBNull.Value;
}
else
{
paras[14].Value = model.DriveCodeValidTime;
}
if (string.IsNullOrEmpty(model.CarrieCodeValidTime))
{
paras[15].Value = DBNull.Value;
}
else
{
paras[15].Value = model.CarrieCodeValidTime;
}
if (string.IsNullOrEmpty(model.CarrierCode))
{
paras[16].Value = DBNull.Value;
}
else
{
paras[16].Value = model.CarrierCode.Trim();
}
paras[17].Value = model.StrucID;
paras[18].Value = model.IsOwners;
#region SQL
string sql = @"INSERT INTO dbo.EmployeeInfo
(EmployeeName ,EmployeeGender , ContactPhone ,ContactAddress ,CertificateTypeID ,CertificateCode ,
IsDriver ,DriveCode ,IsCarrier ,EmergePhone ,Remark ,Status ,CreateUser ,CreateTime ,
DriveCodeValidTime ,CarrieCodeValidTime,CarrierCode ,StrucID,IsOwners
)
VALUES (
@EmployeeName , -- EmployeeName - nvarchar(50)
@EmployeeGender , -- EmployeeGender - bit
@ContactPhone , -- ContactPhone - nvarchar(20)
@ContactAddress , -- ContactAddress - nvarchar(200)
@CertificateTypeID , -- CertificateTypeID - int
@CertificateCode , -- CertificateCode - nvarchar(20)
@IsDriver , -- IsDriver - bit
@DriveCode , -- DriveCode - nvarchar(20)
@IsCarrier , -- IsCarrier - bit
@EmergePhone , -- EmergePhone - nvarchar(20)
@Remark , -- Remark - nvarchar(500)
@Status , -- Status - int
@CreateUser , -- CreateUser - int
@CreateTime , -- CreateTime - datetime
@DriveCodeValidTime,
@CarrieCodeValidTime,
@CarrierCode ,
@StrucID,
@IsOwners
)";
#endregion
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
/// <summary>
/// 员工信息修改
/// </summary>
/// <param name="model"></param>
/// <param name="currentUserID"></param>
/// <returns></returns>
public static OperationResult EditEmployeeInfoNew(EditEmployeeInfoModel model, int currentUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@EmployeeName", SqlDbType.NVarChar, 50),
new SqlParameter("@EmployeeGender", SqlDbType.Bit),
new SqlParameter("@CertificateTypeID", SqlDbType.Int),
new SqlParameter("@CertificateCode", SqlDbType.NVarChar, 20),
new SqlParameter("@ContactPhone", SqlDbType.NVarChar, 20),
new SqlParameter("@ContactAddress", SqlDbType.NVarChar, 200),
new SqlParameter("@IsDriver", SqlDbType.Bit),
new SqlParameter("@DriveCode", SqlDbType.NVarChar, 20),
new SqlParameter("@IsCarrier", SqlDbType.Bit),
new SqlParameter("@EmergePhone", SqlDbType.NVarChar, 20),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@DriveCodeValidTime", SqlDbType.Date),
new SqlParameter("@CarrieCodeValidTime", SqlDbType.Date),
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@UpdateUser", SqlDbType.Int),
new SqlParameter("@CarrierCode", SqlDbType.NVarChar, 20),
new SqlParameter("@StrucID", SqlDbType.Int),
new SqlParameter("@IsOwners", SqlDbType.Bit),
};
paras[0].Value = model.EmployeeName.Trim();
paras[1].Value = model.EmployeeGender;
paras[2].Value = model.CertificateTypeID;
if (string.IsNullOrEmpty(model.CertificateCode))
{
paras[3].Value = DBNull.Value;
}
else
{
paras[3].Value = model.CertificateCode.Trim();
}
paras[4].Value = model.ContactPhone;
if (string.IsNullOrEmpty(model.ContactAddress))
{
paras[5].Value = DBNull.Value;
}
else
{
paras[5].Value = model.ContactAddress.Trim();
}
paras[6].Value = model.IsDriver;
if (string.IsNullOrEmpty(model.DriveCode))
{
paras[7].Value = DBNull.Value;
}
else
{
paras[7].Value = model.DriveCode.Trim();
}
paras[8].Value = model.IsCarrier;
if (string.IsNullOrEmpty(model.EmergePhone))
{
paras[9].Value = DBNull.Value;
}
else
{
paras[9].Value = model.EmergePhone.Trim();
}
if (string.IsNullOrWhiteSpace(model.Remark))
{
paras[10].Value = DBNull.Value;
}
else
{
paras[10].Value = model.Remark;
}
if (string.IsNullOrWhiteSpace(model.DriveCodeValidTime))
{
paras[11].Value = DBNull.Value;
}
else
{
paras[11].Value = model.DriveCodeValidTime;
}
if (string.IsNullOrWhiteSpace(model.CarrieCodeValidTime))
{
paras[12].Value = DBNull.Value;
}
else
{
paras[12].Value = model.CarrieCodeValidTime;
}
paras[13].Value = model.ID;
paras[14].Value = currentUserID;
if (string.IsNullOrWhiteSpace(model.CarrierCode))
{
paras[15].Value = DBNull.Value;
}
else
{
paras[15].Value = model.CarrierCode.Trim();
}
paras[16].Value = model.StrucID;
paras[17].Value = model.IsOwners;
#region SQL
// 更新员工信息的时候需要注意 如果打开编辑页面的时候该员工还未被车辆使用，此时界面上是可以修改隶属单位的，但是当点击保存的时候
// 用户在这之前刚好把这个员工关联了车辆 那么此时隶属单位就不应该被修改 为了防止类似事情发生，故where条件中在做限制
// 上述的限制仅仅是在更换了隶属单位的时候才需要添加 如果隶属单位未做修改 无需添加此限制
string sql = @"UPDATE dbo.EmployeeInfo SET EmployeeName = @EmployeeName ,EmployeeGender = @EmployeeGender ,
ContactPhone = @ContactPhone ,ContactAddress = @ContactAddress ,CertificateTypeID = @CertificateTypeID ,
CertificateCode = @CertificateCode ,IsDriver = @IsDriver ,DriveCode = @DriveCode ,IsCarrier = @IsCarrier ,
EmergePhone = @EmergePhone ,Remark = @Remark ,UpdateUser = @UpdateUser ,UpdateTime = GetDate() ,
DriveCodeValidTime = @DriveCodeValidTime ,CarrieCodeValidTime = @CarrieCodeValidTime,
CarrierCode = @CarrierCode ,StrucID = @StrucID,IsOwners = @IsOwners WHERE ID = @ID ";
if (model.OldStrucID != model.StrucID)
{
sql += "AND NOT EXISTS(SELECT EmployeeInfoID FROM VehicleEmployeeInfo WHERE EmployeeInfoID=@ID)";
}
#endregion
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}
