public List <keyValuePair> getbanklist()
{
//select * from T_0119 where F_0119_03=2 order by F_0119_04
List <keyValuePair> listKv = new List <keyValuePair>();
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect("F_0119_01,F_0119_02");
sa.addCondition("F_0119_03", 2, CompareType.Equal, LogicType.none, "");
sa.addOrder("F_0119_04", true);
DataTable bankDT = sa.select("T_0119");
if (bankDT != null && bankDT.Rows.Count > 0)
{
foreach (DataRow dr in bankDT.Rows)
{
keyValuePair kv = new keyValuePair();
kv.key = dr["F_0119_01"].ToString();
kv.value = dr["F_0119_02"].ToString();
if (!listKv.Contains(kv))
{
listKv.Add(kv);
}
}
}
return(listKv);
}
/// <summary> 获取全数据 资料拼接展示
/// </summary>
public void getFullData(string contractid, ref string ReceiveBuyHaveDatas, ref string ReceiveSellHaveDatas, ref string ReceiveBuyNoHaveDatas,
ref string ReceiveSellNoHaveDatas)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect(
"F_8100_01,F_8100_02,F_8100_03,F_8100_04,F_8100_05,F_8100_06,F_8100_07,F_8100_08,F_8100_09,F_992");
sa.addCondition("F_8100_02", contractid, CompareType.Equal, LogicType.none, "");
sa.addOrder("F_992", false);
DataTable dt = sa.select("T_8100");
List <receiveData> list_receiveData = new List <receiveData>();
foreach (DataRow dr in dt.Rows)
{
receiveData b = new receiveData();
b.id = dr["F_8100_01"].ToString();
b.cid = dr["F_8100_02"].ToString();
b.receiveBuyData = dr["F_8100_03"].ToString();
b.receiveSellData = dr["F_8100_04"].ToString();
b.DataIsReceiveOK = bool.Parse(dr["F_8100_05"].ToString());
b.remark = dr["F_8100_07"].ToString();
b.arriveTime = dr["F_8100_08"].ToString();
b.operatorName = dr["F_8100_09"].ToString();
b.inputTime = dr["F_992"].ToString();
getData(b);
list_receiveData.Add(b);
}
foreach (receiveData item in list_receiveData)
{
ReceiveBuyHaveDatas += string.IsNullOrEmpty(item.receiveBuyHaveData) ? "" : item.receiveBuyHaveData + ",";
ReceiveSellHaveDatas += string.IsNullOrEmpty(item.receiveSellHaveData) ? "" : item.receiveSellHaveData + ",";
ReceiveBuyNoHaveDatas += string.IsNullOrEmpty(item.receiveBuyNoHaveData) ? "" : item.receiveBuyNoHaveData + ",";
ReceiveSellNoHaveDatas += string.IsNullOrEmpty(item.receiveSellNoHaveData) ? "" : item.receiveSellNoHaveData + ",";
}
if (!string.IsNullOrEmpty(ReceiveBuyHaveDatas))
{
ReceiveBuyHaveDatas = ReceiveBuyHaveDatas.TrimEnd(',');
}
if (!string.IsNullOrEmpty(ReceiveSellHaveDatas))
{
ReceiveSellHaveDatas = ReceiveSellHaveDatas.TrimEnd(',');
}
if (!string.IsNullOrEmpty(ReceiveBuyNoHaveDatas))
{
ReceiveBuyNoHaveDatas = ReceiveBuyNoHaveDatas.TrimEnd(',');
}
if (!string.IsNullOrEmpty(ReceiveSellNoHaveDatas))
{
ReceiveSellNoHaveDatas = ReceiveSellNoHaveDatas.TrimEnd(',');
}
}
/// <summary>银行按揭信息详情收到按揭资料分页查询
/// </summary>
/// <param name="isHaveData"></param>
/// <returns></returns>
public List <receiveData> GetReceiveDataList(string contractid, bool isReceive, int pageIndex, int pageSize, ref int tableTotalCount)
{
List <receiveData> list_receiveData = new List <receiveData>();
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect(
"F_8100_01,F_8100_02,F_8100_03,F_8100_04,F_8100_05,F_8100_06,F_8100_07,F_8100_08,F_8100_09,F_992");
sa.addCondition("F_8100_02", contractid, CompareType.Equal, LogicType.none, "");
if (isReceive)
{
sa.addCondition("F_8100_05", 1, CompareType.Equal, LogicType.And, "");//已收到
}
else
{
sa.addCondition("F_8100_05", 0, CompareType.Equal, LogicType.And, "");//缺失
}
sa.addOrder("F_992", false);
sa.pageNow = pageIndex - 1;
sa.pageSize = pageSize;
DataTable dt = sa.selectPage("T_8100");
tableTotalCount = sa.recordCount;
sa.whereAppend = "";
if (dt == null || dt.Rows.Count == 0)
{
return(list_receiveData);
}
foreach (DataRow dr in dt.Rows)
{
receiveData b = new receiveData();
b.id = dr["F_8100_01"].ToString();
b.cid = dr["F_8100_02"].ToString();
b.receiveBuyData = dr["F_8100_03"].ToString();
b.receiveSellData = dr["F_8100_04"].ToString();
b.DataIsReceiveOK = bool.Parse(dr["F_8100_05"].ToString());
b.remark = dr["F_8100_07"].ToString();
b.arriveTime = dr["F_8100_08"].ToString();
b.operatorName = dr["F_8100_09"].ToString();
b.inputTime = dr["F_992"].ToString();
getData(b);
if (!string.IsNullOrEmpty(b.receiveBuyHaveData))
{
b.receiveBuyHaveData = b.receiveBuyHaveData.TrimEnd(',');
}
if (!string.IsNullOrEmpty(b.receiveSellHaveData))
{
b.receiveSellHaveData = b.receiveSellHaveData.TrimEnd(',');
}
if (!string.IsNullOrEmpty(b.receiveBuyNoHaveData))
{
b.receiveBuyNoHaveData = b.receiveBuyNoHaveData.TrimEnd(',');
}
if (!string.IsNullOrEmpty(b.receiveSellNoHaveData))
{
b.receiveSellNoHaveData = b.receiveSellNoHaveData.TrimEnd(',');
}
list_receiveData.Add(b);
}
return(list_receiveData);
}
/// <summary>
///
/// </summary>
/// <param name="contractNo">合约编号</param>
/// <param name="stimeR">合同签署日期</param>
/// <param name="etimeR">合同签署日期</param>
/// <param name="userName">经纪人姓名</param>
/// <param name="clientName">借款人姓名</param>
/// <param name="owenName">卖家姓名</param>
/// <param name="neiqin">内勤</param>
/// <param name="receiveName">银行接收人</param>
/// <param name="selecttype">合同状态</param>
/// <param name="paytype">付款方式</param>
/// <param name="less">是否缺失资料</param>
/// <param name="loginName"></param>
/// <param name="attr">房屋地址</param>
/// <param name="subbranchID">支行ID</param>
/// <param name="contracttypes">贷款进度</param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="tableTotalCount"></param>
/// <returns></returns>
public List <bankMortData> getbankMortList(string contractNo, string stimeR, string etimeR, string userName,
string clientName, string owenName, string neiqin, string receiveName,
string selecttype, string paytype, bool less, string loginName, string attr, string subbranchID, string contracttypes, int pageIndex, int pageSize, ref int tableTotalCount)
{
List <bankMortData> list_bankMort = new List <bankMortData>();
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect("F_8057_01,F_8057_02,F_8057_03,F_8057_13,F_8057_36,F_8057_44,F_8057_60,F_8057_61,F_8057_63");
sa.addSelect("F_8057_68,F_8057_78,F_8057_71,F_8057_79,F_8057_80,F_8057_81,F_8057_85,F_8057_88,F_8057_94,F_8057_93,F_8057_87");
sa.addCondition("F_8057_73", subbranchID.Split('|')[0], CompareType.Equal, LogicType.none, "");
sa.addCondition("F_8057_78", ElectroniContracType.其他.GetHashCode(), CompareType.Equal, LogicType.And, "");
#region 查询条件
if (!string.IsNullOrEmpty(contractNo))
{
sa.addCondition("F_8057_03", contractNo, CompareType.Equal, LogicType.And, "");
}
if (!string.IsNullOrEmpty(stimeR))
{
sa.addCondition("F_8057_12", stimeR.Replace("-", ""), CompareType.BigAndEqual, LogicType.And, "");//DateTime.Parse(stimeR).ToString("yyyyMMdd")
}
if (!string.IsNullOrEmpty(etimeR))
{
sa.addCondition("F_8057_12", etimeR.Replace("-", ""), CompareType.SmallAndEqual, LogicType.And, "");//DateTime.Parse(etimeR).AddDays(1).ToString("yyyyMMdd")
}
if (!string.IsNullOrEmpty(userName))
{
sa.addCondition("F_8057_60", "%" + userName + "%", CompareType.Like, LogicType.And, "");
}
if (!string.IsNullOrEmpty(clientName))
{
sa.addCondition("F_8057_13", "%" + clientName + "%", CompareType.Like, LogicType.And, "");
}
if (!string.IsNullOrEmpty(owenName))
{
sa.addCondition("F_8057_44", "%" + owenName + "%", CompareType.Like, LogicType.And, "");
}
if (!string.IsNullOrEmpty(attr))
{
sa.addCondition("F_8057_36", "%" + attr + "%", CompareType.Like, LogicType.And, "");
}
if (!string.IsNullOrEmpty(neiqin))
{
sa.addCondition("F_8057_93", "%" + neiqin + "%", CompareType.Like, LogicType.And, "");
}
if (!string.IsNullOrEmpty(receiveName))
{
sa.addCondition("F_8057_87", "%" + receiveName + "%", CompareType.Like, LogicType.And, "");
}
if (!string.IsNullOrEmpty(selecttype))
{
sa.addCondition("F_8057_88", selecttype, CompareType.Equal, LogicType.And, "");
}
if (string.IsNullOrEmpty(selecttype))
{
sa.addCondition("F_8057_88", DatacontarcStateEnum.已退件, CompareType.NotEqual, LogicType.And, "");
}
if (!string.IsNullOrEmpty(paytype))
{
sa.addCondition("F_8057_79", paytype, CompareType.Equal, LogicType.And, "");
}
if (!string.IsNullOrEmpty(contracttypes))
{
sa.addCondition("F_8057_71", contracttypes, CompareType.Equal, LogicType.And, "");
}
if (string.IsNullOrEmpty(contracttypes))
{
sa.addCondition("F_8057_71", emContractSpan.流程已结束, CompareType.NotEqual, LogicType.And, "");
}
if (less)
{
sa.whereAppend = "(F_8057_63 is not null or F_8057_81 is not null)";
}
#endregion 查询条件
sa.addOrder("F_8057_03", false);
sa.pageNow = pageIndex - 1;
sa.pageSize = pageSize;
DataTable dt = sa.selectPage("T_8057");
tableTotalCount = sa.recordCount;
sa.whereAppend = "";
if (dt == null || dt.Rows.Count == 0)
{
return(list_bankMort);
}
foreach (DataRow dr in dt.Rows)
{
bankMortData b = new bankMortData();
b.id = dr["F_8057_01"].ToString();
b.contractID = dr["F_8057_02"].ToString();
b.contractNo = dr["F_8057_03"].ToString();
b.clientname = dr["F_8057_13"].ToString();
b.address = dr["F_8057_36"].ToString();
b.owenname = dr["F_8057_44"].ToString();
b.username = dr["F_8057_60"].ToString();
b.usertel = dr["F_8057_61"].ToString();
b.owenInfoLack = dr["F_8057_68"].ToString();
b.clientInfoReceive = dr["F_8057_80"].ToString();
b.clientInfoLack = dr["F_8057_63"].ToString(); //工商
b.Userphone = dr["F_8057_94"].ToString(); //信贷专员电话
b.XDname = dr["F_8057_93"].ToString(); //信贷专员名字
b.receivename = dr["F_8057_87"].ToString();
emContractSpan SccetptypeS = (emContractSpan)System.Enum.Parse(typeof(emContractSpan), Convert.ToInt32(dr["F_8057_71"]).ToString());
b.Sccetptype = SccetptypeS.ToString(); //资料接收状态
b.receivetime = dr["F_8057_85"].ToString(); //接收时间
DatacontarcStateEnum displayType = (DatacontarcStateEnum)System.Enum.Parse(typeof(DatacontarcStateEnum), Convert.ToInt32(dr["F_8057_88"]).ToString());
b.contractstatu = displayType.ToString(); //合同状态
if (dr["F_8057_79"].ToString() != "")
{
empayType payType = (empayType)System.Enum.Parse(typeof(empayType), Convert.ToInt32(dr["F_8057_79"]).ToString());
b.paytype = payType.ToString(); //付款方式
}
b.clientInfoLack = dr["F_8057_81"].ToString();
//if (Convert.ToInt32(dr["F_8057_78"].ToString()) != 2)
//{
// b.clientInfoLack = dr["F_8057_81"].ToString();
//}
//else
//{
// if (!string.IsNullOrEmpty(dr["F_8057_81"].ToString()))
// {
// JavaScriptSerializer js = new JavaScriptSerializer();
// List<Items> browerItemsList = js.Deserialize<List<Items>>(dr["F_8057_81"].ToString());
// string borrowNoHaveFiles = "";
// if (browerItemsList != null && browerItemsList.Count > 0)
// {
// foreach (Items items in browerItemsList)
// {
// borrowNoHaveFiles += items.typeName + "|"; //借款人缺失资料
// }
// b.clientInfoLack += string.Format("借款人缺失资料:{0}", borrowNoHaveFiles.TrimEnd('|')); //杭州
// }
// }
//}
b.paytype = string.IsNullOrEmpty(dr["F_8057_79"].ToString())
? ""
: ((empayType)Convert.ToInt32(dr["F_8057_79"].ToString())).ToString();
list_bankMort.Add(b);
}
return(list_bankMort);
}