/// <summary>
/// 业务统计
/// </summary>
/// <param name="ApplyDateStart">申请开始时间</param>
/// <param name="ApplyDateEnd">申请结束时间</param>
/// <param name="Province">省</param>
/// <param name="PageSize">每页输出的记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="TotalCount">记返回总记录</param>
public static DataSet GetP_Business_Statistics(string ApplyDateStart, string ApplyDateEnd, string Province, int PageSize, int PageIndex, out int TotalCount)
{
TotalCount = int.MinValue;
Common_BLL ComBLL = new Common_BLL();
List <ParameterModel> ParameterModel = new List <ParameterModel>();
List <ParameterModel> ParameterList = new List <ParameterModel>();
ParameterList.Add(new ParameterModel {
ParamName = "ApplyDateStart", ParamValue = ApplyDateStart, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterList.Add(new ParameterModel {
ParamName = "ApplyDateEnd", ParamValue = ApplyDateEnd, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterList.Add(new ParameterModel {
ParamName = "Province", ParamValue = Province, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterList.Add(new ParameterModel {
ParamName = "PageSize", ParamValue = PageSize, ParamMode = ParamEnumMode.InMode, ParamType = DbType.Int32
});
ParameterList.Add(new ParameterModel {
ParamName = "PageIndex", ParamValue = PageIndex, ParamMode = ParamEnumMode.InMode, ParamType = DbType.Int32
});
ParameterList.Add(new ParameterModel {
ParamName = "TotalCount", ParamValue = TotalCount, ParamMode = ParamEnumMode.OutMode, ParamType = DbType.Int32
});
ParameterModel.Add(new ParameterModel {
ParamName = "TotalCount", ParamValue = TotalCount, ParamMode = ParamEnumMode.OutMode, ParamType = DbType.Int32
});
return(ComBLL.ExecStoredProcedures(new StoredProcModel {
ProcName = "P_Business_Statistics", ParameterList = ParameterList
}, out ParameterModel));
}
/// <summary>
/// 发送短信
/// </summary>
/// <param name="UserName">客户名称</param>
/// <param name="Phone">手机号码</param>
/// <param name="Content">
/// Content说明：放款提醒格式：
/// 客户名称,业务申请显示编号还款提醒格式：
/// 客户名称,还款日期（日）逾期提醒格式：
/// 客户名称,还款期数,还款日期（月日）,逾期天数
/// </param>
/// <param name="Model">Model说明：
/// LoanSMSTemplate：财务放款短信模板；
/// RepaymentSMS：还款提醒短信模板；
/// BeOverdueSMS：逾期短信提醒模板；
/// </param>
/// <param name="IsAuto">是否自动手动（flase：手动 true： 自动）</param>
public static void GetP_Msg_SendSMS(string UserName, string Phone, string Content, string Model, bool IsAuto)
{
Common_BLL ComBLL = new Common_BLL();
List <ParameterModel> ParameterModel = null;
List <ParameterModel> ParameterList = new List <ParameterModel>();
ParameterList.Add(new ParameterModel {
ParamName = "UserName", ParamValue = UserName, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterList.Add(new ParameterModel {
ParamName = "Phone", ParamValue = Phone, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterList.Add(new ParameterModel {
ParamName = "Content", ParamValue = Content, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterList.Add(new ParameterModel {
ParamName = "Model", ParamValue = Model, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterList.Add(new ParameterModel {
ParamName = "IsAuto", ParamValue = IsAuto, ParamMode = ParamEnumMode.InMode, ParamType = DbType.Boolean
});
ComBLL.ExecStoredProcedures(new StoredProcModel {
ProcName = "P_Msg_SendSMS", ParameterList = ParameterList
}, out ParameterModel);
}
public static void GetP_Business_SystemEvaluate(string ApplyId)
{
Common_BLL ComBLL = new Common_BLL();
List <ParameterModel> ParameterModel = null;
List <ParameterModel> ParameterList = new List <ParameterModel>();
ParameterList.Add(new ParameterModel {
ParamName = "ApplyBasicID", ParamValue = ApplyId, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ComBLL.ExecStoredProcedures(new StoredProcModel {
ProcName = "P_Business_SystemEvaluate", ParameterList = ParameterList
}, out ParameterModel);
}
/// <summary>
/// 流水
/// </summary>
/// <param name="ApplyBasisId">业务ID</param>
/// <param name="Number">前缀名称编号</param>
/// <param name="ContractNO">返回的流水编号</param>
public static void GetP_ContractLS(string ApplyBasisId, string Number, out string ContractNO)
{
ContractNO = string.Empty;
Common_BLL ComBLL = new Common_BLL();
List <ParameterModel> ParameterModel = new List <ParameterModel>();
List <ParameterModel> ParameterList = new List <ParameterModel>();
ParameterList.Add(new ParameterModel {
ParamName = "ApplyBasisId", ParamValue = ApplyBasisId, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterList.Add(new ParameterModel {
ParamName = "Number", ParamValue = Number, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ParameterModel.Add(new ParameterModel {
ParamName = "ContractNO", ParamValue = ContractNO, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
ComBLL.ExecStoredProcedures(new StoredProcModel {
ProcName = "P_ContractLS", ParameterList = ParameterList
}, out ParameterModel);
}
/// <summary>
/// 查询数据库中和Session中的附件
/// </summary>
/// <param name="context"></param>
public void DataFilseSelect(HttpContext context)
{
Regex r = new Regex(@"[\u4e00-\u9fa5]+");
string OperationID = context.Request.QueryString["OperationID"]; //业务ID
string FileType = context.Request.QueryString["FileType"]; //附件的类型
string SessionID = context.Request.QueryString["SessionID"]; //SessionID
string type = context.Request.QueryString["type"]; //类型1：未归类
string productType = context.Request.QueryString["ProductType"]; //业务类别（个人、企业）
string str = "";
if (!string.IsNullOrEmpty(FileType))
{
FileType = HttpUtility.UrlDecode(FileType);
}
if (!string.IsNullOrEmpty(OperationID) || SessionID != "")
{
List <Sys_ModelFile> ModelFilelist = null;
if (context.Session[SessionID] == null)
{
ModelFilelist = new List <Sys_ModelFile>();
}
else
{
ModelFilelist = context.Session[SessionID] as List <Sys_ModelFile>;
}
str += "[";
List <Sys_ModelFile> filelist = null;
Sys_ModelFileBLL modelfile = new Sys_ModelFileBLL();
if (string.IsNullOrEmpty(FileType))
{
filelist = modelfile.GetList(p => p.File_OperationID == OperationID).OrderBy(a => a.File_AddTime).ToList();
}
else
{
string filetypes = "";
Sys_UploadDataTypeBLL upBll = new Sys_UploadDataTypeBLL();
List <Sys_UploadDataType> chlist = upBll.GetList(p => p.UploadDataType_TypeCode == FileType || p.UploadDataType_ProcessStage == FileType).ToList();
if (chlist.Count > 0)
{
for (int i = 0; i < chlist.Count; i++)
{
filetypes += chlist[i].UploadDataType_TypeCode;
}
}
if (FileType == Constant.fileType7)
{
filetypes = FileType;
}
else if (FileType == Constant.Classification)
{
filetypes = FileType;
}
if (FileType == "0")
{
ModelFilelist = ModelFilelist.FindAll(p => !filetypes.Contains(p.File_Type));
}
else
{
if (FileType == Constant.Classification)
{
string lb = "";
Common_BLL ComBLL = new Common_BLL();
List <ParameterModel> ParameterModel = null;
List <ParameterModel> ParameterList = new List <ParameterModel>();
ParameterList.Add(new ParameterModel {
ParamName = "ProductType", ParamValue = productType, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
DataSet ds = ComBLL.ExecStoredProcedures(new StoredProcModel {
ProcName = "P_GetUploadDataType", ParameterList = ParameterList
}, out ParameterModel);
int cout = ds.Tables[0].Rows.Count;
for (int j = 0; j < cout; j++)
{
lb += ds.Tables[0].Rows[j][0].ToString();
}
ModelFilelist = ModelFilelist.FindAll(p => filetypes.Contains(p.File_Type) || lb.Contains(p.File_Type)).OrderBy(a => a.File_AddTime).ToList();
}
else
{
ModelFilelist = ModelFilelist.FindAll(p => filetypes.Contains(p.File_Type) || p.File_Type == FileType).OrderBy(a => a.File_AddTime).ToList();
}
}
if (FileType == Constant.Classification)
{
string lb = "";
Common_BLL ComBLL = new Common_BLL();
List <ParameterModel> ParameterModel = null;
List <ParameterModel> ParameterList = new List <ParameterModel>();
ParameterList.Add(new ParameterModel {
ParamName = "ProductType", ParamValue = productType, ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
DataSet ds = ComBLL.ExecStoredProcedures(new StoredProcModel {
ProcName = "P_GetUploadDataType", ParameterList = ParameterList
}, out ParameterModel);
int cout = ds.Tables[0].Rows.Count;
for (int j = 0; j < cout; j++)
{
lb += ds.Tables[0].Rows[j][0].ToString();
}
filelist = modelfile.GetList(p => p.File_OperationID == OperationID && p.File_Type == FileType).OrderBy(a => a.File_AddTime).ToList();
}
else
{
filelist = modelfile.GetList(p => p.File_OperationID == OperationID && (filetypes.Contains(p.File_Type) || p.File_Type == FileType)).OrderBy(a => a.File_AddTime).ToList();// || p.File_Type == FileType
}
}
foreach (Sys_ModelFile file in ModelFilelist)
{
string filename2 = file.File_Name;
if (filename2.Length > 9)
{
Match mc = r.Match(filename2);
Match mt = r.Match(file.File_Type);
if (mc.Length != 0) //
{
if (mt.Length != 0 && file.File_Type != Constant.fileType7)
{
filename2 = filename2.Substring(0, 7) + "..(未归类)";
}
else
{
filename2 = filename2.Substring(0, 9) + "..";
}
}
else
{
if (mt.Length != 0 && file.File_Type != Constant.fileType7)
{
filename2 = filename2.Substring(0, 9) + "..(未归类)";
}
else
{
filename2 = filename2.Substring(0, 9) + "..";
}
}
}
else
{
Match mt = r.Match(file.File_Type);
if (mt.Length != 0 && file.File_Type != Constant.fileType7)
{
filename2 = filename2 + "(未归类)";
}
}
str += "{\"id\":\"" + file.FileID + "\",\"filename\":\"" + file.File_Name + "\",\"filesize\":\"\",\"uploaddate\":\"" + Convert.ToDateTime(file.File_AddTime).ToString("yyyy年MM月dd日") + "\",\"fileUrl\":\"" + file.File_Path + "\",\"filetitle\":\"" + filename2 + "\"},";
}
foreach (Sys_ModelFile file in filelist)
{
string fileContentLength = fileSizs(Convert.ToInt32(file.File_Size));
string filename2 = file.File_Name;
if (filename2.Length > 9)
{
Match mc = r.Match(file.File_Type);
if (mc.Length != 0 && file.File_Type != Constant.fileType7) //类别中含有汉字
{
filename2 = filename2.Substring(0, 7) + "(未归类)";
}
else
{
filename2 = filename2.Substring(0, 9) + "..";
}
}
else
{
Match mc = r.Match(file.File_Type);
if (mc.Length != 0 && file.File_Type != Constant.fileType7) //类别中含有汉字
{
filename2 = filename2 + "(未归类)";
}
}
str += "{\"id\":\"" + file.FileID + "\",\"filename\":\"" + file.File_Name + "\",\"filesize\":\"" + fileContentLength + "\",\"uploaddate\":\"" + Convert.ToDateTime(file.File_AddTime).ToString("yyyy年MM月dd日") + "\",\"fileUrl\":\"" + file.File_Path + "\",\"filetitle\":\"" + filename2 + "\"},";
}
if (str.Length > 1)
{
str = str.Substring(0, str.Length - 1);
}
str += "]";
context.Response.Write(str);
}
}
protected void Show()
{
List <Sys_UploadDataType> typeList = updateTypeBll.FindWhere(" UploadDataType_IsDelete='0'").OrderBy(p => p.UploadDataType_SortNo).ToList();
//使用存储过程查看
Common_BLL ComBLL = new Common_BLL();
List <ParameterModel> ParameterModel = null;
List <ParameterModel> ParameterList = new List <ParameterModel>();
ParameterList.Add(new ParameterModel {
ParamName = "ProductType", ParamValue = "2801", ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
DataSet ds = ComBLL.ExecStoredProcedures(new StoredProcModel {
ProcName = "P_GetUploadDataType", ParameterList = ParameterList
}, out ParameterModel);
List <ParameterModel> ParameterModel2 = null;
List <ParameterModel> ParameterList2 = new List <ParameterModel>();
ParameterList2.Add(new ParameterModel {
ParamName = "ProductType", ParamValue = "2802", ParamMode = ParamEnumMode.InMode, ParamType = DbType.String
});
DataSet ds2 = ComBLL.ExecStoredProcedures(new StoredProcModel {
ProcName = "P_GetUploadDataType", ParameterList = ParameterList2
}, out ParameterModel2);
string str1 = "";
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
List <Sys_UploadDataType> typeList1 = typeList.FindAll(p => p.UploadDataType_ProductType == "2801" && p.UploadDataType_ProcessStage == ds.Tables[0].Rows[j][0].ToString());
for (int i = 0; i < typeList1.Count; i++)
{
str1 += "<tr>";
str1 += "<td style=\"text-align:center;\">" + typeList1[i].UploadDataType_ProcessStage + "</td>";
str1 += "<td><input type=\"text\" id=\"txtTypeName" + i + "\" maxlength=\"50\" class=\"required validate[required]\" style=\"text-align: center; width:100%;\" value=\"" + typeList1[i].UploadDataType_Name + "\" /></td>";
str1 += "<td><input type=\"text\" id=\"txtCode" + i + "\" maxlength=\"20\" class=\"required validate[required]\" value=\"" + typeList1[i].UploadDataType_TypeCode + "\" /></td>";
str1 += "<td><input type=\"text\" id=\"txtCode" + i + "\" maxlength=\"120\" style=\"width:100%;\" value=\"" + typeList1[i].UploadDataType_DataType + "\" /></td>";
str1 += "<td style=\"display:none;\"><input type=\"text\" id=\"txtID" + i + "\" value=\"" + typeList1[i].UploadDataType_ID + "\" /></td>";
str1 += "<td style=\"text-align:center;\"><a onclick=\"deleteRow(this)\" title=\"删除\"><img src=\"../../Images/buttons/cancel.png\" /></a></td>";
str1 += "</tr>";
}
}
this.LitContent1.Text = str1;
string str2 = "";
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
List <Sys_UploadDataType> typeList2 = typeList.FindAll(p => p.UploadDataType_ProductType == "2802" && p.UploadDataType_ProcessStage == ds.Tables[0].Rows[j][0].ToString());
for (int i = 0; i < typeList2.Count; i++)
{
str2 += "<tr>";
str2 += "<td style=\"text-align:center;\">" + typeList2[i].UploadDataType_ProcessStage + "</td>";
str2 += "<td><input type=\"text\" id=\"txtTypeName" + i + "\" maxlength=\"50\" class=\"required validate[required]\" style=\"text-align: center; width:100%;\" value=\"" + typeList2[i].UploadDataType_Name + "\" /></td>";
str2 += "<td><input type=\"text\" id=\"txtCode" + i + "\" maxlength=\"20\" class=\"required validate[required]\" value=\"" + typeList2[i].UploadDataType_TypeCode + "\" /></td>";
str2 += "<td><input type=\"text\" id=\"txtDataType" + i + "\" maxlength=\"120\" style=\"width:100%;\" value=\"" + typeList2[i].UploadDataType_DataType + "\" /></td>";
str2 += "<td style=\"display:none;\"><input type=\"text\" id=\"txtID" + i + "\" value=\"" + typeList2[i].UploadDataType_ID + "\" /></td>";
str2 += "<td style=\"text-align:center;\"><a onclick=\"deleteRow(this)\" title=\"删除\"><img src=\"../../Images/buttons/cancel.png\" /></a></td>";
str2 += "</tr>";
}
}
this.LitContent2.Text = str2;
}