internal bool IsExistPlanDefineRef(string planDefineID) { if (string.IsNullOrEmpty(planDefineID)) { return(false); } var result = db.ExecuteScalar(@"select count(1) from plan where plandefineid={0}", planDefineID); return(Convert.ToInt32(result) > 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); }
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); }
public bool IsExistCustomizedModel(string planDefineID) { string sql = $@"select count(1) from planitemcustomization where plandefineid='{planDefineID}' and tenantid='{Utils.GetTenantId()}'"; return(Convert.ToInt32(db.ExecuteScalar(sql)) > 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); } }