public string ctdgSelect_zjnb(string id, string code, string formid) { MobileQueryExtension aa = new MobileQueryExtension(); Log("资金内部方法执行成功"); IGSPDatabase db = GSPContext.Current.Database; int count = Convert.ToInt32(db.ExecuteScalar("SELECT COUNT(1) COUNT FROM XDDKHT WHERE XDDKHT_HTNM = {0}", id)); Log(count); JObject jo = new JObject(); jo["id"] = id; jo["name"] = code; //string url = String.Format("/cwbase/web/session/gspadp/AdpRuntime.aspx?formID={1}&dataID={0}&actionID=view", id, formid); //jo["url"] = String.Format("/cwbase/web/session/gsprtf/adpdebug.aspx?adpurl={0}", Uri.EscapeDataString(url)); //string url = aa.GetUrlBizApply(id,Platform.MOBILE); GSPState gspState = GSPContext.Current.Session; string gsCode = gspState.AppCode;//GS实例编号 string viewType = ViewType.原始单据.ToString(); string url = String.Format("/cwbase/webapp/gspqdp/{3}.html?viewType={4}&sysCode={0}&FormID={1}&dataid={2}", gsCode, formid, id, "PackPage", viewType); jo["url"] = String.Format("/cwbase/web/session/gsprtf/adpdebug.aspx?adpurl={0}", Uri.EscapeDataString(url)); string result = count <= 0 ? String.Empty : jo.ToString(); Log(result); return(result); }
private string GetUrlBizApply_other(string id, Platform platform, string formid) { GSPState gspState = GSPContext.Current.Session; IGSPDatabase db = GSPContext.Current.Database; string gsCode = gspState.AppCode;//GS实例编号 string page = platform.Equals(Platform.PC) ? "webbillQueryADPphone" : "PackPage"; string viewType = ViewType.原始单据.ToString(); string url = String.Format("/cwbase/webapp/gspqdp/{3}.html?viewType={4}&sysCode={0}&FormID={1}&dataid={2}", gsCode, formid, id, page, viewType); WriteLog(url, "url"); return(String.IsNullOrWhiteSpace(formid) ? String.Empty : Uri.EscapeUriString(url)); }
public string ctdgSelect_gx(string id, string code) { IGSPDatabase db = GSPContext.Current.Database; string billType = Convert.ToString(db.ExecuteScalar("SELECT MAX(FSYXDJ_DJLX) FROM FSYXDJ WHERE FSYXDJ_DJNM = {0}", id)); JObject jo = new JObject(); jo["id"] = id; jo["name"] = code; string url = String.Format("/cwbase/web/ro/ywcl/2fc63df3-0b0c-42c4-96c3-2bdee5aa0763/Index.html?isruntime=1&operation=VIEW&mode=CX&secondlatitude=SQ&firstlatitude={1}&nm={0}", id, billType); jo["url"] = String.Format("/cwbase/web/session/gsprtf/adpdebug.aspx?adpurl={0}", Uri.EscapeDataString(url)); string result = String.IsNullOrWhiteSpace(billType) ? String.Empty : jo.ToString(); return(result); }
/// <summary> /// 根据原始单据内码获取原始单据的共享联查url /// </summary> /// <param name="id">原始单据内码</param> /// <param name="platform">pc||mobile</param> /// <returns>原始单据的共享联查url</returns> public string GetUrlBizApply(string id, Platform platform) { GSPState gspState = GSPContext.Current.Session; IGSPDatabase db = GSPContext.Current.Database; string gsCode = gspState.AppCode; //GS实例编号 string formID = Convert.ToString(db.ExecuteScalar(@"WITH T1 AS (SELECT SRCCOL01, TARCOL FROM DEPVMVALUELIST WHERE VMID IN (SELECT ID FROM DEPVALUEMAPPING WHERE CODE = '2005')), T2 AS (SELECT TARCOL FROM T1 WHERE SRCCOL01 IN (SELECT ROYWSQ_SQLX FROM ROYWSQ WHERE ROYWSQ_NM = {0})) SELECT MAX(TARCOL) TARCOL FROM T2", id)); //申请类型内码映射申请单据定义内码2005 string page = platform.Equals(Platform.PC) ? "webbillQueryADPphone" : "PackPage"; string viewType = ViewType.原始单据.ToString(); string url = String.Format("/cwbase/webapp/gspqdp/{3}.html?viewType={4}&sysCode={0}&FormID={1}&dataid={2}", gsCode, formID, id, page, viewType); WriteLog(url, "url"); return(String.IsNullOrWhiteSpace(formID) ? String.Empty : Uri.EscapeUriString(url)); }
public string ctdgSelect_zccg(string id, string code, string formid) { IGSPDatabase db = GSPContext.Current.Database; int count = Convert.ToInt32(db.ExecuteScalar("SELECT COUNT(1) COUNT FROM AMCGSQ WHERE AMCGSQ_DJID = {0}", id)); JObject jo = new JObject(); jo["id"] = id; jo["name"] = code; string url = String.Format("/cwbase/web/session/gspadp/AdpRuntime.aspx?formID={1}&dataID={0}&actionID=view", id, formid); jo["url"] = String.Format("/cwbase/web/session/gsprtf/adpdebug.aspx?adpurl={0}", Uri.EscapeDataString(url)); //Log(jo["url"]); string result = count <= 0 ? String.Empty : jo.ToString(); return(result); }
// Token: 0x06000044 RID: 68 RVA: 0x00004CC8 File Offset: 0x00002EC8 private bool IsExitsTableDatas(string table, IGSPDatabase db) { bool result; try { string sqlStatement = "select count(1) from " + table; DataSet dataSet = this.database.ExecuteDataSet(sqlStatement); DataRow dataRow = dataSet.Tables[0].Rows[0]; int num = Convert.ToInt32(dataRow[0]); result = (num > 0); } catch (Exception ex) { File.AppendAllText("extablelog.txt", ex.Message); result = false; } return(result); }
/// <summary> /// 根据提供的参数信息对原始的DataSet形式的业务数据进行组装整理,返回整理后的DataSet /// </summary> /// <param name="funcID">可定义为功能ID,也可为业务上下文ID,无实际意义</param> /// <param name="bizParameter">业务参数键值对</param> /// <param name="bizData">原始业务数据</param> /// <returns>整理后的DataSet</returns> public DataSet GetBizResult(string funcID, Dictionary <string, string> bizParameter, DataSet bizData) { if (bizData != null & bizData.Tables.Contains("HTGY") && bizData.Tables["HTGY"].Rows.Count > 0) { string _htNM = Convert.ToString(bizData.Tables["HTGY"].Rows[0]["HTGY_NM"]); IGSPDatabase _db = GSPContext.Current.Database; DataSet _ds = _db.ExecuteDataSet("select HTFJ_NM,HTFJ_FJMC,HTFJ_HTNM from HTFJ where HTFJ_HTNM={0} ", _htNM); if (DataValidator.IsFirstTableHasRecord(_ds)) { AppendAttachmentInfo(bizData, _ds); return(bizData); } else { return(bizData); } } else { return(bizData); } }
public PlanDac() { db = Utils.GetDb(); }
/// <summary> /// 根据提供的参数信息对原始的DataSet形式的业务数据进行组装整理,返回整理后格式化的展示数据 /// </summary> /// <param name="funcID">可定义为功能ID,也可为业务上下文ID,无实际意义</param> /// <param name="bizParameter">业务参数键值对</param> /// <param name="bizData">原始业务数据</param> /// <returns>整理后可直接格式化展示的数据</returns> public QueryResultData GetBizFormatResult(string funcID, Dictionary <string, string> bizParameter, DataSet bizData) { GSPState gspState = GSPContext.Current.Session; IGSPDatabase db = GSPContext.Current.Database; string strSql = ""; strSql += " SELECT CTLIST_DJNM,CTLIST_TYPEID,CTLIST_DJBH, CTTYPE.CTTYPE_NAME FROM CTDGLIST "; strSql += " JOIN CTTYPE ON CTDGLIST.CTLIST_TYPEID=CTTYPE.CTTYPE_CODE"; strSql += " WHERE CTLIST_CONTRACTID = '" + bizData.Tables[0].Rows[0]["CTLIST_CONTRACTID"].ToString() + "'"; WriteLog(strSql, "ctdglist"); DataSet ds = db.ExecuteDataSet(strSql); DataTable dt = ds.Tables[0]; DataRow dr = dt.Rows[0]; string sysCode = gspState.AppCode; //GS实例编号 string ysdjid = ""; //原始单据id string urlBizApply = String.Empty;; //业务申请地址 string urlSrcAsset = String.Empty; //资产信息地址 string strSql1 = ""; DataSet ds1 = null; DataTable dt1 = null; DataRow dr1 = null; #region 根据不同合同类型获取对应的URL #region 种子采购 if (dr["CTTYPE_NAME"].ToString() == "种子采购") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 毛种子采购(初始种子) if (dr["CTTYPE_NAME"].ToString() == "毛种子采购(初始种子)") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 亲本种子采购(KWS玉米) if (dr["CTTYPE_NAME"].ToString() == "亲本种子采购(KWS玉米)") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 其它类种子采购(非库存) if (dr["CTTYPE_NAME"].ToString() == "其它类种子采购(非库存)") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 仓储合同 if (dr["CTTYPE_NAME"].ToString() == "仓储合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 营销、宣传类 if (dr["CTTYPE_NAME"].ToString() == "营销、宣传类") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 机械作业合同 if (dr["CTTYPE_NAME"].ToString() == "机械作业合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 推广展示合同 if (dr["CTTYPE_NAME"].ToString() == "推广展示合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 技术开发合同 if (dr["CTTYPE_NAME"].ToString() == "技术开发合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 运维服务合同 if (dr["CTTYPE_NAME"].ToString() == "运维服务合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 咨询服务合同 if (dr["CTTYPE_NAME"].ToString() == "咨询服务合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 务合同 if (dr["CTTYPE_NAME"].ToString() == "服务合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 其他 if (dr["CTTYPE_NAME"].ToString() == "其他") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 辅助材料采购 if (dr["CTTYPE_NAME"].ToString() == "辅助材料采购") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 运输合同 if (dr["CTTYPE_NAME"].ToString() == "运输合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 装卸合同 if (dr["CTTYPE_NAME"].ToString() == "装卸合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 品种权转让合同 if (dr["CTTYPE_NAME"].ToString() == "品种权转让合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 品种实施许可合同 if (dr["CTTYPE_NAME"].ToString() == "品种实施许可合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 合资、合作(有收付款) if (dr["CTTYPE_NAME"].ToString() == "合资、合作(有收付款)") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 招标代理合同 if (dr["CTTYPE_NAME"].ToString() == "招标代理合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 委托试验合同-双向 if (dr["CTTYPE_NAME"].ToString() == "委托试验合同-双向") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 保管合同 if (dr["CTTYPE_NAME"].ToString() == "保管合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 委托加工合同 if (dr["CTTYPE_NAME"].ToString() == "委托加工合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 在建工程项目 if (dr["CTTYPE_NAME"].ToString() == "在建工程项目") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 费用类物资采购 if (dr["CTTYPE_NAME"].ToString() == "费用类物资采购") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 技术服务合同 if (dr["CTTYPE_NAME"].ToString() == "技术服务合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 临时用工-散工 if (dr["CTTYPE_NAME"].ToString() == "临时用工-散工") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion //#region 营销、宣传类 //if (dr["CTTYPE_NAME"].ToString() == "营销、宣传类") //{ // urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); //} //#endregion #region 咨询服务合同 if (dr["CTTYPE_NAME"].ToString() == "咨询服务合同") { strSql1 += " select ROYWSQ_NM from ROYWSQ where ROYWSQ_BH ='" + dr["CTLIST_DJBH"].ToString() + "'"; WriteLog(strSql1, "ROYWSQ"); ds1 = db.ExecuteDataSet(strSql1); if (ds1.Tables[0].Rows.Count > 0) { dt1 = ds1.Tables[0]; dr1 = dt1.Rows[0]; ysdjid = Convert.ToString(dr1["ROYWSQ_NM"]); //共享单据 urlBizApply = this.GetUrlBizApply(ysdjid, Platform.MOBILE); //共享单据地址 } } #endregion #region 资产采购合同 if (dr["CTTYPE_NAME"].ToString() == "资产采购") { urlBizApply = this.GetUrlBizApply_other(dr["CTLIST_DJNM"].ToString(), Platform.MOBILE, "ca098f65-1512-4f78-8c8e-d552730f42f3");//资产单据地址 WriteLog(urlBizApply, "sdf"); } #endregion #region 资产租入合同 if (dr["CTTYPE_NAME"].ToString() == "资产租入合同") { urlBizApply = this.GetUrlBizApply_other(dr["CTLIST_DJNM"].ToString(), Platform.MOBILE, "22d9394c-5c89-4122-a574-ca492322ab0d");//资产单据地址 } #endregion #region 资产维修合同 if (dr["CTTYPE_NAME"].ToString() == "资产维修") { urlBizApply = this.GetUrlBizApply_other(dr["CTLIST_DJNM"].ToString(), Platform.MOBILE, "41000824-ec02-474f-b974-55bf8f75fa10");//资产单据地址 } #endregion #region 融资合同-内部借款 if (dr["CTTYPE_NAME"].ToString() == "融资合同-内部借款") { urlBizApply = this.GetUrlBizApply_other(dr["CTLIST_DJNM"].ToString(), Platform.MOBILE, "11446bcf-30dc-43f7-b860-54e79ff5ce3f"); } #endregion #region 融资合同-外部借款 if (dr["CTTYPE_NAME"].ToString() == "融资合同-外部借款") { urlBizApply = this.GetUrlBizApply_other(dr["CTLIST_DJNM"].ToString(), Platform.MOBILE, "11446bcf-30dc-43f7-b860-54e79ff5ce3f"); } #endregion #region 运输合同 if (dr["CTTYPE_NAME"].ToString() == "运输合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 招标代理合同 if (dr["CTTYPE_NAME"].ToString() == "招标代理合同") { } #endregion #region 营销、宣传类 if (dr["CTTYPE_NAME"].ToString() == "营销、宣传类") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 务合同 if (dr["CTTYPE_NAME"].ToString() == "服务合同") { urlBizApply = this.GetUrlBizApply(dt.Rows[0]["CTLIST_DJNM"].ToString(), Platform.MOBILE); } #endregion #region 劳动合同 if (dr["CTTYPE_NAME"].ToString() == "劳动合同") { } #endregion #region 费用类物资采购 if (dr["CTTYPE_NAME"].ToString() == "费用类物资采购") { } #endregion #region 资产租入合同 if (dr["CTTYPE_NAME"].ToString() == "资产租入合同") { } #endregion #endregion XElement ele = new XElement("ul", new XAttribute("id", "navs"), new XAttribute("data-open", "收起"), new XAttribute("data-close", "联查"), new XElement("li", new XAttribute("style", String.IsNullOrWhiteSpace(urlBizApply) ? "background-color:#c4c4c4;" : String.Empty), new XElement("a", ViewType.原始单据, new XAttribute("class", "hyperlink"), new XAttribute("href", "javascript:void(0)"), new XAttribute("onclick", String.IsNullOrWhiteSpace(urlBizApply) ? String.Empty : "gsp.rtf.func.openUrl({id:'viewBizApply',name:'原始单据',url:'" + urlBizApply + "'})")))); string ul = ele.ToString(); string html = ul + @"<script type='text/javascript'> (function(){ var ul=$('#navs'),li=$('#navs li'),i=li.length,n=1,r=120; ul.click(function(){ $(this).toggleClass('active'); var isActive = $(this).hasClass('active'); for(var a=0;a<i;a++){ var msDelayed = 50*a; var cosDisplacement = isActive ? -r*Math.cos(90/n*a*(Math.PI/180)) : 0; var sinDisplacement = isActive ? -r*Math.sin(90/n*a*(Math.PI/180)) : 0; li.eq(a).css({ 'transition-delay':''+msDelayed+'ms', '-webkit-transition-delay':''+msDelayed+'ms', '-o-transition-delay':''+msDelayed+'ms', 'transform':'translate('+cosDisplacement+'px,'+sinDisplacement+'px)', '-webkit-transform':'translate('+cosDisplacement+'px,'+sinDisplacement+'px)', '-o-transform':'translate('+cosDisplacement+'px,'+sinDisplacement+'px)', '-ms-transform':'translate('+cosDisplacement+'px,'+sinDisplacement+'px)' }); } }); })($); </script> <style type='text/css'> .hyperlink:focus{outline:none;} #navs{font-size:18px;position:fixed;right:30px;bottom:80px;width:60px;height:60px;line-height:60px;list-style-type:none;margin:0;padding:0;text-align:center;color:#fff;cursor:pointer;} #navs>li,#navs:after{position:absolute;left:0;top:0;width:100%;height:100%;border-radius:50%;-webkit-border-radius:50%;background-color:#0073c6;} #navs>li{transition:all .6s;-webkit-transition:all .6s;-moz-transition:.6s;} #navs:after{content:attr(data-close);z-index:1;border-radius:50%;-webkit-border-radius:50%;} #navs.active:after{content:attr(data-open);} #navs a{font-size:12px;width:60px;height:60px;display:inline-block;border-radius:50%;-webkit-border-radius:50%;text-decoration:none;color:#fff;} </style>"; QueryResultData resultData = new QueryResultData(); resultData.FormatID = bizParameter["WebBillQuery_Runtime_FormatID"]; //获取表单定义ID resultData.Data = JsonConvert.SerializeObject(bizData); resultData.Content = html; //此处就是你根据影像数据形成的Html片段,业务单据数据信息需要从bizData参数中获取 //resultData.Content = "<div style=\"font-size: 28px;position: fixed;right: 30px;bottom: 80px;z-index: 999;width: 60px;height: 60px;border-radius: 80%;background-color: #0073c6;text-align: center;line-height: 60px;color: #fff;-webkit-box-shadow: 0 0 1px 1px rgba(0, 0, 0, 0.24);-moz-box-shadow: 0 0 1px 1px rgba(0, 0, 0, 0.24);box-shadow: 0 0 1px 1px rgba(0, 0, 0, 0.24);-webkit-transition: -webkit-box-shadow 0.28s cubic-bezier(0.4, 0, 0.2, 1);-moz-transition: -moz-box-shadow 0.28s cubic-bezier(0.4, 0, 0.2, 1);-o-transition: -o-box-shadow 0.28s cubic-bezier(0.4, 0, 0.2, 1);transition: box-shadow 0.28s cubic-bezier(0.4, 0, 0.2, 1);cursor: pointer;\" onclick=\"gsp.rtf.func.openUrl({id:'viewgxyxxx',name:'合同信息', url:'/cwbase/webapp/gspqdp/PackPage.html?sysCode=" + sysCode + "&FormID=" + formID + "&dataid=" + dataID + "'})\">合同</div>";//此处就是你根据影像数据形成的Html片段,业务单据数据信息需要从bizData参数中获取 WriteLog(html, "html"); return(resultData); }
public PlanItemModelDac() { db = Utils.GetDb(); }
public Dac() { db = Utils.GetDb(); }
public string ctdgSelect_all(string id, string code) { Log("all方法执行成功"); Log("id=" + id + ",code=" + code); string tmp; if (code.Length >= 4) { tmp = code.Substring(0, 4).ToUpper(); Log("code=" + code); } else { return(string.Empty); } IGSPDatabase db = GSPContext.Current.Database; //tarcol:两个字母 例如:ZC GX ZJ //srccol02: ca098f65-1512-4f78-8c8e-d552730f42f3 41000824-ec02-474f-b974-55bf8f75fa10 22d9394c-5c89-4122-a574-ca492322ab0d string tarcol = Convert.ToString(db.ExecuteScalar("SELECT TARCOL FROM DEPVMVALUELIST WHERE VMID IN (SELECT ID FROM DEPVALUEMAPPING WHERE CODE = 'CT_LC' AND SRCCOL01={0})", tmp)); //string srccol02 = Convert.ToString(db.ExecuteScalar("SELECT SRCCOL02 FROM DEPVMVALUELIST WHERE VMID IN (SELECT ID FROM DEPVALUEMAPPING WHERE CODE = 'CT_LC' AND SRCCOL01={0})", tmp)); switch (tarcol) { case "GX": return(ctdgSelect_gx(id, code)); break; case "ZC": { string str = String.Empty; str = this.ctdgSelect_zccg(id, code, "ca098f65-1512-4f78-8c8e-d552730f42f3"); //调用资产采购 if (!String.IsNullOrWhiteSpace(str)) { return(str); } str = this.ctdgSelect_zcwx(id, code, "41000824-ec02-474f-b974-55bf8f75fa10"); //调用资产维修 if (!String.IsNullOrWhiteSpace(str)) { return(str); } str = this.ctdgSelect_zczr(id, code, "22d9394c-5c89-4122-a574-ca492322ab0d"); //调用资产租入 if (!String.IsNullOrWhiteSpace(str)) { return(str); } else { return(string.Empty); } #region // if (srccol02 == "ca098f65-1512-4f78-8c8e-d552730f42f3") // { // return ctdgSelect_zccg(id, code, "ca098f65-1512-4f78-8c8e-d552730f42f3"); // } // else if (srccol02 == "41000824-ec02-474f-b974-55bf8f75fa10") // { // return ctdgSelect_zcwx(id, code, "41000824-ec02-474f-b974-55bf8f75fa10"); // } // else if (srccol02 == "22d9394c-5c89-4122-a574-ca492322ab0d") // { // return ctdgSelect_zczr(id, code, "22d9394c-5c89-4122-a574-ca492322ab0d"); // } // else // { // return string.Empty; // } //}; break; #endregion } break; case "ZJ": { Log("进入case ZJ"); string str = String.Empty; str = this.ctdgSelect_zjnb(id, code, "11446bcf-30dc-43f7-b860-54e79ff5ce3f"); //调用资金内部 if (!String.IsNullOrWhiteSpace(str)) { return(str); } //str = this.ctdgSelect_zjwb(id, code, "41000824-ec02-474f-b974-55bf8f75fa10");//调用资金外部 //if (!String.IsNullOrWhiteSpace(str)) //{ // return str; //} else { return(string.Empty); } } break; default: return(string.Empty); } }
public PeriodDac(IGSPDatabase db) { this.db = db; }
public PeriodDac() { db = Utils.GetDb(); }
public PlanDac(IGSPDatabase db) { this.db = db; }
public PlanDefineDac() { db = Utils.GetDb(); }
public PlanDynamicDac() { db = Utils.GetDb(); }
public OracleDbContext(string source, string userid, string password) { _db = new OracleDatabase(GetConfigData(source, userid, password)); }