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); }