/// <summary>
/// 获取界面数据
/// </summary>
/// <param name="model"></param>
private void GetFormValue(Shoolar_apply_check model)
{
switch (user.User_Role)
{
case "S": //学生
model.CHECK_STEP = "1"; //学生已核对
model.S_CHECK_CODE = user.User_Id;
model.S_CHECK_NAME = user.User_Name;
model.S_CHECK_TIME = GetDateLongFormater();
break;
case "F": //辅导员
model.CHECK_STEP = "2"; //辅导员已核对
model.F_CHECK_CODE = user.User_Id;
model.F_CHECK_NAME = user.User_Name;
model.F_CHECK_TIME = GetDateLongFormater();
break;
case "Y": //学院
model.CHECK_STEP = "3"; //学院已核对
model.Y_CHECK_CODE = user.User_Id;
model.Y_CHECK_NAME = user.User_Name;
model.Y_CHECK_TIME = GetDateLongFormater();
break;
}
model.OLD_BANKCODE = Post("OLD_BANKCODE");
model.NEW_BANKCODE = Post("NEW_BANKCODE");
model.OLD_IDCARDNO = Post("OLD_IDCARDNO");
model.NEW_IDCARDNO = Post("NEW_IDCARDNO");
model.REMARK = Post("REMARK");
model.REMARK_Y = Post("REMARK_Y");
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
string strOID = Get("id");
if (string.IsNullOrEmpty(strOID))
{
return("OID为空,不允许删除操作");
}
Shoolar_apply_check head = new Shoolar_apply_check();
head.OID = strOID;
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Shoolar_apply_check>("Shoolar_apply_checkDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 批量确认核对信息
/// </summary>
/// <returns></returns>
private string MultiCheck()
{
try
{
DataTable dtMultiCheck = GetMultiCheckData();
if (dtMultiCheck == null)
{
return("批量核对失败：批量核对数据读取失败！");
}
int nSuccessNum = 0;
int nFailNum = 0;
foreach (DataRow row in dtMultiCheck.Rows)
{
#region 筛选可以核对信息的数据
//筛选可以核对信息的数据
if (row == null)
{
continue;
}
string strMsg = string.Empty;
if (!ProjectCheckHandleClass.getInstance().IsCanCheck(row["OID"].ToString(), user.User_Role, "multi", out strMsg))
{
nFailNum++;
continue;
}
#endregion 筛选可以核对信息的数据
#region 更新核对信息
Shoolar_apply_head head = new Shoolar_apply_head();
head.OID = row["OID"].ToString();
ds.RetrieveObject(head);
if (head == null)
{
continue;
}
Shoolar_apply_check check = ProjectCheckHandleClass.getInstance().GetApplyCheckInfo(head.SEQ_NO);
check.OID = check.OID;
ds.RetrieveObject(check);
#region 批量核对时，也需要校验学生核对情况
if (head.PROJECT_CLASS.Equals("LIFE"))
{
//学生需要有饭卡号，银行卡号才可以核对通过
if (StuHandleClass.getInstance().ByStuNoGetRiceCard(head.STU_NUMBER).Length == 0)
{
nFailNum++;
continue;
}
if (check.OLD_BANKCODE.Length == 0 && check.NEW_BANKCODE.Length == 0)
{
nFailNum++;
continue;
}
}
else
{
//学生需要有银行卡号，身份证号 才可以核对通过
if (check.OLD_BANKCODE.Length == 0 && check.NEW_BANKCODE.Length == 0)
{
nFailNum++;
continue;
}
if (check.OLD_IDCARDNO.Length == 0 && check.NEW_IDCARDNO.Length == 0)
{
nFailNum++;
continue;
}
}
#endregion 批量核对时，也需要校验学生核对情况
switch (user.User_Role)
{
case "F": //辅导员
check.CHECK_STEP = "2"; //辅导员已核对
check.F_CHECK_CODE = user.User_Id;
check.F_CHECK_NAME = user.User_Name;
check.F_CHECK_TIME = GetDateLongFormater();
break;
case "Y": //学院
check.CHECK_STEP = "3"; //学院已核对
check.Y_CHECK_CODE = user.User_Id;
check.Y_CHECK_NAME = user.User_Name;
check.Y_CHECK_TIME = GetDateLongFormater();
break;
}
ds.UpdateObject(check);
nSuccessNum++;
#endregion 更新核对信息
#region 步学生信息中的银行卡与身份证号，修改成核对后的数据
if (check.CHECK_STEP.Equals("3"))
{
#region 银行卡
if (check.NEW_BANKCODE.Length > 0)
{
head.STU_BANKCODE = check.NEW_BANKCODE;
//更新至学生银行卡信息中的银行卡号
string strSqlBank = string.Format("UPDATE BASIC_STU_BANK_INFO SET BANKCODE = '{0}' WHERE NUMBER = '{1}' ", head.STU_BANKCODE, head.STU_NUMBER);
ds.ExecuteTxtNonQuery(strSqlBank);
}
#endregion 银行卡
#region 身份证
if (check.NEW_IDCARDNO.Length > 0)
{
head.STU_IDCARDNO = check.NEW_IDCARDNO;
//更新至学生信息中的身份证号
string strSqlID = string.Format("UPDATE BASIC_STU_INFO SET IDCARDNO = '{0}' WHERE NUMBER = '{1}' ", head.STU_IDCARDNO, head.STU_NUMBER);
ds.ExecuteTxtNonQuery(strSqlID);
}
#endregion 身份证
ds.UpdateObject(head);
}
#endregion 步学生信息中的银行卡与身份证号，修改成核对后的数据
}
return(string.Format("批量核对成功：生效{0}条记录，不生效{1}条记录。", nSuccessNum, nFailNum));
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "批量审批奖助核对失败：" + ex.ToString());
return("批量核对失败！");
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <returns></returns>
private string SaveData()
{
bool bFlag = false;
//新增
Shoolar_apply_check head = new Shoolar_apply_check();
if (string.IsNullOrEmpty(Post("CHECK_OID")))
{
head.OID = Guid.NewGuid().ToString();
ds.RetrieveObject(head);
head.SEQ_NO = Post("hidApplySeqNo");
GetFormValue(head);
var inserttrcn = ImplementFactory.GetInsertTransaction <Shoolar_apply_check>("Shoolar_apply_checkInsertTransaction", user.User_Name);
inserttrcn.EntityList.Add(head);
if (inserttrcn.Commit())
{
bFlag = true;
}
}
else //修改
{
head.OID = Post("CHECK_OID");
ds.RetrieveObject(head);
GetFormValue(head);
var updatetrcn = ImplementFactory.GetUpdateTransaction <Shoolar_apply_check>("Shoolar_apply_checkUpdateTransaction", user.User_Name);
if (updatetrcn.Commit(head))
{
bFlag = true;
}
}
if (bFlag)
{
#region 保存成功之后，修改的 学生信息 同步更新至学生个人信息中
//ZZ 20171213 修改：保存成功之后，修改的 手机号 同步更新至学生个人信息中
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("SEQ_NO", head.SEQ_NO);
Shoolar_apply_head apply = ProjectApplyHandleClass.getInstance().GetApplyHeadInfo(param);
if (apply != null)
{
//手机号
if (!string.IsNullOrWhiteSpace(Post("STU_PHONE")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_Phone(apply.STU_NUMBER, Post("STU_PHONE"));
}
//ZZ 20180319 修改：保存成功之后，修改的 学籍状态以及异动时间 同步更新至学生个人信息中
if (!string.IsNullOrWhiteSpace(Post("STU_REGISTER")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_Register(apply.STU_NUMBER, Post("STU_REGISTER"));
}
if (!string.IsNullOrWhiteSpace(Post("STU_DIFFDATE")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_DiffDate(apply.STU_NUMBER, Post("STU_DIFFDATE"));
}
if (!string.IsNullOrWhiteSpace(Post("STU_RICE_CARD")))
{
StuHandleClass.getInstance().ByStuNumberUpStuInfo_RiceCard(apply.STU_NUMBER, Post("STU_RICE_CARD"));
}
}
#endregion 保存成功之后，修改的 学生信息 同步更新至学生个人信息中
return(string.Empty);
}
else
{
return("保存核对信息失败！");
}
}