private string DeleteGrant()
{
Dst_stu_grant grant = new Dst_stu_grant();
var code = Get("id");
if (string.IsNullOrEmpty(code))
{
return("主键为空,不允许删除操作");
}
grant.OID = code;
ds.RetrieveObject(grant);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Dst_stu_grant>("Dst_stu_grantDeleteTransaction");
transaction.EntityList.Add(grant);
bDel = transaction.Commit();
if (!bDel)
{
return("删除失败！");
}
else
{
return("");
}
}
private string DeleteData()
{
var code = Get("id");
if (string.IsNullOrEmpty(code))
{
return("主键为空,不允许删除操作");
}
head.OID = code;
ds.RetrieveObject(head);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Dst_stu_apply>("Dst_stu_applyDeleteTransaction");
transaction.EntityList.Add(head);
bDel = transaction.Commit();
if (!bDel)
{
return("删除失败！");
}
else
{
return("");
}
}
private string DeleteData()
{
var oid = Get("id");
if (string.IsNullOrEmpty(oid))
{
return("主键为空,不允许删除操作");
}
head.OID = oid;
ds.RetrieveObject(head);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Qz_job_manage>("Qz_job_manageDeleteTransaction");
transaction.EntityList.Add(head);
bDel = transaction.Commit();
if (!bDel)
{
return("删除失败！");
}
else
{
return(string.Empty);
}
}
/// <summary>
/// 删除主表数据并且把子表数据也删除
/// </summary>
/// <returns></returns>
private string DeleteData()
{
var code = Post("OID");
if (string.IsNullOrEmpty(code))
{
return("主键为空,不允许删除操作");
}
var model = new Dst_level_info();
model.OID = code;
ds.RetrieveObject(model);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Dst_level_info>("Dst_level_infoDeleteTransaction");
transaction.EntityList.Add(model);
bDel = transaction.Commit();
if (bDel)
{
return("");
}
return("删除失败！");
}
private string DeleteLog()
{
try
{
string fromDATE = Post("Fromdate");//获取页面文本信息。
string toDATE = Post("Todate");
Dictionary <string, string> param = new Dictionary <string, string> {
{ string.Format(" LOG_DATE BETWEEN '{0} 00:00:00,000' AND '{1} 23:59:59,999'", fromDATE, toDATE), "" }
}; //筛选出数据的SQL。
var selecttrcn = ImplementFactory.GetSelectTransaction <Log_sys_operation>("Log_sys_operationSelectTransaction", param);
var list = selecttrcn.SelectAll();
var deletetrcn = ImplementFactory.GetDeleteTransaction <Log_sys_operation>("Log_sys_operationDeleteTransaction");
for (int i = 0; i < list.Count; i++)
{
deletetrcn.EntityList.Add(new Log_sys_operation()
{
OID = list[i].OID//获取筛选出的数据的OID，并添加到删除事务里。
});
}
if (list.Count > 0 && deletetrcn.Commit())
{
return("");
}
else
{
return("删除不成功！");
}
}
catch (Exception ex)
{
return(string.Format("删除日志异常，原因：{0}", ex.Message));
}
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
private string Delete()
{
try
{
string[] strs = Get("ids").Split(',');
for (int i = 0; i < strs.Length; i++)
{
if (strs[i].Length == 0)
{
continue;
}
var model = new Score_rank_info();
model.OID = strs[i].ToString();
ds.RetrieveObject(model);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Score_rank_info>("Score_rank_infoDeleteTransaction");
transaction.EntityList.Add(model);
bDel = transaction.Commit();
if (!bDel)
{
return("删除失败！");
}
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "删除成绩信息失败：" + ex.ToString());
return("删除失败！");
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
if (string.IsNullOrEmpty(Request.QueryString["id"]))
{
return("OID为空,不允许删除操作");
}
Question_info head = new Question_info();
head.OID = Request.QueryString["id"].ToString();
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Question_info>("Question_infoDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "问题反馈删除失败：" + ex.ToString());
return("删除失败！");
}
}
private string Delete()
{
try
{
if (Request.QueryString["id"].Length <= 0)
{
return("菜单ID参数不正确，重新操作或者联系管理人员进行处理");
}
var deletetrcn = ImplementFactory.GetDeleteTransaction <Ua_function>("Ua_functionDeleteTransaction");
deletetrcn.EntityList.Add(new Ua_function()
{
FUNCTIONID = Request.QueryString["id"]
});
if (deletetrcn.Commit())
{
//把子菜单也一并删除
string strSQL = string.Format("DELETE FROM UA_FUNCTION WHERE PARENTID = '{0}' ", Request.QueryString["id"].ToString());
ds.ExecuteTxtNonQuery(strSQL);
return("删除成功");
}
return("操作失败!");
}
catch (Exception ex)
{
return("删除失败!原因：" + ex.Message);
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
if (string.IsNullOrEmpty(Request.QueryString["id"]))
{
return("OID为空,不允许删除操作");
}
Shoolar_apply_study_list head = new Shoolar_apply_study_list();
head.OID = Request.QueryString["id"].ToString();
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Shoolar_apply_study_list>("Shoolar_apply_study_listDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_WARN, "奖助申请，删除学习科目数据失败：" + ex.ToString());
return("删除失败！");
}
}
/// <summary>
/// 通过传入的主键编码删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
if (string.IsNullOrEmpty(Get("id")))
{
return("主键为空,不允许删除操作");
}
var model = new Messge_info();
model.OID = Get("id");
ds.RetrieveObject(model);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Messge_info>("Messge_infoDeleteTransaction");
transaction.EntityList.Add(model);
bDel = transaction.Commit();
if (!bDel)
{
return("删除失败！");
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "删除消息，出错：" + ex.ToString());
return("删除失败！");
}
}
private string DeleteMember()
{
bool bDel = false;
string oid = Get("oid");
if (string.IsNullOrEmpty(oid))
{
return("主键为空，不允许删除！");
}
Dst_family_members m = new Dst_family_members();
m.OID = oid;
ds.RetrieveObject(m);
var transaction = ImplementFactory.GetDeleteTransaction <Dst_family_members>("Dst_family_membersDeleteTransaction");
transaction.EntityList.Add(m);
bDel = transaction.Commit();
if (bDel)
{
string msg;
if (!FamilySurveyHandleClass.getInstance().CalculateIncome(m.SEQ_NO, out msg))
{
msg = "计算家庭年收入异常";
}
return(msg);
}
return("删除失败！");
}
private string DeleteWorkDetail()
{
var oid = Get("id");
if (string.IsNullOrEmpty(oid))
{
return("主键为空,不允许删除操作");
}
Qz_job_proof_list list = new Qz_job_proof_list();
list.OID = oid;
ds.RetrieveObject(list);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Qz_job_proof_list>("Qz_job_proof_listDeleteTransaction");
transaction.EntityList.Add(list);
bDel = transaction.Commit();
if (!bDel)
{
return(string.Empty);
}
else
{
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(Math.Round(reward, 2).ToString());
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
string[] strs = Post("SELECT_OID").Split(',');
for (int i = 0; i < strs.Length; i++)
{
if (strs[i].Length == 0)
{
continue;
}
var model = new Makeup_project_apply();
model.OID = strs[i].ToString();
ds.RetrieveObject(model);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Makeup_project_apply>("Makeup_project_applyDeleteTransaction");
transaction.EntityList.Add(model);
bDel = transaction.Commit();
if (!bDel)
{
return("删除失败！");
}
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "删除学费补偿学费补偿申请数据，出错：" + ex.ToString());
return("删除失败！");
}
}
/// <summary>
/// 删除主表的时候连带子表的数据也一并删除
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
if (string.IsNullOrEmpty(Get("id")))
{
return("OID为空,不允许删除操作");
}
Peer_project_head head = new Peer_project_head();
head.OID = Get("id");
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Peer_project_head>("Peer_project_headDeleteTransaction");
transaction.EntityList.Add(head);
//已经改写了Commit方法，提交删除操作时会同时把：表体对应数据删除
if (transaction.Commit())
{
return(string.Empty);
}
return("删除失败！");
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "评议项目设置，删除，出错：" + ex.ToString());
return("删除失败！");
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
if (string.IsNullOrEmpty(Get("id")))
{
return("OID为空,不允许删除操作");
}
Insur_apply_check_file head = new Insur_apply_check_file();
head.OID = Get("id");
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Insur_apply_check_file>("Insur_apply_check_fileDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
#region 除对应文件
string strFilePath = head.FILE_DIRECTORY + "/" + head.FILE_SAVE_NAME;
strFilePath = System.Web.HttpContext.Current.Server.MapPath("~/") + strFilePath.Replace("/", "\\");
if (File.Exists(strFilePath))
{
FileInfo fi = new FileInfo(strFilePath);
//文件如果是只读的，设置成 正常 模式
if (fi.Attributes.ToString().IndexOf("ReadOnly") != -1)
{
fi.Attributes = FileAttributes.Normal;
}
//删除指定图片
File.Delete(strFilePath);
}
#endregion 除对应文件
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "保险核对，删除附件数据失败：" + ex.ToString());
return("删除失败！");
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
if (string.IsNullOrEmpty(Get("id")))
{
return("编码为空,不允许删除操作");
}
Basic_class_info head = new Basic_class_info();
head.CLASSCODE = Get("id");
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Basic_class_info>("Basic_class_infoDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
if (string.IsNullOrEmpty(Get("id")))
{
return("编码为空,不允许删除操作");
}
Ua_user head = new Ua_user();
head.USER_ID = Get("id");
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Ua_user>("Ua_userDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
if (string.IsNullOrEmpty(Get("id")))
{
return("编码为空,不允许删除操作");
}
T_zd_zzmm head = new T_zd_zzmm();
head.DM = Get("id");
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <T_zd_zzmm>("T_zd_zzmmDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
string strOID = Request.QueryString["id"];
if (string.IsNullOrEmpty(strOID))
{
return("OID为空,不允许删除操作");
}
Shoolar_project_num head = new Shoolar_project_num();
head.OID = strOID;
ds.RetrieveObject(head);
bool bDel = false;
var transaction = ImplementFactory.GetDeleteTransaction <Shoolar_project_num>("Shoolar_project_numDeleteTransaction");
transaction.EntityList.Add(head);
bDel = transaction.Commit();
return(string.Empty);
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
private string Delete()
{
try
{
var deletetrcn = ImplementFactory.GetDeleteTransaction <Ua_role>("Ua_roleDeleteTransaction");
deletetrcn.EntityList.Add(new Ua_role()
{
ROLEID = Post("ROLEID")
});
if (deletetrcn.Commit())
{
return("");
}
return("操作失败!");
}
catch (Exception ex)
{
return("系统错误!原因：" + ex.Message);
}
}
/// <summary>
/// 删除主表数据并且把子表数据也删除
/// </summary>
/// <returns></returns>
private string DeleteData()
{
if (string.IsNullOrEmpty(Get("id")))
{
return("主键为空,不允许删除操作");
}
var model = new Basic_stu_info();
model.OID = Get("id");
ds.RetrieveObject(model);
var transaction = ImplementFactory.GetDeleteTransaction <Basic_stu_info>("Basic_stu_infoDeleteTransaction");
transaction.EntityList.Add(model);
if (transaction.Commit())
{
return("");
}
return("删除失败！");
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
if (string.IsNullOrEmpty(Get("id")))
{
return("OID为空,不允许删除操作");
}
Wkf_client_queue head = new Wkf_client_queue();
head.OID = Get("id");
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Wkf_client_queue>("Wkf_client_queueDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
string strOID = Post("DM");
if (string.IsNullOrEmpty(strOID))
{
return("编码为空,不允许删除操作");
}
T_zd_xsh head = new T_zd_xsh();
head.DM = strOID;
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <T_zd_xsh>("T_zd_xshDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 删除主表的时候连带子表的数据也一并删除
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
if (string.IsNullOrEmpty(Get("id")))
{
return("OID为空,不允许删除操作");
}
Shoolar_project_head head = new Shoolar_project_head();
head.OID = Get("id");
ds.RetrieveObject(head);
string strDelNotice = string.Format("DELETE FROM NOTICE_INFO WHERE OID = '{0}' ", head.NOTICE_ID);
var transaction = ImplementFactory.GetDeleteTransaction <Shoolar_project_head>("Shoolar_project_headDeleteTransaction");
transaction.EntityList.Add(head);
//已经改写了Commit方法，提交删除操作时会同时把：表体对应数据删除
if (transaction.Commit())
{
if (head.PROJECT_CLASS.Equals("LIFE"))
{
string strDelApplyChk = string.Format("DELETE FROM SHOOLAR_APPLY_CHECK WHERE SEQ_NO IN(SELECT SEQ_NO FROM SHOOLAR_APPLY_HEAD WHERE PROJECT_SEQ_NO = '{0}')", head.SEQ_NO);
ds.ExecuteTxtNonQuery(strDelApplyChk);
string strDelApplyHead = string.Format("DELETE FROM SHOOLAR_APPLY_HEAD WHERE PROJECT_SEQ_NO = '{0}' ", head.SEQ_NO);
ds.ExecuteTxtNonQuery(strDelApplyHead);
}
//删除对应公告
ds.ExecuteTxtNonQuery(strDelNotice);
return(string.Empty);
}
return("删除失败！");
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "奖助项目设置，删除，出错：" + ex.ToString());
return("删除失败！");
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
string strOID = Request.QueryString["id"];
if (string.IsNullOrEmpty(strOID))
{
return("OID为空,不允许删除操作");
}
Shoolar_apply_reward head = new Shoolar_apply_reward();
head.OID = strOID;
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Shoolar_apply_reward>("Shoolar_apply_rewardDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
string strOID = Request.QueryString["id"];
if (string.IsNullOrEmpty(strOID))
{
return("OID为空,不允许删除操作");
}
Peer_project_list head = new Peer_project_list();
head.OID = strOID;
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Peer_project_list>("Peer_project_listDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 通过传入的主键编码删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
try
{
if (string.IsNullOrEmpty(Get("id")))
{
return("主键为空,不允许删除操作");
}
Insur_project_head model = new Insur_project_head();
model.OID = Get("id");
ds.RetrieveObject(model);
//删除发布的核对信息
Messge_info msg = new Messge_info();
msg.OID = model.CHECK_MSG_ID;
ds.RetrieveObject(msg);
var transaction = ImplementFactory.GetDeleteTransaction <Messge_info>("Messge_infoDeleteTransaction");
transaction.EntityList.Add(msg);
if (transaction.Commit())
{
//清除核对信息
model.CHECK_START = "";
model.CHECK_END = "";
model.CHECK_IS_SEND = "";
model.CHECK_MSG_ID = "";
model.CHECK_OP_CODE = "";
model.CHECK_OP_NAME = "";
model.CHECK_OP_TIME = "";
ds.UpdateObject(model);
}
return(string.Empty);
}
catch (Exception ex)
{
LogDBHandleClass.getInstance().LogException(CValue.LOG_LEVEL_ERROR, "删除保险项目数据，出错：" + ex.ToString());
return("删除失败！");
}
}
/// <summary>
/// 删除主表数据并且把子表数据也删除
/// </summary>
/// <returns></returns>
private string DeleteData()
{
var code = Get("id");
if (string.IsNullOrEmpty(code))
{
return("主键为空,不允许删除操作");
}
var model = new Insur_project_head();
model.OID = code;
ds.RetrieveObject(model);
var transaction = ImplementFactory.GetDeleteTransaction <Insur_project_head>("Insur_project_headDeleteTransaction");
transaction.EntityList.Add(model);
if (!transaction.Commit())
{
return("删除失败");
}
return("");
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
string strOID = Get("id");
if (string.IsNullOrEmpty(strOID))
{
return("OID为空,不允许删除操作");
}
Ua_class_group head = new Ua_class_group();
head.OID = strOID;
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Ua_class_group>("Ua_class_groupDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
private string DeleteData()
{
string strOID = Get("id");
if (string.IsNullOrEmpty(strOID))
{
return("OID为空,不允许删除操作");
}
Insur_apply_check head = new Insur_apply_check();
head.OID = strOID;
ds.RetrieveObject(head);
var transaction = ImplementFactory.GetDeleteTransaction <Insur_apply_check>("Insur_apply_checkDeleteTransaction");
transaction.EntityList.Add(head);
if (!transaction.Commit())
{
return("删除失败！");
}
return(string.Empty);
}