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