public void Initialize(Object passedObj)
{
ContentParameter parameters = passedObj as ContentParameter;
CaseObject CaseObj = parameters.caseObject;
SysConfiguration SysConfig = parameters.SysConfig;
if (CaseObj.attachments.CountofType(AttachmentType.OCR) > 0)
{
LayoutInfo layoutInfo = new LayoutInfo();
layoutInfo.Name = m_Name;
if (SysConfig.WorkstationMode == "ManualCoding")
{
layoutInfo.Panel = PanelAssignment.MainPanel;
}
else
{
layoutInfo.Panel = PanelAssignment.SecondaryPanel;
}
layoutInfo.Display = new UserControl1(CaseObj);
layoutInfo.StatusItems = null;
m_UserControlDisplays.Add(layoutInfo);
m_PrintForm = new PrintForm(CaseObj);
}
else
{
throw new NotSupportedException();
}
}
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);
}
public void Initialize(Object passedObj)
{
ContentParameter parameters = passedObj as ContentParameter;
m_CaseObj = parameters.caseObject;
SysConfiguration SysConfig = parameters.SysConfig;
if (m_CaseObj.attachments.CountofType(AttachmentType.XRayImage) > 0)
{
m_XrayDisplays = new XRayDisplays(m_CaseObj, SysConfig);
m_UserControlDisplays = m_XrayDisplays.Displays;
foreach (LayoutInfo layoutInfo in m_UserControlDisplays)
{
layoutInfo.StatusItems = m_XrayDisplays.statusBarItems.StatusDisplay;
}
LayoutInfo framentDataDisplay = new LayoutInfo();
framentDataDisplay.Name = "Fragment Data";
framentDataDisplay.Panel = PanelAssignment.SecondaryPanel;
framentDataDisplay.Display = m_XrayDisplays.FragmentDataDisplay;
m_UserControlDisplays.Add(framentDataDisplay);
}
else
{
throw new NotSupportedException();
}
}
/// <summary> 删除收到/缺少资料
/// </summary>
/// <param name="delids"></param>
/// <returns></returns>
public string deldata(string delids)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addDBCondition("F_8100_01", delids, CompareType.In, "");
return(sa.delete("T_8100"));
}
public void Initialize(Object passedObj)
{
ContentParameter parameters = passedObj as ContentParameter;
if (parameters != null)
{
SysConfiguration SysConfig = parameters.SysConfig;
if (String.IsNullOrWhiteSpace(SysConfig.ContainerDBConnectionString))
{
throw new NotSupportedException();
}
CaseObject CaseObj = parameters.caseObject;
try
{
LayoutInfo layoutInfo = new LayoutInfo();
layoutInfo.Name = m_Name;
layoutInfo.Panel = PanelAssignment.InfoPanel;
layoutInfo.Display = new UserControl1(CaseObj, SysConfig);
layoutInfo.StatusItems = null;
m_UserControlDisplays.Add(layoutInfo);
m_PrintForm = new PrintForm(CaseObj);
}
catch (Exception ex)
{
throw new NotSupportedException();
}
}
else
{
throw new NotSupportedException();
}
}
public XRayDisplays(CaseObject caseObj, SysConfiguration SysConfig)
{
m_CaseObj = caseObj;
m_SysConfig = SysConfig;
m_statusBarItems = new StatusBarItems();
m_HistogramDisplay = new HistogramDisplay();
Displays = new List <LayoutInfo>();
FragmentMarkInfoList = new Collection <FragmentObject>();
m_FragmentDataDisplay = new FragmentDataDisplay(this);
foreach (DataAttachment attachment in caseObj.attachments.GetUnknownAttachments())
{
if (attachment.attachmentId == "FragmentDataTable.csv")
{
byte[] fragmentData = new byte[attachment.attachmentData.Length];
attachment.attachmentData.Read(fragmentData, 0, fragmentData.Length);
FragmentMarkInfoList = m_FragmentDataDisplay.UpdateDisplay(fragmentData);
}
}
StatusBarItem caseIDStatus = new StatusBarItem();
caseIDStatus.Content = "Case ID :" + m_CaseObj.CaseId;
m_statusBarItems.StatusDisplay.Add(caseIDStatus);
Initialize();
}
public FilterParameter(DockPanel panel, int width, int height, History history, SysConfiguration config)
{
dockPanel = panel;
Width = width;
Height = height;
History = history;
SysConfig = config;
}
private AuthenticationLevel LoginToIndividualSource(string sourceAlias, string username, string password)
{
AuthenticationLevel ret = AuthenticationLevel.None;
try
{
string wsId = m_SysConfig.GetDefaultConfig().WorkstationAlias;
UserInfo userInfo = new UserInfo(username, password);
WorkstationInfo wsInfo = new WorkstationInfo(wsId, userInfo);
LoginResponse loginResponse = m_DataSourceAccess.Login(sourceAlias, wsInfo);
ret = loginResponse.UserAuthenticationLevel;
if (!ret.Equals(AuthenticationLevel.None))
{
SysConfiguration sysConfig = new SysConfiguration();
sysConfig.ID = sourceAlias;
sysConfig.ContainerDBConnectionString = loginResponse.systemConfiguration.ContainerDBConnectString;
sysConfig.ContainerRefreshPeriodmsecs = loginResponse.systemConfiguration.ContainerRefreshPeriodSeconds * 1000;
if (m_SysConfig.Contains(sourceAlias))
{
m_SysConfig.Delete(sourceAlias);
}
m_SysConfig.Add(sysConfig);
if (m_SysConfig.UserProfileManager.Profile == null)
{
ProfileObject profile = ProfileTranslator.Translate(loginResponse.UserProfile, 4);
profile.SourceAlias = sourceAlias;
profile.UserName = wsInfo.userInfo.UserName;
profile.Password = wsInfo.userInfo.Password;
m_SysConfig.UserProfileManager.Profile = profile;
m_SysConfig.UserProfileManager.Profile.ProfileUpdatedEvent += new ProfileUpdated(ProfileUpdated);
}
DataSet caselist = null;
m_DataSourceAccess.GetCaseList(sourceAlias, out caselist);
if (caselist != null)
{
CaseListDataSet caseListDataSet = (CaseListDataSet)caselist;
caseListDataSet.CaseListTable.CaseListTableRowChanged +=
new CaseListDataSet.CaseListTableRowChangeEventHandler(CaseListTable_CaseListTableRowChanged);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(ret);
}
/// <summary>
/// 按揭资料修改
/// </summary>
/// <param name="bankdataid">按揭资料ID</param>
/// <param name="buycount">买方资料</param>
/// <param name="sellcount">卖方资料</param>
/// <param name="contrsctid">合同ID</param>
/// <param name="codetype">缺失/收到</param>
public void updatecode(string bankdataid, string buycount, string sellcount)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterString("F_8100_03", buycount, 2000, false, "");
sa.addParameterString("F_8100_04", sellcount, 2000, false, "");
sa.addParameterString("F_998", DateTime.Now.ToString(), 100, false, "");
sa.addCondition("F_8100_01", bankdataid, CompareType.Equal, LogicType.none, "");
sa.update("T_8100");
}
public UserControl1(CaseObject caseObj, SysConfiguration sysConfig)
{
InitializeComponent();
CultureResources.registerDataProvider(this);
m_CaseObj = caseObj;
m_sysConfig = sysConfig;
InfoDisplayArea.DataContext = m_CaseObj;
m_LoadedOnce = false;
}
/// <summary>
/// 添加按揭数据到 T_8057
/// </summary>
/// <param name="contactid">合同ID</param>
/// <param name="inbuycode">收到的买方资料</param>
/// <param name="insellcode">收到的卖方资料</param>
/// <param name="upbuycode">缺失的买方资料</param>
/// <param name="upsellcode">缺失的卖方资料</param>
public void insertbankcode(string contactid, string inbuycode, string insellcode, string upbuycode, string upsellcode)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterString("F_8057_80", inbuycode, 8000, false, "");
sa.addParameterString("F_8057_90", insellcode, 8000, false, "");
sa.addParameterString("F_8057_81", upbuycode, 8000, false, "");
sa.addParameterString("F_8057_91", upsellcode, 8000, false, "");
sa.addCondition("F_8057_02", contactid, CompareType.Equal, LogicType.none, "");
sa.insert("T_8057");
}
/// <summary>
/// 添加按揭数据到 T_8057
/// </summary>
/// <param name="contactid">合同ID</param>
/// <param name="inbuycode">收到的买方资料</param>
/// <param name="insellcode">收到的卖方资料</param>
/// <param name="upbuycode">缺失的买方资料</param>
/// <param name="upsellcode">缺失的卖方资料</param>
public void updatebankdata(string contactid, string inbuycode, string insellcode, string upbuycode, string upsellcode)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterString("F_8057_80", inbuycode, 8000, false, "");
sa.addParameterString("F_8057_90", insellcode, 8000, false, "");
sa.addParameterString("F_8057_81", upbuycode, 8000, false, "");
sa.addParameterString("F_8057_91", upsellcode, 8000, false, "");
sa.addCondition("F_8057_02", contactid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_8057_78", ElectroniContracType.其他.GetHashCode(), CompareType.Equal, LogicType.And, "");
sa.update("T_8057");
}
/// <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>
/// 合同ID
/// </summary>
/// <param name="contactid">合同ID</param>
/// <returns></returns>
public DataRow selbankcode(string contactid)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect("F_8057_02");
sa.addCondition("F_8057_02", contactid, CompareType.Equal, LogicType.none, "");
DataTable dt = sa.select("T_8057");
if (dt != null && dt.Rows.Count > 0)
{
return(dt.Rows[0]);
}
return(null);
}
/// <summary> 修改登陆密码
/// </summary>
/// <param name="subbranchID">支行id</param>
/// <param name="newpwd">密码</param>
public string updatePwd(string subbranchID, string newpwd, string oldpwd)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addCondition("F_0120_01", subbranchID, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_0120_10", oldpwd, CompareType.Equal, LogicType.And, "");
if (!sa.selectOne("T_0120"))
{
return("输入密码错误!");
}
sa.addParameterString("F_0120_10", newpwd, 200, false, "");
sa.update("T_0120");
return("");
}
/// <summary>
/// 根据按揭资料ID得到相应数据
/// </summary>
/// <param name="bankcodeid">按揭资料ID</param>
/// <returns></returns>
public DataRow selectbankcode(string bankcodeid)
{
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_07,F_8100_08,F_8100_09,F_991,F_992,F_993");
sa.addCondition("F_8100_01", bankcodeid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_993", 0, CompareType.Equal, LogicType.And, "");
DataTable dt = sa.select("T_8100");
if (dt != null && dt.Rows.Count > 0)
{
return(dt.Rows[0]);
}
return(null);
}
public XRayDisplays(CaseObject caseObj, SysConfiguration SysConfig)
{
m_CaseObj = caseObj;
m_SysConfig = SysConfig;
m_statusBarItems = new StatusBarItems();
m_HistogramDisplay = new HistogramDisplay();
Displays = new List <LayoutInfo>();
m_DisplayFTIError = false;
instanceID = ++AlgClientInstances.InstanceNumber;
_PxeAccess = new PxeAccess(instanceID);
caseObj.DisplayTIPEvent += new CaseObject.DisplayTIPHandler(caseObj_DisplayTIPEvent);
Initialize();
}
/// <summary> 获取资料是否齐全
/// </summary>
/// <param name="contactid"></param>
/// <param name="plan"></param>
public string getDataFull(string contactid)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect("F_8057_71");
sa.addCondition("F_8057_02", contactid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_8057_78", ElectroniContracType.其他.GetHashCode(), CompareType.Equal, LogicType.And, "");
DataTable dt = sa.select("T_8057");
if (dt == null || dt.Rows.Count < 1)
{
return("");
}
return(dt.Rows[0]["F_8057_71"].ToString());
}
public IHttpActionResult Save(SysConfiguration data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
_configurationService.Save(data);
return(Ok());
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public DataRow selectcontractinfo(string contractid)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect("F_8057_03,F_8057_13,F_8057_44,F_8057_60,F_8057_86,F_8057_40,F_8057_36,F_8057_09,F_8057_10,F_8057_11");
sa.addSelect("F_8057_74,F_8057_84,F_8057_85,F_8057_95,F_8057_96,F_8057_97,F_8057_98,F_8057_99");
sa.addCondition("F_8057_02", contractid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_8057_78", ElectroniContracType.其他.GetHashCode(), CompareType.Equal, LogicType.And, "");
DataTable dt = sa.select("T_8057");
if (dt != null && dt.Rows.Count > 0)
{
return(dt.Rows[0]);
}
return(null);
}
public void Initialize(Object passedObj)
{
ContentParameter parameters = passedObj as ContentParameter;
m_CaseObj = parameters.caseObject;
SysConfiguration SysConfig = parameters.SysConfig;
if (m_CaseObj.attachments.CountofType(AttachmentType.XRayImage) > 0)
{
m_XrayDisplays = new XRayDisplays(m_CaseObj, SysConfig);
m_UserControlDisplays = m_XrayDisplays.Displays;
}
else
{
throw new NotSupportedException();
}
}
/// <summary>
/// 按揭资料数据添加
/// </summary>
/// <param name="buycode">买方资料</param>
/// <param name="sellcode">卖方资料</param>
/// <param name="contrsctid">合同ID</param>
/// <param name="codetype">缺失/收到</param>
public void insertcode(string buycode, string sellcode, string contrsctid, string codetype)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
Guid id = Guid.NewGuid();
sa.addParameterString("F_8100_01", id.ToString(), 50, false, "");
sa.addParameterString("F_8100_02", contrsctid, 50, false, "");
sa.addParameterString("F_8100_03", buycode, 2000, false, "");
sa.addParameterString("F_8100_04", sellcode, 2000, false, "");
if (codetype != "")
{
sa.addParameterDB("F_8100_05", codetype, "");
}
sa.addParameterString("F_8100_08", DateTime.Now.ToString(), 100, false, "");
sa.addParameterString("F_992", DateTime.Now.ToString(), 100, false, "");
sa.addParameterString("F_993", "0", 10, false, "");
sa.insert("T_8100");
}
public ActionResult SubmitForm(SysConfiguration config, string permissionIds, string keyValue)
{
if (config.ConfigCode == ConstParameters.VoiceRootFolderCode)
{
if (string.IsNullOrWhiteSpace(config.ConfigValue))
{
return(Error("配置值不能为空"));
}
if (FileHelper.IsExistMapFolder(config.ConfigValue))
{
return(Error("该文件夹已存在不能为空"));
}
FileHelper.CreateDir(config.ConfigValue);
}
//_Service.SubmitForm(link, permissionIds.Split(','), keyValue);
config.Id = keyValue;
_Service.SubmitForm(config);
ConfigManager.SysConfiguration = null;
return(Success("操作成功。"));
}
public Framework(SystemManagerAccess sysMgr, SysConfigMgrAccess sysConfig) :
base()
{
initialized = false;
InitializeComponent();
CultureResources.registerDataProvider(this);
CultureResources.getDataProvider().DataChanged += new System.EventHandler(LanguageChangeControl_DataChanged);
m_SysMgr = sysMgr;
m_SysConfig = sysConfig;
m_DisplayedCases = new DisplayedCases();
SysConfiguration sysConfiguration = sysConfig.GetDefaultConfig();
VersionNumber.Text = sysConfiguration.VersionNumber;
BuildNumber.Text = sysConfiguration.BuildNumber;
BuildDate.Text = sysConfiguration.BuildDate;
m_MaxCasesOpen = (int)sysConfiguration.MaxCompareCases + 1;
}
public void Initialize(Object passedObj)
{
ContentParameter parameters = passedObj as ContentParameter;
CaseObject CaseObj = parameters.caseObject;
SysConfiguration SysConfig = parameters.SysConfig;
if (CaseObj.attachments.CountofType(AttachmentType.AnalysisHistory) > 0)
{
LayoutInfo layoutInfo = new LayoutInfo();
layoutInfo.Name = m_Name;
layoutInfo.Panel = PanelAssignment.InfoPanel;
layoutInfo.Display = new UserControl1(CaseObj);
layoutInfo.StatusItems = null;
m_UserControlDisplays.Add(layoutInfo);
}
else
{
throw new NotSupportedException();
}
}
/// <summary> 更改流程内容
/// </summary>
/// <param name="cid">合同id</param>
/// <param name="plan">进度</param>
public string updateFlow(string cid, string plan)
{
try
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterDB("F_3517_09", "getdate()", "");
sa.addParameterString("F_3517_22", "系统自动完成", 100, false, "");
sa.addParameterNumber("F_3517_18", 1, "");
sa.addCondition("F_3517_03", cid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_3517_18", 1, CompareType.NotEqual, LogicType.And, "");
if (plan == emContractSpan.资料收齐.GetHashCode().ToString())
{
sa.addCondition("F_3517_06", "备齐按揭资料", CompareType.Equal, LogicType.And, "");
}
if (plan == emContractSpan.审批通过.GetHashCode().ToString())
{
//sa.addDBCondition("F_3517_06", "'按揭审批通过领取按揭合同','商业按揭审批通过'", CompareType.In, "");
//sa.addCondition("F_3517_06", "商业按揭审批通过", CompareType.Equal, LogicType.And, "");
sa.whereAppend = " (F_3517_06 = '商业按揭审批通过' or F_3517_06 = '按揭审批通过')";
}
sa.update("T_3517");
sa.addSelect("F_3517_04");
DataTable dt = sa.@select("T_3517");
sa.whereAppend = "";
if (dt == null || dt.Rows.Count < 1)
{
return("");
}
sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterDB("F_3517_08", "DATEADD(day,1,getdate())", "");
sa.addCondition("F_3517_03", cid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_3515_07", dt.Rows[0]["F_3517_04"].ToString(), CompareType.Equal, LogicType.And, "");
return(sa.update("T_3517"));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public void Initialize(Object passedObj)
{
ContentParameter parameters = passedObj as ContentParameter;
CaseObject CaseObj = parameters.caseObject;
SysConfiguration SysConfig = parameters.SysConfig;
if (CaseObj != null)
{
LayoutInfo layoutInfo = new LayoutInfo();
layoutInfo.Name = m_Name;
layoutInfo.Panel = PanelAssignment.InfoPanel;
layoutInfo.Display = new UserControl1(CaseObj);
layoutInfo.StatusItems = ((UserControl1)layoutInfo.Display).StatusDisplay;
m_PrintForm = new PrintForm(CaseObj);
m_UserControlDisplays.Add(layoutInfo);
}
else
{
throw new NotSupportedException();
}
}
/// <summary>
/// 获取银行支行登陆信息
/// </summary>
/// <param name="subbranchid"></param>
/// <returns></returns>
public UserPrincipal getSubbranchLoginInfo(string subbranchid)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect("F_0119_02,F_0120_03,F_0120_11,F_0120_10");
sa.addCondition("F_0120_01", subbranchid.Split('|')[0], CompareType.Equal, LogicType.none, "");
DataTable bankDT = sa.select("T_0120 inner join T_0119 on F_0119_01=F_0120_02");
if (bankDT.Rows.Count > 0)
{
DataRow bankDR = bankDT.Rows[0];
UserPrincipal bankinfo = new UserPrincipal();
bankinfo.SubbranchID = subbranchid;
bankinfo.SubbranchName = bankDR["F_0119_02"].ToString() + bankDR["F_0120_03"].ToString();
//bankinfo.UserName = bankDR["F_0120_11"].ToString();
bankinfo.UserName = subbranchid.Split('|')[1];
bankinfo.Password = bankDR["F_0120_10"].ToString();
return(bankinfo);
}
return(null);
}
/// <summary> 修改合同进度
/// </summary>
/// <param name="contactid"></param>
/// <param name="plan"></param>
public string updatePlan(string contactid, string plan, string username)
{
try
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterNumber("F_8057_71", int.Parse(plan), "");
if (int.Parse(plan) == emContractSpan.已接收.GetHashCode())
{
sa.addParameterString("F_8057_87", username, 100, false, "");
sa.addParameterString("F_8057_85", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.揭办理.GetHashCode())
{
sa.addParameterString("F_8057_95", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.资料收齐.GetHashCode())
{
sa.addParameterString("F_8057_96", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.审批通过.GetHashCode())
{
sa.addParameterString("F_8057_97", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.借款合同已移交.GetHashCode())
{
sa.addParameterString("F_8057_98", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.已退件.GetHashCode())
{
sa.addParameterString("F_8057_99", DateTime.Now.ToString(), 100, false, "");
}
sa.addCondition("F_8057_02", contactid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_8057_78", ElectroniContracType.其他.GetHashCode(), CompareType.Equal, LogicType.And, "");
return(sa.update("T_8057"));
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 获取银行支行登陆信息
/// </summary>
/// <param name="subbranchid"></param>
/// <returns></returns>
public UserPrincipal getLoginInfoByBankName(string bankname, string username)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addSelect("F_0120_01,F_0119_02,F_0120_03,F_0120_11,F_0120_10");
sa.addCondition("F_0119_02", bankname, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_0120_11", "%," + username + ",%", CompareType.Like, LogicType.And, "");
DataTable bankDT = sa.select("T_0120 inner join T_0119 on F_0119_01=F_0120_02");
if (bankDT.Rows.Count > 0)
{
DataRow bankDR = bankDT.Rows[0];
UserPrincipal bankinfo = new UserPrincipal();
bankinfo.SubbranchID = bankDR["F_0120_01"].ToString();
bankinfo.SubbranchName = bankDR["F_0119_02"].ToString() + bankDR["F_0120_03"].ToString();
//bankinfo.UserName = bankDR["F_0120_11"].ToString();
bankinfo.UserName = username;
bankinfo.Password = bankDR["F_0120_10"].ToString();
return(bankinfo);
}
return(null);
}
