Example #1
0
        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));
        }
Example #3
0
        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));
        }
Example #5
0
        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);
        }
Example #6
0
        // 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);
     }
 }
Example #8
0
 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);
        }
Example #10
0
 public PlanItemModelDac()
 {
     db = Utils.GetDb();
 }
Example #11
0
 public Dac()
 {
     db = Utils.GetDb();
 }
Example #12
0
        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);
            }
        }
Example #13
0
 public PeriodDac(IGSPDatabase db)
 {
     this.db = db;
 }
Example #14
0
 public PeriodDac()
 {
     db = Utils.GetDb();
 }
Example #15
0
 public PlanDac(IGSPDatabase db)
 {
     this.db = db;
 }
Example #16
0
 public PlanDefineDac()
 {
     db = Utils.GetDb();
 }
Example #17
0
 public PlanDynamicDac()
 {
     db = Utils.GetDb();
 }
Example #18
0
 public OracleDbContext(string source, string userid, string password)
 {
     _db = new OracleDatabase(GetConfigData(source, userid, password));
 }