private static void FetchChildren(IDataReader sdr, PositionApplication positionApplication)
{
sdr.NextResult();
positionApplication.Position.Nature = new List <PositionNature>();
while (sdr.Read())
{
PositionNature positionNature = new PositionNature();
positionNature.Pkid = (int)sdr["PositionNatureID"];
positionApplication.Position.Nature.Add(positionNature);
}
sdr.NextResult();
positionApplication.Position.Departments = new List <Department>();
while (sdr.Read())
{
positionApplication.Position.Departments.Add(new Department((int)sdr["DeptID"], ""));
}
sdr.NextResult();
positionApplication.Position.Members = new List <Account>();
while (sdr.Read())
{
positionApplication.Position.Members.Add(new Account((int)sdr["AccountID"], "", ""));
}
}
private void GetPositionNatureByID()
{
List <Performance.Error> errors = new List <Performance.Error>();
PositionNatureViewModel positionNatureViewModel = new PositionNatureViewModel();
try
{
string pkid = _Context.Request.Params["PKID"];
if (pkid == null)
{
return;
}
PositionNature positionNature = BllInstance.PositionBllInstance.GetPositionNatureById(Convert.ToInt32(pkid));
if (positionNature != null)
{
positionNatureViewModel.PKID = positionNature.Pkid.ToString();
positionNatureViewModel.Name = positionNature.Name;
positionNatureViewModel.Description = positionNature.Description;
}
}
catch (Exception e)
{
errors.Add(new Performance.Error("lblMessage", e.Message));
}
_ResponseString =
string.Format("{{\"itemList\":{0},\"error\":{1}}}", JsonConvert.SerializeObject(positionNatureViewModel),
JsonConvert.SerializeObject(errors));
}
private static PositionNature FetchPositionNature(IDataRecord dr)
{
PositionNature positionNature = new PositionNature();
positionNature.Pkid = Convert.ToInt32(dr["PKID"]);
positionNature.Name = dr["Name"].ToString();
positionNature.Description = dr["Description"].ToString();
return(positionNature);
}
public void UpdatePositionNature(PositionNature obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@PKID", obj.Pkid);
cmd.Parameters.AddWithValue("@Name", obj.Name);
cmd.Parameters.AddWithValue("@Description", obj.Description);
SqlHelper.ExecuteNonQuery("UpdatePositionNature", cmd);
}
public void InsertPositionNature(PositionNature obj)
{
SqlCommand cm = new SqlCommand();
cm.Parameters.AddWithValue("@Name", obj.Name);
cm.Parameters.AddWithValue("@Description", obj.Description);
cm.Parameters.AddWithValue("@PKID", obj.Pkid);
cm.Parameters["@PKID"].Direction = ParameterDirection.Output;
int pkid;
SqlHelper.ExecuteNonQueryReturnPKID("AddPositionNature", cm, out pkid);
obj.Pkid = pkid;
}
private void AddPositionNature()
{
List <Performance.Error> errors = new List <Performance.Error>();
try
{
PositionNature positionNature = new PositionNature();
positionNature.Description = _Context.Request.Params["Description"];
positionNature.Name = _Context.Request.Params["Name"];
BllInstance.PositionBllInstance.CreatePositionNature(positionNature);
}
catch (Exception e)
{
errors.Add(new Performance.Error("dialoglblMessage", e.Message));
}
_ResponseString = string.Format("{{\"error\":{0}}}", JsonConvert.SerializeObject(errors));
}
public void UpdatePositionNature(PositionNature position)
{
UpdatePositionNature updatePositionNature = new UpdatePositionNature(position);
updatePositionNature.Excute();
}
public void CreatePositionNature(PositionNature position)
{
AddPositionNature addPositionNature = new AddPositionNature(position);
addPositionNature.Excute();
}
public UpdatePositionNature(PositionNature PositionNature)
{
_PositionNature = PositionNature;
}
public AddPositionNature(PositionNature PositionGrade)
{
_PositionNature = PositionGrade;
}
private void PositionDataBind(Position position)
{
DateTime dt;
position.Name = _Context.Request.Params["dialogName"] ?? string.Empty;
position.Description = _Context.Request.Params["dialogDescription"] ?? string.Empty;
position.Number = _Context.Request.Params["dialogNumber"] ?? string.Empty;
position.Reviewer =
BllInstance.AccountBllInstance.GetAccountByName(_Context.Request.Params["dialogReviewer"] ??
string.Empty);
position.Version = _Context.Request.Params["dialogVersion"] ?? string.Empty;
if (_Context.Request.Params["dialogCommencement"] != null &&
DateTime.TryParse(_Context.Request.Params["dialogCommencement"], out dt))
{
position.Commencement = dt;
}
position.Summary = _Context.Request.Params["dialogSummary"] ?? string.Empty;
position.MainDuties = _Context.Request.Params["dialogMainDuties"] ?? string.Empty;
position.ReportScope = _Context.Request.Params["dialogReportScope"] ?? string.Empty;
position.ControlScope = _Context.Request.Params["dialogControlScope"] ?? string.Empty;
position.Coordination = _Context.Request.Params["dialogCoordination"] ?? string.Empty;
position.Authority = _Context.Request.Params["dialogAuthority"] ?? string.Empty;
position.Education = _Context.Request.Params["dialogEducation"] ?? string.Empty;
position.ProfessionalBackground = _Context.Request.Params["dialogProfessionalBackground"] ?? string.Empty;
position.WorkExperience = _Context.Request.Params["dialogWorkExperience"] ?? string.Empty;
position.Qualification = _Context.Request.Params["dialogQualification"] ?? string.Empty;
position.Competence = _Context.Request.Params["dialogCompetence"] ?? string.Empty;
position.OtherRequirements = _Context.Request.Params["dialogOtherRequirements"] ?? string.Empty;
position.KnowledgeAndSkills = _Context.Request.Params["dialogKnowledgeAndSkills"] ?? string.Empty;
position.RelatedProcesses = _Context.Request.Params["dialogRelatedProcesses"] ?? string.Empty;
position.ManagementSkills = _Context.Request.Params["dialogManagementSkills"] ?? string.Empty;
position.AuxiliarySkills = _Context.Request.Params["dialogAuxiliarySkills"] ?? string.Empty;
int i;
if (!string.IsNullOrEmpty(_Context.Request.Params["dialogPositionStatus"]) &&
int.TryParse(_Context.Request.Params["dialogPositionStatus"], out i))
{
position.PositionStatus = PositionStatus.GetById(i);
}
else
{
position.PositionStatus = PositionStatus.All;
}
if (!string.IsNullOrEmpty(_Context.Request.Params["dialogcblNature"]))
{
string[] natureIDs = _Context.Request.Params["dialogcblNature"].Split('|');
foreach (string id in natureIDs)
{
if (int.TryParse(id, out i))
{
PositionNature pn = new PositionNature();
pn.Pkid = i;
position.Nature = position.Nature ?? new List <PositionNature>();
position.Nature.Add(pn);
}
}
}
position.Grade = new PositionGrade();
position.Grade.Id = 0;
//position.Grade.Id = !string.IsNullOrEmpty(_Context.Request.Params["dialogGrade"]) &&
// int.TryParse(_Context.Request.Params["dialogGrade"], out i)
// ? i
// : 0;
string errorname;
List <Account> accounts =
BllInstance.AccountBllInstance.GetAccountByNameString(
_Context.Request.Params["dialogEmployee"] ?? string.Empty, out errorname);
if (!string.IsNullOrEmpty(errorname))
{
throw new Exception("系统中没有找到" + errorname + "，请确认系统中有这些人员的信息。");
}
position.Members = accounts;
errorname = string.Empty;
List <Department> departments =
BllInstance.DepartmentBllInstance.GetDepartmentByNameString(
_Context.Request.Params["dialogDepartment"] ?? string.Empty, out errorname);
if (!string.IsNullOrEmpty(errorname))
{
throw new Exception("系统中没有找到" + errorname + "，请确认系统中有这些部门。");
}
position.Departments = departments;
}
