private void GetPageValue(Qz_job_manage model)
{
model.CAMPUS = Post("CAMPUS");
model.JOB_TYPE = Post("JOB_TYPE");
model.EMPLOYER = Post("EMPLOYER");
model.JOB_NAME = Post("JOB_NAME");
model.REQ_NUM = comTran.ToDecimal(Post("REQ_NUM"));
model.JOB_DESCR = Post("JOB_DESCR");
model.JOB_RQMT = Post("JOB_RQMT");
model.WORK_PLACE = Post("WORK_PLACE");
model.REWARD_STD = comTran.ToDecimal(Post("REWARD_STD"));
model.REWARD_UNIT = Post("REWARD_UNIT");
model.IS_USE = Post("IS_USE");
model.IS_MULT = Post("IS_MULT");
model.SCH_YEAR = Post("SCH_YEAR");
model.SCH_TERM = Post("SCH_TERM");
model.DECL_START_TIME = Post("DECL_START_TIME");
model.DECL_END_TIME = Post("DECL_END_TIME");
model.WORK_START_TIME = Post("WORK_START_TIME");
model.WORK_END_TIME = Post("WORK_END_TIME");
model.ORDER_NUM = comTran.ToDecimal(Post("ORDER_NUM"));
//model.STU_TYPE = Post("hidStuType").TrimEnd(',');
model.STU_TYPE = Post("STU_TYPE");
model.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.OP_CODE = user.User_Id;
model.OP_NAME = user.User_Name;
model.DECL_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
private string UpdateEmployFlag()
{
try
{
string flag = Get("flag");
head.OID = Get("id");
if (string.IsNullOrEmpty(head.OID))
{
return("主键为空，不允许操作");
}
ds.RetrieveObject(head);
if (flag == CValue.FLAG_Y)
{
object num = ds.ExecuteTxtScalar(string.Format("SELECT REQ_NUM FROM QZ_JOB_MANAGE WHERE SEQ_NO = '{0}'", head.EXPECT_JOB1));
object o = ds.ExecuteTxtScalar(string.Format("SELECT COUNT(1) FROM QZ_JOB_APPLY_HEAD WHERE EMPLOY_FLAG = 'Y' AND EXPECT_JOB1 = '{0}'", head.EXPECT_JOB1));
if (comTran.ToDecimal(o) >= comTran.ToDecimal(num))
{
return("录用人数已达需求人数上限，不允许操作");
}
}
head.EMPLOY_FLAG = flag;
ds.UpdateObject(head);
return(string.Empty);
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
Qz_job_manage_set head = new Qz_job_manage_set();
head.OID = Post("OID");
if (head.OID == "")
{
head.OID = Guid.NewGuid().ToString();
}
ds.RetrieveObject(head);
head.SCH_YEAR = Post("SCH_YEAR");
head.SCH_TERM = Post("SCH_TERM");
head.IS_ENABLE = Post("IS_ENABLE");
head.DECLARE_START_TIME = Post("DECLARE_START_TIME");
head.DECLARE_END_TIME = Post("DECLARE_END_TIME");
head.REWARD_STD_B = comTran.ToDecimal(Post("REWARD_STD_B"));
head.REWARD_UNIT_B = Post("REWARD_UNIT_B");
head.REWARD_STD_Y = comTran.ToDecimal(Post("REWARD_STD_Y"));
head.REWARD_UNIT_Y = Post("REWARD_UNIT_Y");
head.OP_CODE = user.User_Id;
head.OP_NAME = user.User_Name;
head.OP_TIME = ComTranClass.getInstance().GetCurrLongDateTime();
ds.UpdateObject(head);
return(head.OID);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保存岗位申报基本设置出错：" + ex.ToString());
return(string.Empty);
}
}
private string SaveReward()
{
try
{
Qz_job_reward_list list = new Qz_job_reward_list();
list.OID = Post("OID");
if (list.OID == "")
{
list.OID = Guid.NewGuid().ToString();
}
ds.RetrieveObject(list);
list.SEQ_NO = Get("seq_no");
//list.REWARD_STD = comTran.ToDecimal(Post("REWARD_STD"));
//list.QUANTITY = comTran.ToDecimal(Post("QUANTITY"));
list.REAL_AMOUNT = comTran.ToDecimal(Post("REAL_AMOUNT"));
ds.UpdateObject(list);
string total_real_amount = JobRewardHandleClass.getInstance().CalculateRealAmount(list.SEQ_NO).ToString();
return(total_real_amount);
}
catch (Exception ex)
{
return(string.Empty);
}
}
private string CheckSave()
{
string oid = Get("id");
string strJob = Server.UrlDecode(Get("job"));
if (!string.IsNullOrEmpty(oid))
{
object o = ds.ExecuteTxtScalar(string.Format("SELECT COUNT(1) FROM QZ_JOB_APPLY_HEAD WHERE STU_NUMBER = '{0}' AND SCH_YEAR = '{1}' AND SCH_TERM = '{2}' AND EXPECT_JOB1 = '{3}' AND OID != '{4}'", user.User_Id, sch_info.CURRENT_YEAR, sch_info.CURRENT_XQ, strJob, oid));
if (o != null && comTran.ToDecimal(o.ToString()) > 0)
{
return("同一岗位不允许重复申请");
}
}
return(string.Empty);
}
private string SaveWorkDetail()
{
try
{
Qz_job_proof_list list = new Qz_job_proof_list();
list.OID = Post("LIST_OID");
if (list.OID == "")
{
list.OID = Guid.NewGuid().ToString();
}
ds.RetrieveObject(list);
list.SEQ_NO = Get("seq_no");
list.WORK_DATE = Post("WORK_DATE");
list.WORK_START_TIME = Post("WORK_START_TIME");
list.WORK_END_TIME = Post("WORK_END_TIME");
list.WORK_HOURS = comTran.ToDecimal(Post("WORK_HOURS"));
list.WORK_TASK = Post("WORK_TASK");
list.JOB_SEQ_NO = Post("JOB_SEQ_NO");
ds.UpdateObject(list);
decimal reward = JobProofHandleClass.getInstance().CalculateReward(list.SEQ_NO);
ds.ExecuteTxtNonQuery(string.Format("UPDATE QZ_JOB_PROOF_HEAD SET REWARD = {1} WHERE SEQ_NO = '{0}'", list.SEQ_NO, reward));
//return list.OID + ";" + list.SEQ_NO;
return(Math.Round(reward, 2).ToString());
}
catch (Exception ex)
{
return(string.Empty);
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
try
{
Dst_level_info head = new Dst_level_info();
head.OID = Post("OID");
if (head.OID == "")
{
head.OID = Guid.NewGuid().ToString();
}
ds.RetrieveObject(head);
head.LEVEL_CODE = Post("LEVEL_CODE");
head.LEVEL_NAME = Post("LEVEL_NAME");
head.LEVEL_NOTE = Post("LEVEL_NOTE");
head.RATIO = comTran.ToDecimal(Post("RATIO"));
head.OP_USER = user.User_Name;
head.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ds.UpdateObject(head);
return(head.OID);
}
catch (Exception ex)
{
return(string.Empty);
}
}
private void GetPageValue(Qz_job_apply_head model)
{
model.DORMITORY = Post("DORMITORY");
if (model.TELEPHONE.Length == 0)
{
model.TELEPHONE = Post("TELEPHONE");
}
if (model.BANK_ACCOUNT.Length == 0)
{
model.BANK_ACCOUNT = Post("BANK_ACCOUNT");
}
if (model.BANK_CARD_NO.Length == 0)
{
model.BANK_CARD_NO = Post("BANK_CARD_NO");
}
model.ENGLISH_LEVEL = Post("ENGLISH_LEVEL");
model.COMPUTER_LEVEL = Post("COMPUTER_LEVEL");
model.IS_FAIL = Post("IS_FAIL");
model.FAIL_NUM = comTran.ToDecimal(Post("FAIL_NUM"));
model.FAMILY_TYPE = Post("FAMILY_TYPE");
model.SPECIALITY = Post("SPECIALITY");
model.WORK_EXPERIENCE = Post("WORK_EXPERIENCE");
model.APPLY_REASON = Post("APPLY_REASON");
model.MONDAY = Post("DAY1");
model.TUESDAY = Post("DAY2");
model.WEDNESDAY = Post("DAY3");
model.THURSDAY = Post("DAY4");
model.FRIDAY = Post("DAY5");
model.SATURDAY = Post("DAY6");
model.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.OP_CODE = user.User_Id;
model.OP_NAME = user.User_Name;
model.DECL_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
private string GetApplyData()
{
if (string.IsNullOrEmpty(Get("id")))
{
return("{}");
}
string number = string.Empty;
Hashtable ddl = new Hashtable();
ddl["SCHYEAR"] = "ddl_year_type";
ddl["SEX"] = "ddl_xb";
ddl["COLLEGE"] = "ddl_department";
ddl["MAJOR"] = "ddl_zy";
ddl["CLASS"] = "ddl_class";
ddl["NATION"] = "ddl_mz";
ddl["POLISTATUS"] = "ddl_zzmm";
DataTable dt = ds.ExecuteTxtDataTable(string.Format("SELECT *, '' AS PRE_LEVEL FROM DST_STU_APPLY WHERE OID = '{0}' ", Get("id")));
if (dt == null || dt.Rows.Count == 0)
{
return("{}");
}
else
{
cod.ConvertTabDdl(dt, ddl);
foreach (DataRow dr in dt.Rows)
{
number = dr["NUMBER"].ToString();
dr["PRE_LEVEL"] = ConverPreLevel(dr["POS_CODE"].ToString(), dr["LEVEL1"].ToString(), dr["LEVEL2"].ToString());
dr["HOME_ADDRESS"] = ComHandleClass.getInstance().ConvertAddress(dr["HOME_ADDRESS"].ToString());
if (dr["RET_CHANNEL"].ToString().Equals(CValue.RET_CHANNEL_A0000))
{
dr["ANNUAL_INCOME"] = comTran.ToDecimal(GetIncome(number, "year"));
dr["MONTHLY_INCOME"] = comTran.ToDecimal(GetIncome(number, "month"));
}
}
}
return(Json.DatatableToJson(dt));
}
private string GetIncome(string number)
{
if (!string.IsNullOrEmpty(number))
{
Dst_family_situa situa = FamilySurveyHandleClass.getInstance().GetDst_family_situa(new Dictionary <string, string> {
{ "NUMBER", number }
});
if (situa != null)
{
head.SERIAL_NO = situa.SERIAL_NO;
DataTable dt = ds.ExecuteTxtDataTable(string.Format("SELECT SUM(INCOME) INCOME,COUNT(1) QTY FROM DST_FAMILY_MEMBERS WHERE SEQ_NO='{0}'", situa.SEQ_NO));
if (dt != null && dt.Rows.Count == 1)
{
head.ANNUAL_INCOME = comTran.ToDecimal(dt.Rows[0]["INCOME"].ToString());
head.MONTHLY_INCOME = (situa.FAMILY_SIZE > 0) ? Math.Round(head.ANNUAL_INCOME / situa.FAMILY_SIZE / 12, 2) : 0;
}
}
}
return(head.ANNUAL_INCOME.ToString() + "*" + head.MONTHLY_INCOME.ToString());
}
private string SaveCompleteStatus()
{
try
{
head.OID = Post("OID");
if (string.IsNullOrEmpty(head.OID))
{
return(string.Empty);
}
ds.RetrieveObject(head);
head.REWARD = comTran.ToDecimal(Post("REWARD"));
head.CMPL_STS = Post("CMPL_STS").Equals("O") ? Post("CMPL_STS_TEXT") : Post("CMPL_STS");
ds.UpdateObject(head);
return(head.OID);
}
catch (Exception ex)
{
string msg = string.Format("保存劳动完成情况异常，原因：{0}", ex.Message);
LogDBHandleClass.getInstance().LogException(string.Empty, msg);
return(string.Empty);
}
}
private void GetPageValue(Dst_family_situa model)
{
model.HUKOU_BEFORE = Post("HUKOU_BEFORE");
model.FAMILY_SIZE = comTran.ToDecimal(Post("FAMILY_SIZE"));
model.GRADUATE_SCHOOL = Post("GRADUATE_SCHOOL");
model.IS_ORPHAN = ConverCheckbox(Post("IS_ORPHAN"));
model.IS_SINGLE = ConverCheckbox(Post("IS_SINGLE"));
model.IS_DISABLED = ConverCheckbox(Post("IS_DISABLED"));
model.IS_MARTYRS = ConverCheckbox(Post("IS_MARTYRS"));
model.IS_OTHER = ConverCheckbox(Post("IS_OTHER"));
model.IS_MINIMUM = Post("IS_MINIMUM");
model.IS_POOR = Post("IS_POOR");
model.ADDRESS = Post("PROVINCE") + "|" + Post("CITY") + "|" + Post("COUNTY") + "|" + Post("ADD_STREET");
model.POSTCODE = Post("POSTCODE");
model.TELEPHONE = Post("TELEPHONE");
model.FUND_SITUA = Post("FUND_SITUA");
model.ACCIDENT_SITUA = Post("ACCIDENT_SITUA");
model.WORK_SITUA = Post("WORK_SITUA");
model.DEBT_SITUA = Post("DEBT_SITUA");
model.OTHER_SITUA = Post("OTHER_SITUA");
model.SCHYEAR = sch_info.CURRENT_YEAR;
model.OP_CODE = user.User_Id;
model.OP_NAME = user.User_Name;
model.OP_TIME = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.IS_LOAN = Post("IS_LOAN");
model.OUT_FUND = Post("OUT_FUND");
model.OUT_FUND_MONEY = comTran.ToDecimal(Post("OUT_FUND_MONEY"));
model.OUT_FUND_PROJECT = Post("OUT_FUND_PROJECT");
model.HEALTH_TYPE = Post("HEALTH_TYPE");
model.DISA_DEGREE = Post("DISA_DEGREE");
model.HUKOU_ZONE = Post("HUKOU_ZONE");
model.ORPHAN_DETAIL = Post("ORPHAN_DETAIL");
model.SINGLE_DETAIL = Post("SINGLE_DETAIL");
model.TOTAL_COST = comTran.ToDecimal(Post("TOTAL_COST"));
model.LIVING_EXP = comTran.ToDecimal(Post("LIVING_EXP"));
model.FAMILY_STATUS = Post("FAMILY_STATUS");
model.SUPPORT_TYPE = Post("SUPPORT_TYPE");
model.SUPPORT_NUM = comTran.ToDecimal(Post("SUPPORT_NUM"));
}