public ActionResult AddEmployeeInfo()
{
EmployeeInfoAddModel model = new EmployeeInfoAddModel();
model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName");
SelectList driveLicenseStateSelectList = new SelectList(EmployeeInfoBLL.GetDriveLicenseStates(), "DriveLicenseStateID", "DriveLicenseStateName");
List <SelectListItem> liDriveLicenseState = new List <SelectListItem>();
liDriveLicenseState.Add(new SelectListItem {
Text = DisplayText.PleaseSelect, Value = "0", Selected = true
});
liDriveLicenseState.AddRange(driveLicenseStateSelectList);
model.DriveLicenseStateSelectList = liDriveLicenseState;
SelectList driveTypeSelectList = new SelectList(EmployeeInfoBLL.GetDriveTypes(), "DriveTypeID", "DriveTypeName");
List <SelectListItem> liDriveType = new List <SelectListItem>();
liDriveType.Add(new SelectListItem {
Text = DisplayText.PleaseSelect, Value = "0", Selected = true
});
liDriveType.AddRange(driveTypeSelectList);
model.DriveTypeSelectList = liDriveType;
return(PartialView("_AddEmployeeInfo", model));
}
public static OperationResult AddEmployeeInfo(EmployeeInfoAddModel model, int currentUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@EmployeeID", SqlDbType.NVarChar, 20),
new SqlParameter("@EmployeeName", SqlDbType.NVarChar, 50),
new SqlParameter("@EmployeeGender", SqlDbType.Bit),
new SqlParameter("@CertificateTypeID", SqlDbType.Int),
new SqlParameter("@CertificateCode", SqlDbType.NVarChar, 20),
new SqlParameter("@BirthDate", SqlDbType.Date),
new SqlParameter("@CertificateOffice", SqlDbType.NVarChar, 50),
new SqlParameter("@ValidStartTime", SqlDbType.Date),
new SqlParameter("@ValidEndTime", SqlDbType.Date),
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("@DriveTypeID", SqlDbType.NVarChar, 20),
new SqlParameter("@IsCarrier", SqlDbType.Bit),
new SqlParameter("@EmergePhone", SqlDbType.NVarChar, 20),
new SqlParameter("@DriveLicenseStateID", SqlDbType.Int),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@CreateUser", SqlDbType.Int),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@UpdateUser", SqlDbType.Int),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@DriveCodeValidTime", SqlDbType.Date),
new SqlParameter("@CarrierCode", SqlDbType.NVarChar, 20),
new SqlParameter("@StrucID", SqlDbType.Int),
};
paras[0].Value = model.EmployeeID;
paras[1].Value = model.EmployeeName.Trim();
paras[2].Value = model.EmployeeGender;
paras[3].Value = model.CertificateTypeID;
paras[4].Value = model.CertificateCode;
if (string.IsNullOrEmpty(model.BirthDate))
{
paras[5].Value = DBNull.Value;
}
else
{
paras[5].Value = model.BirthDate;
}
if (string.IsNullOrEmpty(model.CertificateOffice))
{
paras[6].Value = DBNull.Value;
}
else
{
paras[6].Value = model.CertificateOffice.Trim();
}
if (string.IsNullOrEmpty(model.ValidStartTime))
{
paras[7].Value = DBNull.Value;
}
else
{
paras[7].Value = model.ValidStartTime;
}
if (string.IsNullOrEmpty(model.ValidEndTime))
{
paras[8].Value = DBNull.Value;
}
else
{
paras[8].Value = model.ValidEndTime;
}
paras[9].Value = model.ContactPhone.Trim();
paras[10].Value = model.ContactAddress.Trim();
paras[11].Value = model.IsDriver;
if (string.IsNullOrEmpty(model.DriveCode))
{
paras[12].Value = DBNull.Value;
}
else
{
paras[12].Value = model.DriveCode.Trim();
}
paras[13].Value = model.DriveTypeID;
paras[14].Value = model.IsCarrier;
if (string.IsNullOrEmpty(model.EmergePhone))
{
paras[15].Value = DBNull.Value;
}
else
{
paras[15].Value = model.EmergePhone.Trim();
}
paras[16].Value = model.DriveLicenseStateID;
if (string.IsNullOrWhiteSpace(model.Remark))
{
paras[17].Value = DBNull.Value;
}
else
{
paras[17].Value = model.Remark;
}
paras[18].Value = 0;
paras[19].Value = currentUserID;
paras[20].Value = DateTime.Now;
paras[21].Value = DBNull.Value;
paras[22].Value = DBNull.Value;
if (string.IsNullOrEmpty(model.DriveCodeValidTime))
{
paras[23].Value = DBNull.Value;
}
else
{
paras[23].Value = model.DriveCodeValidTime;
}
if (string.IsNullOrEmpty(model.CarrierCode))
{
paras[24].Value = DBNull.Value;
}
else
{
paras[24].Value = model.CarrierCode.Trim();
}
paras[25].Value = model.StrucID;
#region SQL
string sql = @"INSERT INTO dbo.EmployeeInfo
( EmployeeID ,
EmployeeName ,
EmployeeGender ,
BirthDate ,
ContactPhone ,
ContactAddress ,
CertificateTypeID ,
CertificateCode ,
CertificateOffice ,
ValidStartTime ,
ValidEndTime ,
IsDriver ,
DriveCode ,
DriveTypeID ,
DriveLicenseStateID ,
IsCarrier ,
EmergePhone ,
Remark ,
Status ,
CreateUser ,
CreateTime ,
UpdateUser ,
UpdateTime ,
DriveCodeValidTime ,
CarrierCode ,
StrucID
)
VALUES ( @EmployeeID , -- EmployeeID - nvarchar(20)
@EmployeeName , -- EmployeeName - nvarchar(50)
@EmployeeGender , -- EmployeeGender - bit
@BirthDate , -- BirthDate - date
@ContactPhone , -- ContactPhone - nvarchar(20)
@ContactAddress , -- ContactAddress - nvarchar(200)
@CertificateTypeID , -- CertificateTypeID - int
@CertificateCode , -- CertificateCode - nvarchar(20)
@CertificateOffice, -- CertificateOffice - nvarchar(50)
@ValidStartTime , -- ValidStartTime - date
@ValidEndTime , -- ValidEndTime - date
@IsDriver , -- IsDriver - bit
@DriveCode , -- DriveCode - nvarchar(20)
@DriveTypeID , -- DriveTypeID - int
@DriveLicenseStateID , -- DriveLicenseStateID - int
@IsCarrier , -- IsCarrier - bit
@EmergePhone , -- EmergePhone - nvarchar(20)
@Remark , -- Remark - nvarchar(500)
@Status , -- Status - int
@CreateUser , -- CreateUser - int
@CreateTime , -- CreateTime - datetime
@UpdateUser , -- UpdateUser - int
@UpdateTime , -- UpdateTime - datetime
@DriveCodeValidTime,
@CarrierCode ,
@StrucID
)";
#endregion
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
public ActionResult AddEmployeeInfo(EmployeeInfoAddModel model)
{
//if (model.CertificateTypeID == 1)
//{
// bool isIDcard = IsIDcard(model.CertificateCode);
// if (!isIDcard) {
// ModelState.AddModelError("CertificateCode", DataAnnotations.IDcardError);
// }
//}
//if (model.IsDriver == true && string.IsNullOrEmpty(model.DriveCode))
//{
// ModelState.AddModelError("DriveCode", DataAnnotations.NeedDriveCode);
//}
//if (model.IsDriver == true && string.IsNullOrEmpty(model.DriveCodeValidTime))
//{
// ModelState.AddModelError("DriveCodeValidTime", DataAnnotations.MustInputDriveCodeValidTime);
//}
if (model.IsDriver == true && model.DriveLicenseStateID == 0)
{
ModelState.AddModelError("DriveLicenseStateID", DataAnnotations.MustInputDriveLicenseStateID);
}
//if (model.IsDriver == true && model.DriveTypeID.Equals("0"))
//{
// ModelState.AddModelError("DriveTypeID", DataAnnotations.MustInputDriveTypeID);
//}
//if (model.IsCarrier == true && string.IsNullOrEmpty(model.EmergePhone))
//{
// ModelState.AddModelError("EmergePhone", DataAnnotations.NeedEmergePhone);
//}
//if (model.IsCarrier == true && string.IsNullOrEmpty(model.CarrierCode))
//{
// ModelState.AddModelError("CarrierCode", DataAnnotations.NeedCarrierCode);
//}
if (ModelState.IsValid)
{
var result = EmployeeInfoBLL.AddEmployeeInfo(model, base.CurrentUserID);
base.DoLog(OperationTypeEnum.Add, result, "EmployeeName:" + model.EmployeeName);
return(Json(result));
}
else
{
model.CertificateTypeSelectList = new SelectList(EmployeeInfoBLL.GetCertificateTypes(), "CertificateTypeID", "CertificateTypeName");
SelectList driveLicenseStateSelectList = new SelectList(EmployeeInfoBLL.GetDriveLicenseStates(), "DriveLicenseStateID", "DriveLicenseStateName");
List <SelectListItem> liDriveLicenseState = new List <SelectListItem>();
liDriveLicenseState.Add(new SelectListItem {
Text = DisplayText.PleaseSelect, Value = "0", Selected = true
});
liDriveLicenseState.AddRange(driveLicenseStateSelectList);
model.DriveLicenseStateSelectList = liDriveLicenseState;
SelectList driveTypeSelectList = new SelectList(EmployeeInfoBLL.GetDriveTypes(), "DriveTypeID", "DriveTypeName");
List <SelectListItem> liDriveType = new List <SelectListItem>();
liDriveType.Add(new SelectListItem {
Text = DisplayText.PleaseSelect, Value = "0", Selected = true
});
liDriveType.AddRange(driveTypeSelectList);
model.DriveTypeSelectList = liDriveType;
return(PartialView("_AddEmployeeInfo", model));
}
}
