protected void BindData()
{
string Sql = "[dbo].[RightsSetList] " + RightsResID + ",'" + ObjectID.Trim() + "'";
string[] changePassWord = Common.getChangePassWord();
DataSet ds = Resource.SelectData(Sql, changePassWord[0], changePassWord[1], changePassWord[2]);
dlRights.DataSource = ds.Tables[0];
dlRights.DataBind();
if (ds.Tables.Count > 1)
{
dlRights1.DataSource = ds.Tables[1];
dlRights1.DataBind();
dlRights2.DataSource = ds.Tables[2];
dlRights2.DataBind();
if (ds.Tables[3].Rows.Count > 0)
{
IsRowRihgt = true;
}
}
ds = Resource.SelectData("select ChildNum 子表配置号 ,ShowTitle 显示标题 ,MasterKeyWord 主表关键字 ,ChildKeyWord 子表关键字 ,RSResID 主表资源ID ,ChildResId 子表资源ID , ChildOrderNo 子表排序号 from MasterTableAssociation where MasterKeyWord in (select Res_Comments from CMS_RESOURCE where IsNull(SHOW_ENABLE,0)=1 and ID=" + CommonMethod.FilterSql(RightsResID) + ")", changePassWord[0], changePassWord[1], changePassWord[2]);
repChildRes.DataSource = ds.Tables[0];
repChildRes.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
LoadScript("");
UserID = CurrentUser.ID;
if (CurrentUser.DepartmentName != "系统管理员" && CurrentUser.ID != "sysuser")
{
Response.Redirect("../../login.aspx", true);
return;
}
if (Request.QueryString["SearchType"] != null)
{
SearchType = Request.QueryString["SearchType"].ToString();
}
if (Request.QueryString["NodeID"] != null)
{
NodeID = Request.QueryString["NodeID"].ToString();
}
WebServices.Services Resource = new WebServices.Services();
ResID = Resource.GetResourceIDByTableName("SysSettings");
string strSql = " select RT_TAB1_RESID ResID,'ListConfig' keyWordValue ,RT_TAB2_RESID ChildResID,Res.NAME ChildResName,(D1.CD_DISPNAME+'='+D2.CD_DISPNAME) 主子表关联字段 FROM [CMS_RELATED_TABLE] R " +
" Join CMS_RESOURCE Res on R.RT_TAB2_RESID=Res.ID" +
" join CMS_TABLE_DEFINE D1 on D1.CD_RESID=R.RT_TAB1_RESID and D1.CD_COLNAME=R.RT_TAB1_COLNAME " +
" join CMS_TABLE_DEFINE D2 on D2.CD_RESID=R.RT_TAB2_RESID and D2.CD_COLNAME=R.RT_TAB2_COLNAME " +
" where RT_TAB1_RESID=" + ResID + " order by RT_SHOWORDER";
string[] changePassWord = Common.getChangePassWord();
DataTable TableList = Resource.SelectData(strSql, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
RepTabList.DataSource = TableList;
RepTabList.DataBind();
}
private string GetDataByWGJKHTS()
{
WebServices.Services Resource = new WebServices.Services();
string str = "";
DataTable dt = new DataTable();
string Condition = Request["Condition"];
string Seaxs = Request["Seaxs"];
string sql = "select C3_401291000526 客户全称 ,C3_551182758185 分配 from CT401290367151 ";
sql += " WHERE isnull(C3_551182775673,'1900-01-01') <dateadd(month,-2,GETDATE()) ";
sql += " and isnull(C3_551182786094,'1900-01-01') <dateadd(month,-6,GETDATE()) ";
if (Seaxs != "" && Seaxs != null)
{
sql += " and C3_401291000526 like '%" + Seaxs + "%'";
}
if (Condition != "")
{
sql += Condition;
}
sql += " order by C3_551182758185 asc,C3_401291000526 asc";
string[] changePassWord = Common.getChangePassWord();
dt = Resource.SelectData(sql, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd";
str = Newtonsoft.Json.JsonConvert.SerializeObject(dt, timeConverter);
return(str);
}
void BindData()
{
string strSql = "select T.*,(Case when IsNull(S.ID,0)=0 then CD_DISPNAME else S.ShowColumnName end) CD_ShowName,(Case when IsNull(S.ID,0)=0 then 0 else 1 end) IsBe from (SELECT [CD_ID],[CD_RESID],[CD_COLNAME],[CD_DISPNAME],[CS_SHOW_ORDER],(case CD_Type when 1 then 'nvarchar' when 2 then 'float' when 3 then 'int' when 4 then 'datetime' when 5 then 'ntext' when 6 then 'image' when 7 then 'money' when 8 then 'datetime' when 9 then 'bit' when 10 then 'ntext' end) DataType FROM [CMS_TABLE_DEFINE] D join [CMS_TABLE_SHOW] S on D.CD_COLNAME=S.CS_COLNAME and D.CD_RESID=S.CS_RESID where CD_RESID in (select (case when IsNull(RES_USE_PARENTSHOW,0)=1 then PID else ID end) from CMS_RESOURCE where id=" + RelatedResID.Trim() + ") and CD_Type<>6) T left join (select ColumnName,ShowColumnName,ID from ResourceColumn where KeyWord='" + RelatedValue.Trim() + "') S on S.ColumnName=T.CD_DISPNAME order by CS_SHOW_ORDER ";
string[] changePassWord = Common.getChangePassWord();
DataTable dt = Resource.SelectData(strSql, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
dlCol.DataSource = dt;
dlCol.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
UserID = CurrentUser.ID;
UserName = CurrentUser.Name;
keywordParameters = Request.QueryString["key"];
if (keywordParameters == "XTTS")
{
//待办事宜
string[] changePassWord = Common.getChangePassWord();
DataTable sql = Resource.SelectData(" select id,FLOWNAME 流程,MAINFIELDVALUE 主题,CREATORNAME 来源,CREATETIME 时间,flowinstid 流程RecID,id 流程ID from VIEW_WF_RECEIVEFILES WHERE EMPCODE='" + UserID + "' ", changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
DataView dv_DBSYtable = sql.DefaultView;
dv_DBSYtable.Sort = " 时间 Desc";
DataTable dt2_DBSYtable = dv_DBSYtable.ToTable();
RepeaterDBLX.DataSource = dt2_DBSYtable;
RepeaterDBLX.DataBind();
}
}
void BindData()
{
long ResID = Resource.GetTopParentID(NodeID);
string strSql = "select T.*,(Case when IsNull(Col.ID,0)=0 then CD_DISPNAME else Col.ShowColumnName end) CD_ShowName,IsNull(Col.OrderNum,0) OrderNum,(Case when IsNull(Col.ID,0)=0 then 0 else 1 end) IsBe from(SELECT [CD_ID],[CD_RESID] ,[CD_COLNAME],[CD_DISPNAME],(case CD_Type when 1 then 'nvarchar' when 2 then 'float' when 3 then 'int' when 4 then 'datetime' when 5 then 'ntext' when 6 then 'image' when 7 then 'money' when 8 then 'datetime' when 9 then 'bit' when 10 then 'ntext' end) DataType,CS_SHOW_ORDER FROM [CMS_TABLE_DEFINE] D join [CMS_TABLE_SHOW] S on D.CD_COLNAME=S.CS_COLNAME and D.CD_RESID=S.CS_RESID where CD_RESID in (" + ResID + "))T left join (select R.ID,R.ColumnName,R.ShowColumnName,R.OrderNum from SysSettings S join ResourceColumn R on S.ENKeyWord=R.KeyWord where S.id=" + RecID + ")Col on Col.ColumnName=T.CD_DISPNAME order by IsBe desc, OrderNum , CS_SHOW_ORDER;" +
" select * from (select KeyWord, SearchCol=stuff((select ','+SearchCol from Sys_CXZJLB t where KeyWord=t.KeyWord and KeyWord in (select ENKeyWord from dbo.SysSettings where id=" + RecID + ") for xml path('')), 1, 1, '') from Sys_CXZJLB group by KeyWord) tab ";
string[] changePassWord = Common.getChangePassWord();
DataSet ds = Resource.SelectData(strSql, changePassWord[0], changePassWord[1], changePassWord[2]);
DataTable dt = ds.Tables[0];
dlCol.DataSource = dt;
dlCol.DataBind();
if (ds.Tables[1].Rows.Count > 0)
{
DataRow dr = ds.Tables[1].Rows[0];
SearchCol = DbField.GetStr(ref dr, "SearchCol");
}
}
public static MasterTableAssociation GetChileMasterTableAssociation(string argFatherKey, string argChileKey, string argTZ, string argMasterTableAssociationID)
{
MasterTableAssociation child = null;
WebServices.Services Resource = new WebServices.Services();
string[] changePassWord = Common.getChangePassWord();
DataTable vdt = Resource.SelectData("select * from MasterTableAssociation where id = '" + argMasterTableAssociationID + "'", changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
if (vdt == null && vdt.Rows.Count == 0)
{
return(child);
}
DataRow vDr = vdt.Rows[0];
child = new MasterTableAssociation()
{
MID = vDr["id"].ToString(),
MasterKeyWord = vDr["MasterKeyWord"].ToString(),
ChildKeyWord = vDr["ChildKeyWord"].ToString(),
ChildOrderNo = string.IsNullOrEmpty(vDr["ChildOrderNo"].ToString()) ? 10 : Convert.ToInt32(vDr["ChildOrderNo"].ToString()),
AllowAdd = Convert.ToBoolean(vDr["AllowAdd"].ToString() == "1"),
AllowEdit = Convert.ToBoolean(vDr["AllowEdit"].ToString() == "1"),
AllowDel = Convert.ToBoolean(vDr["AllowDel"].ToString() == "1"),
AllowExport = Convert.ToBoolean(vDr["AllowExport"].ToString() == "1"),
TZType = vDr["TZType"].ToString(),
LedgerConditions = vDr["LedgerConditions"].ToString(),
LedgerChildKey = vDr["LedgerChildKey"].ToString(),
RSResID = vDr["RSResID"].ToString(),
ChildResId = vDr["ChildResId"].ToString(),
DefaultSort = vDr["DefaultSort"].ToString(),
InitialQueryStr = vDr["InitialQueryStr"].ToString(),
HasLastOperation = Convert.ToBoolean(vDr["HasLastOperation"].ToString() == "1"),
HasFirstOperation = Convert.ToBoolean(vDr["HasFirstOperation"].ToString() == "1"),
ViewDepartment = vDr["ViewDepartment"].ToString(),
NoViewDepartment = vDr["NoViewDepartment"].ToString(),
ViewAccount = vDr["ViewAccount"].ToString(),
NoViewAccount = vDr["NoViewAccount"].ToString(),
ViewBaseTableResid = vDr["ViewBaseTableResid"].ToString()
};
return(child);
}
private string GetDataByWGJKHTX()
{
WebServices.Services Resource = new WebServices.Services();
string str = "";
DataTable dt = new DataTable();
string sql = "select C3_404495328556 客户全称,C3_423050441017 销售 from CT401290331886 WHERE C3_404495328556 NOT IN ( ";
sql += " select C3_480524157728 from CT480524075049 WHERE C3_480524183775 BETWEEN '" + DateTime.Now.AddMonths(-3).ToString("yyyy-MM-dd") + "' AND GETDATE()) ";
if (Request["Seaxs"] != null && Request["Seaxs"].ToString() != "")
{
sql += " and C3_423050441017 like '%" + Request["Seaxs"].ToString() + "%'";
}
sql += " GROUP BY C3_404495328556 ,C3_423050441017 ORDER BY C3_423050441017 ";
string[] changePassWord = Common.getChangePassWord();
dt = Resource.SelectData(sql, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd";
str = Newtonsoft.Json.JsonConvert.SerializeObject(dt, timeConverter);
return(str);
}
private string GetDataByFDDXM()
{
WebServices.Services Resource = new WebServices.Services();
string str = "";
DataTable dt = new DataTable();
string seaBegDate = Request["seaBegDate"];
string seaEndDate = Request["seaEndDate"];
if (seaBegDate != null && seaBegDate != "" && seaEndDate != null && seaEndDate != "")
{
string sql = "SELECT C3_316013848869 督导, COUNT(C3_285435595640) 累计新开项目, SUM(CASE WHEN ISNULL(C3_285435594890,0)=0 THEN 1 ELSE 0 END) 累计未确认项目,";
sql += " SUM(CASE WHEN ISNULL(C3_285435594890,0)<>0 AND ISNULL(C3_332437985389,0)=0 THEN 1 ELSE 0 END) 累计已确认未开票项目";
sql += " from CT285435593984 WHERE C3_285435594453 BETWEEN '" + Convert.ToDateTime(seaBegDate).ToString("yyyy-MM-dd") + "' AND '" + Convert.ToDateTime(seaEndDate).ToString("yyyy-MM-dd") + "' GROUP BY C3_316013848869";
string[] changePassWord = Common.getChangePassWord();
dt = Resource.SelectData(sql, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd";
str = Newtonsoft.Json.JsonConvert.SerializeObject(dt, timeConverter);
}
return(str);
}
public void Bind()
{
string resID = CommonProperty.PortalResourceID;
WebServices.ResourceInfo[] ResourceInfo = null;
WebServices.Services Resource = new WebServices.Services();
string[] changePassWord = Common.getChangePassWord();
DataTable dt = Resource.SelectData("select Count(1) from VIEW_WF_RECEIVEFILES WHERE EMPCODE='" + oUserInfo.ID + "'", changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
if (dt.Rows.Count > 0)
{
DBSXNum = dt.Rows[0][0].ToString();
}
//获取一级导航菜单列表，如果是管理员则显示所有菜单
if (CurrentUser.DepartmentName.Trim() == CommonProperty.ManageDepartmentName.Trim())
{
ResourceInfo = document.GetNextDirectoryList(resID);
}
else
{
ResourceInfo = document.GetNextPortalTreeRootByResourceIDAndUserID(oUserInfo.ID, resID);
}
if (ResourceInfo != null && ResourceInfo.Length > 0)
{
//获取第一个菜单ID
resourceInfoID = ResourceInfo[0].ID;
//获取第一个菜单Title
resourceInfoTitle = ResourceInfo[0].Name;
this.titleRepeater.DataSource = ResourceInfo;
titleRepeater.DataBind();
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "js", "alert('该用户还没有分配任务权限，请先找管理员分配权限！');window.location.href='../login.aspx'", true);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//DataTable dt =
WebServices.Services services = new WebServices.Services();
string[] changePassWord = Common.getChangePassWord();
DataTable dt = services.SelectData("select * from CMS_EMPLOYEE order by Emp_Name", changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
string pass = "";
try
{
pass = NetReusables.CmsEncrypt.DecryptPassword(dt.Rows[i]["EMP_PASS"].ToString());
}
catch (Exception)
{
pass = NetReusables.Encrypt.Decrypt(dt.Rows[i]["EMP_PASS"].ToString()) + "(已更新)";
}
dt.Rows[i]["EMP_PASS"] = pass;
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (SelectRecords_Model != null)
{
SetValueResID = SelectRecords_Model.SetValueResID;
SelectfieldValue = SelectRecords_Model.SelectfieldValue;
ResID_Key = SelectRecords_Model.ResID_Key;
HasLastOperation = SelectRecords_Model.HasLastOperation;
HasFirstOperation = SelectRecords_Model.HasFirstOperation;
QueryKeyField = SelectRecords_Model.QueryKeyField;
UserDefinedSql = SelectRecords_Model.UserDefinedSql;
keyWordValue = SelectRecords_Model.keyWordValue;
ColumnName = SelectRecords_Model.ColumnName;
PageSize = SelectRecords_Model.PageSize <= 0 ? 1 : SelectRecords_Model.PageSize;
PageNumber = SelectRecords_Model.PageNumber <= 0 ? 20 : SelectRecords_Model.PageNumber;;
SearchType = SelectRecords_Model.SearchType;
ControlWidth = SelectRecords_Model.ControlWidth;
idField = SelectRecords_Model.idField;
textField = SelectRecords_Model.textField;
SetValueStr = SelectRecords_Model.SetValueStr;
ROW_NUMBER_ORDER = SelectRecords_Model.ROW_NUMBER_ORDER;
MustWrite = SelectRecords_Model.MustWrite;
IsmultiSelect = SelectRecords_Model.IsmultiSelect;
}
if (string.IsNullOrEmpty(keyWordValue))
{
return;
}
if (sys != null && !string.IsNullOrEmpty(sys.ShowTitle))
{
SetValueResID = sys.ResID;
}
string strSql = "SELECT [CD_ID],[CD_RESID] ,[CD_COLNAME] 内部字段名,[CD_DISPNAME] 显示字段名,CS_SHOW_ORDER 排序 FROM [CMS_TABLE_DEFINE] D join [CMS_TABLE_SHOW] S on D.CD_COLNAME=S.CS_COLNAME and D.CD_RESID=S.CS_RESID where CD_RESID='" + UserDefinedSql + "'";;
if (UserDefinedSql.ToLower().IndexOf("order by") > 0)
{
UserDefinedSql.Substring(0, UserDefinedSql.ToLower().IndexOf("order by"));
}
if (strSql.ToLower().IndexOf("where") < 0)
{
strSql = strSql + " where 1=2";
}
else
{
strSql = strSql + " and 1=2";
}
string[] changePassWord = Common.getChangePassWord();
DataTable dt = Resource.SelectData(strSql, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
string gridField = "";
for (int i = 0; i < dt.Columns.Count; i++)
{
QueryKeyField += "," + dt.Columns[i].ColumnName;
gridField += "{field: '" + dt.Columns[i].ColumnName + "',title:'" + dt.Columns[i].ColumnName + "',width:100, sortable: true ,align:'center'},";
panelWidth += 100;
}
//if (panelWidth > 300) panelWidth = 300;
SelectfieldValue = "[[" + gridField.Substring(0, gridField.Length - 1) + "]]";
if (QueryKeyField.Trim() != "")
{
QueryKeyField = QueryKeyField.Substring(1);
}
ResID_Key = SetValueResID + "_" + keyWordValue;
if (ControlWidth == 0)
{
ControlWidth = 150;
}
}
protected string GetDataDBList()
{
string Condition = "";//Request["Condition"].ToString();
string KeyWord = Request["keyWordValue"].ToString();
int PageSize = Convert.ToInt32(Request["rows"]);
int PageNumber = Convert.ToInt32(Request["page"]);
string SortField = "";
string SortBy = "";
if (Request["Condition"] != null)
{
Condition = Request["Condition"].ToString();
}
if (Request["SortField"] != null)
{
SortField = Request["SortField"].ToString();
}
if (Request["SortBy"] != null)
{
SortBy = Request["SortBy"].ToString();
}
string sqlData = "";
if (KeyWord == "DBSY")//代办
{
sqlData = "select id,FLOWNAME 流程,MAINFIELDVALUE 主题,CREATORNAME 来源,CREATETIME 时间,flowinstid 流程RecID,id 流程ID from VIEW_WF_RECEIVEFILES WHERE EMPCODE='" + UserID + "'";
}
if (KeyWord == "WFQDRW")//我发起的任务
{
sqlData = "SELECT a.flowinstid id,a.flowname 流程,a.mainfieldvalue 主题,b.empname 来源,a.CREATETIME 时间,a.flowinstid 流程RecID, ";
sqlData += "b.id 流程ID FROM VIEW_WF_START a left join WF_USERTASK b on a.usertaskid=b.id and a.EMPCODE=b.EMPCODE WHERE a.EMPCODE='" + UserID + "'";
}
if (KeyWord == "WCLDRW")//我处理的任务
{
sqlData = "SELECT a.ID,a.flowname 流程,a.mainfieldvalue 主题,b.empname 来源,a.CREATETIME 时间,a.flowinstid 流程RecID,b.id 流程ID ";
sqlData += "FROM VIEW_WF_ASSOCIATE a left join WF_USERTASK b on a.taskid=b.taskid and a.EMPCODE=b.EMPCODE WHERE a.EMPCODE='" + UserID + "' ";
}
string sql = "select * from (" + sqlData + ") as c where 1=1 " + Condition;
string OrderBy = "";//order by
if (SortField != "" && SortBy != "")
{
OrderBy = " " + SortField + " " + SortBy;
}
if (OrderBy == "")
{
OrderBy = " id desc ";
}
WebServices.Services services = new WebServices.Services();
DataTable dt = GetDataListPage(sql, PageNumber, PageSize, OrderBy).Tables[0];//'services.SelectData(sql).Tables[0];
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
// //这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd";
string[] changePassWord = Common.getChangePassWord();
string dtCount = services.SelectData(sql, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0].Rows.Count.ToString();
string str = Newtonsoft.Json.JsonConvert.SerializeObject(dt, timeConverter);
return("{\"total\":" + dtCount + ",\"rows\":" + str + "}");
}
private string GetDataByXSMBDCJD()
{
WebServices.Services Resource = new WebServices.Services();
string str = "";
DataTable dt = new DataTable();
string seaBegDate = Request["seaBegDate"];
string seaEndDate = Request["seaEndDate"];
if (seaBegDate != null && seaBegDate != "" && seaEndDate != null && seaEndDate != "")
{
string sql = "select C3_403033098027 销售 ,SUM(C3_403033088714 ) 开票金额 from CT401290382901 ";
sql += " WHERE C3_403033107511 BETWEEN '" + Convert.ToDateTime(seaBegDate).ToString("yyyy-MM-dd") + "' AND '" + Convert.ToDateTime(seaEndDate).ToString("yyyy-MM-dd") + "' GROUP BY C3_403033098027; ";
sql += " select C3_403033098027 销售 ,SUM(C3_401795702260 ) 项目收款额 from CT401290354058 ";
sql += " inner join CT401290382901 on C3_403271229261= C3_403193114292 ";
sql += " WHERE C3_475688833284 BETWEEN '" + Convert.ToDateTime(seaBegDate).ToString("yyyy-MM-dd") + "' AND '" + Convert.ToDateTime(seaEndDate).ToString("yyyy-MM-dd") + "' group by C3_403033098027; ";
sql += " select C3_403033098027 销售 ,SUM(C3_403033088714 ) 开票金额 from CT401290382901 ";
sql += " WHERE C3_403033107511 BETWEEN '" + Convert.ToDateTime(seaBegDate).AddYears(-1).ToString("yyyy-MM-dd") + "' AND '" + Convert.ToDateTime(seaEndDate).AddYears(-1).ToString("yyyy-MM-dd") + "' GROUP BY C3_403033098027; ";
sql += " select C3_403033098027 销售 ,SUM(C3_401795702260 ) 项目收款额 from CT401290354058 ";
sql += " inner join CT401290382901 on C3_403271229261= C3_403193114292 ";
sql += " WHERE C3_475688833284 BETWEEN '" + Convert.ToDateTime(seaBegDate).AddYears(-1).ToString("yyyy-MM-dd") + "' AND '" + Convert.ToDateTime(seaEndDate).AddYears(-1).ToString("yyyy-MM-dd") + "' group by C3_403033098027; ";
string[] changePassWord = Common.getChangePassWord();
DataSet ds = Resource.SelectData(sql, changePassWord[0], changePassWord[1], changePassWord[2]);
dt.Columns.Add("销售");
dt.Columns.Add("当期开票金额");
dt.Columns.Add("当期回款金额");
dt.Columns.Add("上期开票金额");
dt.Columns.Add("上期回款金额");
dt.Columns.Add("开票金额同比增长率");
dt.Columns.Add("回款金额同比增长率");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dt.Rows.Add();
dt.Rows[dt.Rows.Count - 1]["销售"] = ds.Tables[0].Rows[i]["销售"].ToString();
dt.Rows[dt.Rows.Count - 1]["当期开票金额"] = ds.Tables[0].Rows[i]["开票金额"].ToString();
}
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
int isHave = 0;
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j]["销售"].ToString() == ds.Tables[1].Rows[i]["销售"].ToString())
{
dt.Rows[j]["当期回款金额"] = ds.Tables[1].Rows[i]["项目收款额"].ToString();
isHave = 1;
}
}
if (isHave == 0)
{
dt.Rows.Add();
dt.Rows[dt.Rows.Count - 1]["销售"] = ds.Tables[1].Rows[i]["销售"].ToString();
dt.Rows[dt.Rows.Count - 1]["当期回款金额"] = ds.Tables[1].Rows[i]["项目收款额"].ToString();
}
}
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
int isHave = 0;
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j]["销售"].ToString() == ds.Tables[2].Rows[i]["销售"].ToString())
{
dt.Rows[j]["上期开票金额"] = ds.Tables[2].Rows[i]["开票金额"].ToString();
isHave = 1;
}
}
if (isHave == 0)
{
dt.Rows.Add();
dt.Rows[dt.Rows.Count - 1]["销售"] = ds.Tables[2].Rows[i]["销售"].ToString();
dt.Rows[dt.Rows.Count - 1]["上期开票金额"] = ds.Tables[2].Rows[i]["开票金额"].ToString();
}
}
for (int i = 0; i < ds.Tables[3].Rows.Count; i++)
{
int isHave = 0;
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j]["销售"].ToString() == ds.Tables[3].Rows[i]["销售"].ToString())
{
dt.Rows[j]["上期回款金额"] = ds.Tables[3].Rows[i]["项目收款额"].ToString();
isHave = 1;
}
}
if (isHave == 0)
{
dt.Rows.Add();
dt.Rows[dt.Rows.Count - 1]["销售"] = ds.Tables[3].Rows[i]["销售"].ToString();
dt.Rows[dt.Rows.Count - 1]["上期回款金额"] = ds.Tables[3].Rows[i]["项目收款额"].ToString();
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["上期开票金额"].ToString() != "" && dt.Rows[i]["当期开票金额"].ToString() != "" && dt.Rows[i]["上期开票金额"].ToString() != "0")
{
dt.Rows[i]["开票金额同比增长率"] = Math.Round((Convert.ToDouble(dt.Rows[i]["当期开票金额"].ToString()) / Convert.ToDouble(dt.Rows[i]["上期开票金额"].ToString()) - 1) * 10000) / 100 + "%";
}
if (dt.Rows[i]["当期回款金额"].ToString() != "" && dt.Rows[i]["上期回款金额"].ToString() != "" && dt.Rows[i]["上期回款金额"].ToString() != "0")
{
dt.Rows[i]["回款金额同比增长率"] = Math.Round((Convert.ToDouble(dt.Rows[i]["当期回款金额"].ToString()) / Convert.ToDouble(dt.Rows[i]["上期回款金额"].ToString()) - 1) * 10000) / 100 + "%";
}
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd";
str = Newtonsoft.Json.JsonConvert.SerializeObject(dt, timeConverter);
}
return(str);
}
protected void Page_Load(object sender, System.EventArgs e)
{
RedirectVerify();
WebServices.Services Resource = new WebServices.Services();
string UserID = CurrentUser.ID;
string ucode = CurrentUser.Password;
//读取web.config文件，得到Post提交地址
//string BPMPostUrl = System.Configuration.ConfigurationManager.AppSettings["BPMPostUrl"].ToString();
////读取web.config文件，得到Process地址
//string BPMProcessUrl = System.Configuration.ConfigurationManager.AppSettings["BPMProcessUrl"].ToString();
////读取web.config文件，得到Read地址
//string BPMReadUrl = System.Configuration.ConfigurationManager.AppSettings["BPMReadUrl"].ToString();
////读取web.config文件，得到易正流程中心地址
//string BPMCenter = System.Configuration.ConfigurationManager.AppSettings["BPMCenter"].ToString();
//读取web.config文件，得到CMS中心地址
//string cmsweb = System.Configuration.ConfigurationManager.AppSettings["cmsweb"].ToString();
string type = "post";
string WorkFlowWebPath = "";
string ParentFlowRowID = "";
string RowID = "";
string WorkflowInstId = "";
string WorklistItemId = "";
string _ParentValue = "";
string ParentRowId = "";
string Para = "";
if (Request["cookiedate"] != null)
{
if (!string.IsNullOrEmpty(Request["cookiedate"].ToString()))
{
_ParentValue = "&ParentValue=" + Request["cookiedate"].ToString();
}
}
if (Request["Type"] != null)
{
type = Request["Type"].ToString().ToLower();
}
if (Request["Para"] != null)
{
Para = Request.QueryString["Para"];
}
if (Request.QueryString["ParentFlowRowID"] != null)
{
ParentFlowRowID = Request.QueryString["ParentFlowRowID"].ToString().ToLower();
}
if (Request.QueryString["RowID"] != null)
{
RowID = Request.QueryString["RowID"].ToString().ToLower();
}
if (Request.QueryString["WorklistItemId"] != null)
{
WorklistItemId = Request.QueryString["WorklistItemId"].ToString().ToLower();//483624242700
}
if (Request.QueryString["WorkflowInstId"] != null)
{
WorkflowInstId = Request.QueryString["WorkflowInstId"].ToString().ToLower();//483624240010
}
if (Request["RecID"] != null)
{
ParentRowId = Request["RecID"].ToString().Trim();
}
if (type == "create")
{
WorkFlowWebPath = "/webflow/process/director.aspx?action=" + type + "&WorkflowId=" + ParentFlowRowID + _ParentValue + "&ParentRowId=" + RowID + "&Para=" + Para;
}
else if (type == "transtract")
{
WorkFlowWebPath = "/webflow/process/director.aspx?action=" + type + "&WorkflowInstId=" + WorkflowInstId + "&WorklistItemId=" + WorklistItemId;
}
else if (type == "xmxxck")
{
if (ParentRowId != null || ParentRowId != "")
{
string sql = "select top 1 wf.id WorkflowInstId from WF_INSTANCE WF left join ct482433275742 ct ON WF.RecordID=ct.id WHERE ParentRowId='" + ParentRowId + "'";
string[] changePassWord = Common.getChangePassWord();
DataTable dt = Resource.SelectData(sql, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
if (dt.Rows.Count > 0)
{
WorkflowInstId = dt.Rows[0]["WorkflowInstId"].ToString();
}
}
if (WorkflowInstId != null)
{
string SQLS = " select top 1 b.id WorklistItemId from WF_TASK a left join WF_USERTASK b on a.nodeid=b.nodeid and a.id=b.taskid where a.WF_INSTANCE_ID='" + WorkflowInstId + "' and a.TASKSTATUS='0' order by b.createtime desc";
string[] changePassWord = Common.getChangePassWord();
DataTable TABLES = Resource.SelectData(SQLS, changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
if (TABLES.Rows.Count > 0)
{
WorklistItemId = TABLES.Rows[0]["WorklistItemId"].ToString();
}
}
WorkFlowWebPath = "/webflow/process/director.aspx?action=transtract&WorkflowInstId=" + WorkflowInstId + "&WorklistItemId=" + WorklistItemId;
}
else if (type.ToLower() == "form")
{
string[] changePassWord = Common.getChangePassWord();
DataTable dt = Resource.SelectData(" select top 1 b.id WorklistItemId from WF_TASK a left join WF_USERTASK b on a.nodeid=b.nodeid and a.id=b.taskid where wf_instance_id='" + WorkflowInstId + "' order by b.createtime desc", changePassWord[0], changePassWord[1], changePassWord[2]).Tables[0];
if (dt.Rows.Count > 0)
{
WorklistItemId = dt.Rows[0]["WorklistItemId"].ToString();
WorkFlowWebPath = "/webflow/process/director.aspx?action=transtract&WorkflowInstId=" + WorkflowInstId + "&WorklistItemId=" + WorklistItemId + "&ParentRowId=" + RowID;
}
}
else if (type.ToLower() == "wfqdrw")
{
WorkFlowWebPath = "/webflow/process/director.aspx?action=view&WorklistItemId=" + WorklistItemId;
}
else if (type.ToLower() == "bxsq")
{
WorkFlowWebPath = "/webflow/ExtensionForms/报销申请/index.aspx?action=create&WorkflowId=193841883015";
}
else if (type.ToLower() == "qksq")
{
WorkFlowWebPath = "/webflow/ExtensionForms/请款申请/index.aspx?action=create&WorkflowId=194376055201";
}
else
{
WorkFlowWebPath = "/webflow/process/director.aspx?action=" + type + "&WorkflowInstId=" + WorkflowInstId + "&WorklistItemId=" + WorklistItemId + "&ParentRowId=" + RowID;
}
Response.Redirect("workflow_directservice.aspx?strURL=" + Server.UrlEncode(WorkFlowWebPath));
}