using System; using System.Configuration; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Web.UI; using System.Web.UI.WebControls; using SuperMap.RealEstate.CoreFrameWork; using SuperMap.RealEstate.ServiceModel; using SuperMap.RealEstate.Utility; using SuperMap.RealEstate.Web.UI; using SuperMap.RealEstate.Web.UI.WebControls; using SuperMap.RealEstate.Web.Utility; using SuperMap.RealEstate.ExchangeData.Business; using Business = SuperMap.RealEstate.HighWay.Storage.Business; namespace SuperMap.RealEstate.HighWay.Modules.ServerPartMachine { public partial class VersionCompare : BasePage { protected string _serverpart_id = ConfigurationManager.AppSettings["UmiformCommodity"].ToString().Split('|')[0]; protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; BindingTreeView(); //StartDate.Text = DateTime.Now.ToShortDateString(); //EndDate.Text = DateTime.Now.ToShortDateString(); SERVERPART_ID.Clear(); SERVERPART_ID.Items.Add(new ListItemEx("全部", "1=1")); SERVERPART_ID.SelectedValue = "1=1"; foreach (DataRow _DataRow in new Business.SERVERPART(Transaction).ExecuteDataTable( "SELECT DISTINCT SERVERPART_ID,SERVERPART_INDEX,SERVERPARTCODE,SERVERPART_NAME FROM HIGHWAY_STORAGE.V_CONNECTPOINT" + (string.IsNullOrEmpty(DataType.SelectedValue) || DataType.SelectedValue == "1=1" ? "" : " WHERE STATISTIC_TYPE = " + DataType.SelectedValue) + " ORDER BY SERVERPART_INDEX,SERVERPARTCODE,SERVERPART_NAME").Rows) { ListItemEx _ListItemEx = new ListItemEx(); _ListItemEx.Text = _DataRow["SERVERPART_NAME"].ToString(); _ListItemEx.Value = _DataRow["SERVERPART_ID"].ToString(); _ListItemEx.Level = 1; SERVERPART_ID.Items.Add(_ListItemEx); } Version_Num.Items.Clear(); Version_Num.Items.Add(new ListItemEx("全部", "1=1")); foreach (DataRow _DataRow in new Business.SERVERPARTSHOP(Transaction).ExecuteDataTable( @"SELECT DISTINCT SUBSTR(CONTENT,INSTR(CONTENT,'YSv'),LENGTH(CONTENT)) FROM HIGHWAY_STORAGE.V_CONNECTPOINT WHERE CONTENT LIKE '%YSv%' ORDER BY SUBSTR(CONTENT,INSTR(CONTENT,'YSv'),LENGTH(CONTENT)) DESC").Rows) { ListItemEx _ListItemEx = new ListItemEx(); _ListItemEx.Level = 1; _ListItemEx.Text = _DataRow[0].ToString(); _ListItemEx.Value = _DataRow[0].ToString(); Version_Num.Items.Add(_ListItemEx); } Version_Num.SelectedValue = "1=1"; //设置回车焦点按钮 SetControlClientAction(ButtonSearch); //初始化并加载列表 //GridViewEx1.SelectingWithInit(ObjectDataSource1, GridPageEx1); } #region 方法 -> 查询 protected void ButtonStatistics_Click(object sender, EventArgs e) { //查询数据 GridViewEx1.SelectingWithInit(ObjectDataSource1, GridPageEx1); GridViewEx1.Visible = true; HideClientMask("正在查询..."); } #endregion //查询 protected void ButtonSearch_CallBackClick(object sender, ClientSetEventArgs e) { GridViewEx1.Selecting(ObjectDataSource1, GridPageEx1); //设置UI变化 e.SetValue(GridViewEx1); e.SetValue(GridPageEx1); } //翻页事件 protected void GridPageEx1_CallBackPageChanged(object src, ClientSetEventArgs e) { GridViewEx1.Pagging(ObjectDataSource1, GridPageEx1); //设置UI变化 e.SetValue(GridViewEx1); } //查询SQL设置 protected void GridViewEx1_SelectMethodParameters(object sender, SelectMethodParametersArgs e) { if (DataType.SelectedValue != "1=1" && !string.IsNullOrEmpty(DataType.SelectedValue)) { e.AddAndParams("STATISTIC_TYPE", DataType.SelectedValue); } if (SERVERPART_ID.SelectedValue != "1=1" && !string.IsNullOrEmpty(SERVERPART_ID.SelectedValue)) { e.AddAndParams("SERVERPART_ID", SERVERPART_ID.SelectedValue); } if (!string.IsNullOrEmpty(Version_Num.SelectedValue) && Version_Num.SelectedValue != "1=1") { e.SetOtherUserCustomWhereSqlString = "CONTENT" + (IsContain.SelectedValue == "1" ? "" : " NOT") + " LIKE '%" + Version_Num.SelectedValue + "'"; } if (!string.IsNullOrEmpty(StartDate.Text.Trim())) { e.SetOtherUserCustomWhereSqlString += (e.SetOtherUserCustomWhereSqlString == "" ? "" : " AND ") + "CONNECT_DATE >= TO_DATE('" + StartDate.Text.Trim() + "','YYYY/MM/DD')"; } if (!string.IsNullOrEmpty(EndDate.Text.Trim())) { e.SetOtherUserCustomWhereSqlString += (e.SetOtherUserCustomWhereSqlString == "" ? "" : " AND ") + "CONNECT_DATE < TO_DATE('" + EndDate.Text.Trim() + "','YYYY/MM/DD') + 1"; } if (!string.IsNullOrEmpty(GetVersion_Num())) { e.SetOtherUserCustomWhereSqlString += (e.SetOtherUserCustomWhereSqlString == "" ? "" : " AND ") + "VERSION_NUM IN (" + GetVersion_Num() + ")"; } //且搜索条件 //e.AddAndParams(字段名, 值); //或搜索条件 //e.AddOrParams(字段名, 值); //排序 e.AddOrderByParams("SERVERPART_INDEX,SERVERPARTCODE,SERVERPART_NAME,SHOPREGION,SHOPTRADE,SHOPCODE,SHOPNAME", false); } #region 列表行事件 protected void GridViewEx1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Business.COMMODITY _COMMODITY = new Business.COMMODITY(this.Transaction); //服务区内码 string _SERVERPART_ID = GridViewEx1.DataKeys[e.Row.RowIndex].Values["SERVERPART_ID"].ToString(); string _SERVERPARTCODE = GridViewEx1.DataKeys[e.Row.RowIndex].Values["SERVERPARTCODE"].ToEncrypt(); string _SHOPCODE = GridViewEx1.DataKeys[e.Row.RowIndex].Values["SHOPCODE"].ToString(); string _MACHINECODE = GridViewEx1.DataKeys[e.Row.RowIndex].Values["MACHINECODE"].ToString(); string _PROVINCE_CODE = GridViewEx1.DataKeys[e.Row.RowIndex]["PROVINCE_CODE"].ToString(); string AllString = GridViewEx1.DataKeys[e.Row.RowIndex]["CONTENT"].ToString(); string CommCountSqlString = @"select count(1) from HIGHWAY_STORAGE.T_COMMODITY where EXISTS ( SELECT 1 FROM HIGHWAY_STORAGE.T_SERVERPARTSHOP WHERE SERVERPART_ID = " + _SERVERPART_ID + " AND SHOPTRADE LIKE '%' || BUSINESSTYPE || '%' AND SHOPCODE = '" + _SHOPCODE + "') AND SERVERPART_ID IN (" + _serverpart_id + "," + _SERVERPART_ID + ") AND PROVINCE_CODE = " + _PROVINCE_CODE + " AND COMMODITY_STATE = 1 AND BUSINESSTYPE IS NOT NULL"; if (AllString.Contains("YSv")) { e.Row.Cells[1].Text = "YSv" + AllString.Split("YSv")[1]; } try { if (new MACHINEPOINT(_COMMODITY).GetCount("WHERE SERVERPARTCODE = '" + _SERVERPARTCODE.ToDecrypt() + "' AND SHOPCODE = '" + _SHOPCODE + "' AND MACHINENAME = '" + e.Row.Cells[7].Text + "'") > 0) { e.Row.Attributes["onclick"] = GridViewEx1.GetOpenPopDialogClientScript( "MACHINEPOINTPage.aspx?SERVERPARTCODE=" + _SERVERPARTCODE + "&SHOPCODE=" + _SHOPCODE.ToEncrypt() + "&MACHINENAME=" + e.Row.Cells[7].Text.ToEncrypt(), 1000, 600); } else { e.Row.Attributes["onclick"] = ""; } } catch { e.Row.Attributes["onclick"] = ""; } DataTable _DataTable_PassComm = _COMMODITY.ExecuteDataTable(CommCountSqlString); //审批通过商品数量 string PassCommCount = _DataTable_PassComm.Rows[0][0].ToString(); if (e.Row.Cells[6].Text != PassCommCount) { e.Row.Cells[6].ForeColor = System.Drawing.Color.IndianRed; } e.Row.Cells[6].Text = PassCommCount + "/" + e.Row.Cells[6].Text; //状态 try { //回传时间 System.TimeSpan _TimeSpan_Back = System.DateTime.Now - DateTime.Parse(e.Row.Cells[5].Text); if (_TimeSpan_Back.TotalMinutes > 10) { //5分钟无反馈数据 找不到日结 网络断开中。。橙色 //5分钟无反馈数据 具有日结，已经结账下班 灰色 //查询日结 e.Row.Cells[2].Text = "网络未连接"; e.Row.Cells[2].ForeColor = System.Drawing.Color.MediumVioletRed; string EndAccountSql = "select count(*) from HIGHWAY_SELLDATA.T_ENDACCOUNT where SERVERPART_ID = '" + _SERVERPART_ID + "' AND SHOPCODE = '" + _SHOPCODE + "' AND MACHINECODE='" + _MACHINECODE + "' AND TO_DATE('" + e.Row.Cells[5].Text + "','YYYY/MM/DD HH24:MI:SS') - ENDACCOUNT_DATE BETWEEN 0 AND 1/24"; if (int.Parse(_COMMODITY.ExecuteDataTable(EndAccountSql).Rows[0][0].ToString()) > 0) { e.Row.Cells[2].Text = "已经结账下班"; e.Row.Cells[2].ForeColor = System.Drawing.Color.DimGray; try { if (DateTime.Parse(e.Row.Cells[5].Text) < DateTime.Now.Date) { e.Row.Cells[5].ForeColor = System.Drawing.Color.DimGray; } } catch { } } } else { //5分钟之内无客单 等待上班中。。绿色 //5分钟之内有客单 收银状态正常 蓝色 try { System.TimeSpan _TimeSpan_Bill = System.DateTime.Now - DateTime.Parse(AllString.Split('|')[1]); if (_TimeSpan_Bill.TotalMinutes < 10) { //检测到客单 e.Row.Cells[2].Text = "收银状态正常"; e.Row.Cells[2].ForeColor = System.Drawing.Color.DeepSkyBlue; } else { //检测到客单 e.Row.Cells[2].Text = "收银状态正常"; e.Row.Cells[2].ForeColor = System.Drawing.Color.DeepSkyBlue; } } catch { e.Row.Cells[2].Text = "收银状态正常"; e.Row.Cells[2].ForeColor = System.Drawing.Color.DeepSkyBlue; } } //当前时间与最后订单 } catch { e.Row.Cells[2].Text = "网络未连接"; e.Row.Cells[2].ForeColor = System.Drawing.Color.MediumVioletRed; } } } #endregion private string FormatString(string str, int _Length = 10) { if (str.Length >= _Length) { return str.Substring(0, _Length) + "..."; } return str; } protected void BindingTreeView() { MyTreeView.Nodes.Clear(); TreeNode _TreeNodeAll = new TreeNode(); _TreeNodeAll.NavigateUrl = "#"; _TreeNodeAll.Text = "所有版本"; _TreeNodeAll.Value = "1=1"; MyTreeView.Nodes.Add(_TreeNodeAll); foreach (DataRow _DataRow in new Business.SERVERPARTSHOP(Transaction).ExecuteDataTable( "SELECT DISTINCT VERSION_NUM FROM HIGHWAY_STORAGE.V_CONNECTPOINT WHERE VERSION_NUM IS NOT NULL ORDER BY VERSION_NUM DESC").Rows) { TreeNode _TreeNode = new TreeNode(); _TreeNode.NavigateUrl = "#"; _TreeNode.Text = _DataRow[0].ToString(); _TreeNode.Value = _DataRow[0].ToString(); _TreeNodeAll.ChildNodes.Add(_TreeNode); } MyTreeView.ExpandAll(); } protected void MyTreeView_TreeNodeCheckChanged(object sender, TreeNodeEventArgs e) { treeView_Checked(e.Node.ChildNodes, e.Node.Checked); } private void treeView_Checked(TreeNodeCollection nodes, bool Checked) { foreach (TreeNode treeNode in nodes) { treeNode.Checked = Checked; treeView_Checked(treeNode.ChildNodes, Checked); } } #region 方法 -> 获取版本信息 private string GetVersion_Num() { string OutTypeString = ""; //if (MyTreeView.Nodes[0].Checked) // return ""; foreach (TreeNode _FormatTreeNode in MyTreeView.Nodes[0].ChildNodes) { if (_FormatTreeNode.Checked) { OutTypeString += OutTypeString == "" ? "'" + _FormatTreeNode.Value + "'" : ",'" + _FormatTreeNode.Value + "'"; } } return OutTypeString; } #endregion protected void DataType_CallBackSetControl(object sender, ClientSetEventArgs e) { SERVERPART_ID.Clear(); SERVERPART_ID.Items.Add(new ListItemEx("全部", "1=1")); SERVERPART_ID.SelectedValue = "1=1"; foreach (Business.SERVERPART _SERVERPART in new Business.SERVERPART(Transaction).FillCollection( "WHERE SERVERPART_ID IN (SELECT SERVERPART_ID FROM HIGHWAY_STORAGE.V_CONNECTPOINT) " + (string.IsNullOrEmpty(DataType.SelectedValue) || DataType.SelectedValue == "1=1" ? "" : " AND STATISTIC_TYPE = " + DataType.SelectedValue) + "ORDER BY SERVERPART_INDEX,SERVERPART_CODE,SERVERPART_NAME")) { ListItemEx _ListItemEx = new ListItemEx(); _ListItemEx.Text = _SERVERPART.SERVERPART_NAME; _ListItemEx.Value = _SERVERPART.SERVERPART_ID.ToString(); _ListItemEx.Level = 1; SERVERPART_ID.Items.Add(_ListItemEx); } e.SetDropDownListEx(SERVERPART_ID); } } }