/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string IDList, out string message)
{
message = "删除成功！";
string[] idArr = IDList.Split(',');
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_Payment";
string errMessage = procBLL.ExistSubmit(tableName, IDList);
if (errMessage != "")
{
message = errMessage;
return(false);
}
int rows = dal.DeleteList(IDList);
if (rows == 0)
{
message = "对不起，所选数据已被其他人删除！";
return(false);
}
else
{
errMessage = procBLL.SetBillProcess_Del(tableName, IDList);
return(true);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SCZM.Model.Proj.proj_Contract model, int submitFlag, out string message)
{
message = "保存成功！";
if (dal.Exists(model.ProjId, 0))
{
message = "对不起，该项目合同已存在！";
return(0);
}
string errMessage = "";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_Contract";
if (submitFlag == 1)
{
message = "保存并提交成功！";
errMessage = procBLL.CheckSubmit(tableName, model.BillSign, model.DepId, "", model.OperaId);
if (errMessage != "")
{
message = errMessage;
return(0);
}
}
int rowId = dal.Add(model);
if (rowId < 1)
{
message = "保存失败！";
}
else
{
BLL.System.sys_Attachment attachmenBLL = new BLL.System.sys_Attachment();
string IDList = (model.AttachmentId_Contract == "" || model.AttachmentId_Contract == null ? "" : model.AttachmentId_Contract + ",") +
(model.AttachmentId_ControlCard == "" || model.AttachmentId_ControlCard == null ? "" : model.AttachmentId_ControlCard + ",")
;
string FileUse = "项目合同";
if (IDList != "")
{
attachmenBLL.UpdateUseList(Utils.DelLastComma(IDList), FileUse, rowId);
}
if (submitFlag == 1)
{
errMessage = procBLL.SetBillProcess_Submit(tableName, rowId.ToString(), 1, model.OperaId);
if (errMessage != "")
{
message = "保存成功,但提交失败，请联系系统管理员！";
}
}
}
return(rowId);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SCZM.Model.Proj.proj_Payment model, int submitFlag, out string message)
{
message = "保存成功！";
string errMessage = "";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_Payment";
Model.Proj.proj_Payment model_old = dal.GetModel(model.ID);
//----------------------审核不同意（billState==2）重新保存时，重置审批流为草稿状态，再进行保存------------------
if (model_old.BillState == 2)
{
int Num = procBLL.DelBillProcess(model.BillSign, model.ID, tableName, model.OperaId, model.OperaName);
//if (Num == -1)
//{
// message = "对不起，系统出错，请联系系统管理员！";
// return false;
//}
}
//----------------------
if (submitFlag == 1)
{
message = "保存并提交成功！";
errMessage = procBLL.CheckSubmit(tableName, model.BillSign, model.DepId, "", model.OperaId);
if (errMessage != "")
{
message = errMessage;
return(false);
}
}
int rows = dal.Update(model);
if (rows == 0)
{
message = "对不起，该条数据已被其他人删除！";
return(false);
}
else
{
if (submitFlag == 1)
{
errMessage = procBLL.SetBillProcess_Submit(tableName, model.ID.ToString(), 1, model.OperaId);
if (errMessage != "")
{
message = "保存成功,但提交失败，请联系系统管理员！";
}
}
return(true);
}
}
private void GetBillProcess(HttpContext context, string btn)
{
if (btn != "show")
{
context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起，您没有操作权限！\"}");
return;
}
try
{
string billSign = RequestHelper.GetString("billSign");
int billId = RequestHelper.GetInt("billId", 0);
if (billSign == "")
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，单据识别号不能为空！\"}");
return;
}
if (billId == 0)
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，单据ID不能为空！\"}");
return;
}
BLL.System.sys_Process_Exec bll = new BLL.System.sys_Process_Exec();
//string billStateMemo = bll.GetBillState(billSign, billId);
DataTable dt = bll.GetBillProcess(billSign, billId).Tables[0];
//if (dt.Rows.Count == 0)
//{
// context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，该条数据已被其他人删除！\"}");
// return;
//}
string rowsStr = Utils.ToJson(dt);
DataTable historyDT = bll.GetBillProcessHistory(billSign, billId).Tables[0];
string historyStr = Utils.ToJson(historyDT);
StringBuilder jsonStr = new StringBuilder();
jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功！\",\"info\":");
jsonStr.Append(rowsStr);
jsonStr.Append(",\"historyInfo\":");
jsonStr.Append(historyStr);
jsonStr.Append("}");
context.Response.Write(jsonStr);
}
catch (Exception e)
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，系统出错：" + Utils.HtmlEncode(e.Message) + "\"}");
return;
}
}
/// <summary>
/// 批量取消审核数据
/// </summary>
/// <param name="IDList">ID字符串</param>
/// <param name="operaId">操作人ID</param>
/// <param name="message">返回消息</param>
/// <returns></returns>
public bool CanclAudit(string IDList, int operaId, out string message)
{
message = "取消审批成功！";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_Payment";
string resultMessage = "";
bool result = procBLL.SetBillProcess_Audit_Batch(tableName, IDList, 2, operaId, 0, "", out resultMessage);
if (result == false)
{
message = resultMessage;
return(false);
}
return(true);
}
/// <summary>
/// 批量审核数据
/// </summary>
/// <param name="IDList">ID字符串</param>
/// <param name="operaId">操作人ID</param>
/// <param name="flagAudit">审核状态</param>
/// <param name="auditorOpinion">审核意见</param>
/// <param name="message">返回消息</param>
/// <returns></returns>
public bool Audit(string IDList, int operaId, int flagAudit, string auditorOpinion, out string message)
{
message = "审批成功！";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_Payment";
string resultMessage = "";
bool result = procBLL.SetBillProcess_Audit_Batch(tableName, IDList, 1, operaId, flagAudit, auditorOpinion, out resultMessage);
if (result == false)
{
message = resultMessage;
return(false);
}
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(UHPROJ.Model.Base.shop_NewBuildApply model, int submitFlag, out string message)
{
message = "保存成功！";
string errMessage = "";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "shop_NewBuildApply";
if (submitFlag == 1)
{
message = "保存并提交成功！";
errMessage = procBLL.CheckSubmit(tableName, model.BillSign, model.DepId, "", model.OperaId);
if (errMessage != "")
{
message = errMessage;
return(false);
}
}
int rows = dal.Update(model);
if (rows == 0)
{
message = "对不起，该条数据已被其他人删除！";
return(false);
}
else
{
BLL.System.sys_Attachment attachmenBLL = new BLL.System.sys_Attachment();
string IDList = (model.AttachmentId_ZSRW == "" || model.AttachmentId_ZSRW == null ? "" : model.AttachmentId_ZSRW + ",") +
(model.AttachmentId_GH == "" || model.AttachmentId_GH == null ? "" : model.AttachmentId_GH + ",")
;
string FileUse = "加盟申请";
if (IDList != "")
{
attachmenBLL.UpdateUseList(Utils.DelLastComma(IDList), FileUse, model.ID);
}
if (submitFlag == 1)
{
errMessage = procBLL.SetBillProcess_Submit(tableName, model.ID.ToString(), 1, model.OperaId);
if (errMessage != "")
{
message = "保存成功,但提交失败，请联系系统管理员！";
}
}
return(true);
}
}
/// <summary>
/// 批量取消提交数据
/// </summary>
/// <param name="IDList">ID字符串</param>
/// <param name="operaId">操作人ID</param>
/// <param name="message">返回消息</param>
/// <returns></returns>
public bool CancelSubmit(string IDList, int operaId, out string message)
{
message = "取消提交成功！";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_Payment";
string errMessage = procBLL.CheckCancelSubmit(tableName, IDList, operaId);
if (errMessage != "")
{
message = errMessage;
return(false);
}
errMessage = procBLL.SetBillProcess_Submit(tableName, IDList, 2, operaId);
if (errMessage != "")
{
message = errMessage;
return(false);
}
return(true);
}
/// <summary>
/// 批量提交数据
/// </summary>
/// <param name="IDList">ID字符串</param>
/// <param name="operaId">操作人ID</param>
/// <param name="message">返回消息</param>
/// <returns></returns>
public bool Submit(string IDList, int operaId, out string message)
{
message = "提交成功！";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_PartnerContract";
string errMessage = procBLL.CheckSubmit(tableName, "", 0, IDList, operaId);
if (errMessage != "")
{
message = errMessage;
return(false);
}
errMessage = procBLL.SetBillProcess_Submit(tableName, IDList, 1, operaId);
if (errMessage != "")
{
message = errMessage;
return(false);
}
return(true);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SCZM.Model.Proj.proj_Payment model, int submitFlag, out string message)
{
message = "保存成功！";
string errMessage = "";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_Payment";
if (submitFlag == 1)
{
message = "保存并提交成功！";
errMessage = procBLL.CheckSubmit(tableName, model.BillSign, model.DepId, "", model.OperaId);
if (errMessage != "")
{
message = errMessage;
return(0);
}
}
int rowId = dal.Add(model);
if (rowId < 1)
{
message = "保存失败！";
}
else
{
if (submitFlag == 1)
{
errMessage = procBLL.SetBillProcess_Submit(tableName, rowId.ToString(), 1, model.OperaId);
if (errMessage != "")
{
message = "保存成功,但提交失败，请联系系统管理员！";
}
}
}
return(rowId);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SCZM.Model.Proj.proj_Contract model, int submitFlag, out string message)
{
message = "保存成功！";
if (dal.Exists(model.ProjId, model.ID))
{
message = "对不起，该项目合同已存在！";
return(false);
}
string errMessage = "";
BLL.System.sys_Process_Exec procBLL = new BLL.System.sys_Process_Exec();
string tableName = "proj_Contract";
Model.Proj.proj_Contract model_old = dal.GetModel(model.ID);
if (model_old.BillState == 2)
{
int Num = procBLL.DelBillProcess(model.BillSign, model.ID, tableName, model.OperaId, model.OperaName);
//if (Num == -1) {
// message = "对不起，系统出错，请联系系统管理员！";
// return false;
//}
}
if (submitFlag == 1)
{
message = "保存并提交成功！";
errMessage = procBLL.CheckSubmit(tableName, model.BillSign, model.DepId, "", model.OperaId);
if (errMessage != "")
{
message = errMessage;
return(false);
}
}
int rows = dal.Update(model);
if (rows == 0)
{
message = "对不起，该条数据已被其他人删除！";
return(false);
}
else
{
BLL.System.sys_Attachment attachmenBLL = new BLL.System.sys_Attachment();
string IDList = (model.AttachmentId_Contract == "" || model.AttachmentId_Contract == null ? "" : model.AttachmentId_Contract + ",") +
(model.AttachmentId_ControlCard == "" || model.AttachmentId_ControlCard == null ? "" : model.AttachmentId_ControlCard + ",")
;
string FileUse = "项目合同";
if (IDList != "")
{
attachmenBLL.UpdateUseList(Utils.DelLastComma(IDList), FileUse, model.ID);
}
//
if (submitFlag == 1)
{
errMessage = procBLL.SetBillProcess_Submit(tableName, model.ID.ToString(), 1, model.OperaId);
if (errMessage != "")
{
message = "保存成功,但提交失败，请联系系统管理员！";
}
}
return(true);
}
}
