Beispiel #1
0
        //更新某年的税金数据
        public static void UpdateData(int year, double srate)
        {
            JTable             tab1      = new JTable("SRATEPROFILE");
            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("byear", year + ""));
            DataSet   ds1 = tab1.SearchData(condition, -1, "*");
            DataTable dt1 = ds1.Tables[0];

            if (dt1.Rows.Count > 0)
            {
                DataRow dr1 = dt1.Rows[0];
                dr1["srate"] = srate;
                tab1.Update(ds1.Tables[0]);
            }
            tab1.Close();
        }
Beispiel #2
0
        /// <summary>
        /// 功能:查询特定的数据
        /// </summary>
        /// <param name="condition">查询条件</param>
        /// <param name="curPage">当前页</param>
        /// <param name="pageSize">页大小</param>
        /// <param name="orderBy">排序表达式</param>
        /// <param name="totalRow">返回的总行数</param>
        /// <param name="fs">要显示的字段</param>
        /// <returns></returns>
        public DataSet SearchData(List <SearchField> condition, int curPage,
                                  int pageSize, String orderBy, out int totalRow, params String[] fs)
        {
            totalRow = 0;
            JTable tab1 = new JTable(TableName);

            tab1.PageSize = pageSize;
            if (String.IsNullOrEmpty(orderBy) == false)
            {
                tab1.OrderBy = orderBy;
            }
            DataSet ds1 = tab1.SearchData(condition, curPage, fs);

            totalRow = tab1.GetTotalRow();
            tab1.Close();
            return(ds1);
        }
        private static List <String> CheckLine(String LineName, out String Error)
        {
            List <String> result = new List <string>();

            Error = String.Empty;
            JTable             tab1      = new JTable("TRAINLINE");
            List <SearchField> condition = new List <SearchField>();

            if (String.IsNullOrEmpty(LineName) == false)
            {
                String[] line = LineName.Replace("、", ";").Replace(",", ";").Replace(",", ";").Split(';');
                if (line != null)
                {
                    foreach (String m in line)
                    {
                        condition.Clear();

                        condition.Add(new SearchField("trim(LINENAME)", m.Trim()));
                        DataSet ds1 = tab1.SearchData(condition, -1, "lineid");
                        if (ds1.Tables[0].Rows.Count == 1)
                        {
                            foreach (DataRow dr1 in ds1.Tables[0].Rows)
                            {
                                if (result.Contains(dr1[0].ToString()) == false)
                                {
                                    result.Add(dr1[0].ToString());
                                }
                            }
                        }
                        else
                        {
                            Error = String.Format("【{0}】线路的配置数量为{1}(要求为1),请检查!", m, ds1.Tables[0].Rows.Count);
                            break;
                        }
                    }
                }
            }
            tab1.Close();
            if (String.IsNullOrEmpty(Error) == false)
            {
                result.Clear();
                result = null;
            }
            return(result);
        }
Beispiel #4
0
        /// <summary>
        /// 根据运行里程得到区段里程
        /// </summary>
        /// <param name="yuxinglicheng"></param>
        /// <returns></returns>
        private int GetQuDuanLiCheng(int yuXingLiCheng)
        {
            int    result = 0;
            JTable tab1   = null;

            try
            {
                tab1 = new JTable("LiChengProfile");
                List <SearchField> condition = new List <SearchField>();
                condition.Add(new SearchField("Pos1", yuXingLiCheng + "", SearchOperator.SmallerAndEqual, SearchFieldType.NumericType));
                condition.Add(new SearchField("(Pos2 >= " + yuXingLiCheng + " or Pos2 is null )", "", SearchOperator.UserDefine));
                tab1.OrderBy = "id";
                DataRow dr1 = tab1.GetFirstDataRow(condition, "*");
                if (dr1 != null)
                {
                    int pos1    = int.Parse(dr1["pos1"].ToString());
                    int posSize = int.Parse(dr1["posSize"].ToString());

                    int    y1 = (yuXingLiCheng - pos1 + 1) / posSize;
                    double t  = 0;
                    double y2 = (yuXingLiCheng - pos1 + 1 + t) / (posSize + t);
                    double y0 = y2 - y1;

                    if (y0 > 0 && y0 < 0.5)
                    {
                        y0 = 0.5;
                    }
                    else if (y0 >= 0.5)
                    {
                        y0 = 1.0;
                    }
                    else
                    {
                        y0 = 0;
                    }

                    result = (pos1 - 1) + (int)((y1 + y0) * posSize);
                }
            }
            finally
            {
                tab1.Close();
            }
            return(result);
        }
Beispiel #5
0
        /// <summary>
        /// 根据条件得到列表数据
        /// </summary>
        /// <param name="condition">查询条件</param>
        /// <param name="PageSize">页大小</param>
        /// <param name="CurPage">当前页</param>
        /// <param name="Fields">数据字段</param>
        /// <param name="orderBy">排序表达式</param>
        /// <param name="TotalRow">数据总行数</param>
        /// <param name="Fields">要显示的字段</param>
        /// <returns>列表数据</returns>
        public DataTable GetListData(List <SearchField> condition,
                                     int PageSize, int CurPage, String orderBy,
                                     out int TotalRow, params String[] Fields)
        {
            TotalRow = 0;
            DataTable dt1  = null;
            JTable    tab1 = new JTable(daConnect, TableName);

            tab1.PageSize = PageSize;
            if (String.IsNullOrEmpty(orderBy) == false)
            {
                tab1.OrderBy = orderBy;
            }
            dt1      = tab1.SearchData(condition, CurPage, Fields).Tables[0];
            TotalRow = tab1.GetTotalRow();          //得到总的数据行
            tab1.Close();
            return(dt1);
        }
Beispiel #6
0
        public static void GetSearchInfoBynum(String num, out String A0, out String B0, out String ShenDu, out String Fengduan)
        {
            A0 = String.Empty; B0 = String.Empty; ShenDu = "30"; Fengduan = String.Empty;
            JTable             tab1      = new JTable("SEARCHOBJECTLIST");
            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("num", num, SearchFieldType.NumericType));
            DataRow dr = tab1.GetFirstDataRow(condition, "*");

            if (dr != null)
            {
                A0       = dr["Astation"].ToString();
                B0       = dr["Bstation"].ToString();
                ShenDu   = dr["shendu"].ToString();
                Fengduan = dr["fengduan"].ToString();
            }
            tab1.Close();
        }
Beispiel #7
0
        /// <summary>
        /// 得到车厢类型的票价率和满员人数
        /// </summary>
        /// <param name="type1"></param>
        /// <returns></returns>
        private static CommChexianRateAndPersonCount GetCheXianFeeRateAndPersonCount(ECommCheXian type1)
        {
            CommChexianRateAndPersonCount rp1 = new CommChexianRateAndPersonCount();
            JTable             tab1           = new JTable("CheXianBianZhu");
            List <SearchField> condition      = new List <SearchField>();

            if (type1 == ECommCheXian.硬座)
            {
                condition.Add(new SearchField("kind", "YinZuo"));
            }
            else if (type1 == ECommCheXian.软座)
            {
                condition.Add(new SearchField("kind", "RuanZuo"));
            }
            else if (type1 == ECommCheXian.开放式硬卧)
            {
                condition.Add(new SearchField("(kind='YinWo1' or kind='YinWo2' or kind='YinWo3')", "", SearchOperator.UserDefine));
            }
            else if (type1 == ECommCheXian.包房式硬卧)
            {
                condition.Add(new SearchField("(kind='YinWo4' or kind='YinWo5')", "", SearchOperator.UserDefine));
            }
            else if (type1 == ECommCheXian.软卧)
            {
                condition.Add(new SearchField("(kind='RuanWo1' or kind='RuanWo2')", "", SearchOperator.UserDefine));
            }
            else if (type1 == ECommCheXian.高级软卧)
            {
                condition.Add(new SearchField("(kind='GaoJiRuanWo1' or kind='GaoJiRuanWo2')", "", SearchOperator.UserDefine));
            }
            tab1.OrderBy = "kind";
            DataSet ds1 = tab1.SearchData(condition, -1, "*");
            int     i   = 0;

            foreach (DataRow dr1 in ds1.Tables[0].Rows)
            {
                rp1.SetRate(i, int.Parse(dr1["Rate"].ToString()));
                rp1.SetPerson(i, int.Parse(dr1["PCount"].ToString()));
                i++;
            }
            tab1.Close();
            return(rp1);
        }
Beispiel #8
0
        /// <summary>
        /// 将列车现有的数据导入到XLS表中
        /// </summary>
        public static void ImportTrainDataToSystem(String FileName)
        {
            String[] fs = new String[] { "车次", "始发站", "终到站", "列车类型",
                                         "单程距离", "开行趟数", "车底组数", "硬座", "软座",
                                         "硬卧", "软卧", "餐车", "发电车", "行李车", "邮政车" };

            String[] fs1 = new String[] { "TRAINNAME", "ASTATION", "BSTATION", "TRAINTYPE",
                                          "MILE", "KXTS", "CDZS", "YINZUO", "RUANZUO", "OPENYINWO"
                                          , "RUANWO", "CANCHE", "FADIANCHE", "SHUYINCHE", "YOUZHENGCHE" };

            JTable tab1 = new JTable("NEWTRAIN");
            Dictionary <String, object> data1 = new Dictionary <string, object>();
            int num = 1;

            String FileName1 = HttpContext.Current.Server.MapPath("~/Attachment/" + FileName);

            if (File.Exists(FileName1))
            {
                DataSet ds1 = PubCode.Util.xsldata(FileName1, "Table1");
                if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow dr1 in ds1.Tables[0].Rows)
                    {
                        if (dr1["车次"].ToString().Trim() != String.Empty)
                        {
                            data1.Clear();
                            for (int i = 0; i < fs.Length; i++)
                            {
                                object obj1 = dr1[fs[i]];

                                data1.Add(fs1[i], obj1);
                            }
                            data1.Add("num", num);
                            data1.Add("TRAINBIGKIND", 0);
                            num++;
                            tab1.InsertData(data1);
                        }
                    }
                }
            }
            tab1.Close();
        }
        public static void SetData()
        {
            JTable tab1 = new JTable("LINEPROFILE");

            tab1.OrderBy     = "id";
            LineProfile.Data = tab1.SearchData(null, -1, "*").Tables[0];
            tab1.Close();

            FeeRate = new Dictionary <int, LineCostData>();
            foreach (DataRow dr1 in LineProfile.Data.Rows)
            {
                String LineType = dr1["linetype"].ToString().Trim();
                int    index1   = int.Parse(LineType.ToLower().Replace("line", ""));

                LineCostData data1 = new LineCostData();
                if (dr1["Fee1"].ToString().Trim() != String.Empty)
                {
                    data1.Fee1 = double.Parse(dr1["Fee1"].ToString().Trim());
                }
                if (dr1["Fee2"].ToString().Trim() != String.Empty)
                {
                    data1.Fee2 = double.Parse(dr1["Fee2"].ToString().Trim());
                }
                if (dr1["Fee3"].ToString().Trim() != String.Empty)
                {
                    data1.Fee3 = double.Parse(dr1["Fee3"].ToString().Trim());
                }
                if (dr1["Fee4"].ToString().Trim() != String.Empty)
                {
                    data1.Fee4 = double.Parse(dr1["Fee4"].ToString().Trim());
                }
                if (dr1["Fee5"].ToString().Trim() != String.Empty)
                {
                    data1.Fee5 = double.Parse(dr1["Fee5"].ToString().Trim());
                }
                if (dr1["Fee6"].ToString().Trim() != String.Empty)
                {
                    data1.Fee6 = double.Parse(dr1["Fee6"].ToString().Trim());
                }
                FeeRate.Add(index1, data1);
            }
        }
Beispiel #10
0
        /// <summary>
        /// 从数据库中恢复数据
        /// </summary>
        /// <param name="AStation"></param>
        /// <param name="BStation"></param>
        /// <param name="Shendu"></param>
        /// <param name="newLine"></param>
        /// <returns></returns>
        public static bool RestoreSearchResultFromDb
        (
            String AStation,
            String BStation,
            String fengduanText,
            out Line newLine)
        {
            bool   succResult = false;
            String FileName   = String.Empty;

            newLine = null;

            JTable             tab1      = new JTable("SEARCHOBJECTLIST");
            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("ASTATION", AStation));
            condition.Add(new SearchField("BSTATION", BStation));
            condition.Add(new SearchField("SaveTime is not null", "", SearchOperator.UserDefine));

            if (String.IsNullOrEmpty(fengduanText) == false)
            {
                condition.Add(new SearchField("FENGDUAN", fengduanText));
            }
            else
            {
                condition.Add(new SearchField("FENGDUAN is null", "", SearchOperator.UserDefine));
            }

            tab1.OrderBy = "ShenDu desc,num desc";

            DataSet ds1 = tab1.SearchData(condition, -1, "*");

            if (ds1.Tables[0].Rows.Count > 0)
            {
                DataRow dr1 = ds1.Tables[0].Rows[0];
                FileName = dr1["NEWLINEFILENAME"].ToString();
                newLine  = RestoreObjectFormFile(FileName) as Line;
            }
            tab1.Close();
            return(succResult);
        }
        void JButton2_Click(object sender, EventArgs e)
        {
            JTable tab1 = new JTable("COMMTRAINWEIGHTPROFILE");

            System.Collections.Generic.List <WebFrame.Data.SearchField> condition =
                new System.Collections.Generic.List <WebFrame.Data.SearchField>();
            System.Collections.Generic.Dictionary <String, object> data1 =
                new System.Collections.Generic.Dictionary <string, object>();
            int i = 0;

            String[] arr1 = "YzWeight,YwWeight,SYzWeight,SRzWeight,Rzweight,RwWeight,GRw19KWeight,GRw19TWeight,CaWeight,KdWeight".Split(',');
            foreach (RepeaterItem item in this.Repeater2.Items)
            {
                condition.Clear();
                condition.Add(new WebFrame.Data.SearchField("num", (i + 1) + "", WebFrame.SearchFieldType.NumericType));
                data1.Clear();
                foreach (String m in arr1)
                {
                    TextBox t1 = item.FindControl(m) as TextBox;
                    if (t1 != null)
                    {
                        if (t1.Text.Trim() != String.Empty)
                        {
                            data1[m] = t1.Text;
                        }
                        else
                        {
                            data1[m] = "0";
                        }
                    }
                }
                tab1.EditData(data1, condition);
                i++;
            }


            tab1.Close();
            BusinessRule.CheXianProfile.SetData();

            WebFrame.Util.JAjax.Alert("提示:更新数据操作成功!");
        }
Beispiel #12
0
        /// <summary>
        /// 得到列车默认的车厢编组数据
        /// 规则:得到上次的编组数据,如果没有,从列车的数据中导入
        /// </summary>
        private static int[] GetTrainDefaultBianZhu(String TrainName)
        {
            int[]    bianzhu = new int[] { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
            String[] fs      = new String[] { "YinZuo", "RuanZuo", "OpenYinWo", "CloseYinWo", "RuanWo",
                                              "AdvanceRuanWo", "CanChe", "FaDianChe", "ShuYinChe", "YouZhengChe" };

            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("TrainName", TrainName));
            JTable tab1 = new JTable();

            /*
             * tab1.TableName = "NEWTRAINSHOUROU";
             * tab1.OrderBy = "byear desc,bmonth desc";
             * DataRow dr1 = tab1.GetFirstDataRow(condition, "*"); */

            DataRow dr1 = null;

            if (dr1 == null ||
                dr1[0].ToString().Trim() == String.Empty)
            {
                tab1.TableName = "NEWTRAIN";
                tab1.OrderBy   = String.Empty;
                condition.Clear();
                condition.Add(new SearchField("instr(TrainName,'" + TrainName + "')>0", "", SearchOperator.UserDefine));
                dr1 = tab1.GetFirstDataRow(condition, "*");
            }
            if (dr1 != null)
            {
                for (int i = 0; i < bianzhu.Length; i++)
                {
                    if (dr1[fs[i]].ToString().Trim() != String.Empty)
                    {
                        bianzhu[i] = int.Parse(dr1[fs[i]].ToString().Trim());
                    }
                }
            }

            tab1.Close();
            return(bianzhu);
        }
Beispiel #13
0
        /// <summary>
        /// 得到高铁的类型
        /// </summary>
        /// <returns></returns>
        public static String[] GetHightTrainType()
        {
            String[] result = null;
            JTable   tab1   = new JTable("HighTrainProfile");

            tab1.OrderBy = "ID";
            DataSet ds1 = tab1.SearchData(null, -1, "HighTrainType");

            if (ds1.Tables[0].Rows.Count > 0)
            {
                result = new String[ds1.Tables[0].Rows.Count];
                int i = 0;
                foreach (DataRow dr1 in ds1.Tables[0].Rows)
                {
                    result[i] = dr1[0].ToString().Trim();
                    i++;
                }
            }
            tab1.Close();
            return(result);
        }
Beispiel #14
0
        /// <summary>
        /// 得到牵引费
        /// 计算公式:合适的标准*列车的重量*运用的里程*2*365
        /// </summary>
        /// <returns></returns>
        public double GetQianYinCostOrDianFei()
        {
            double Fee = 0;

            if (this.TrainBigKind == ETrainBigKind.普通列车)
            {
                JTable             tab1      = new JTable("QIANYINFEEPROFILE");
                List <SearchField> condition = new List <SearchField>();
                condition.Add(new SearchField("QIANYINTYPE", (int)this.QianYinType + "", SearchFieldType.NumericType));
                DataRow dr1 = tab1.GetFirstDataRow(condition, "Fee1", "Fee2");
                if (dr1 != null)
                {
                    if (this.GongDianType == EGongDianType.直供电)
                    {
                        Fee = double.Parse(dr1["Fee1"].ToString());
                    }
                    else
                    {
                        Fee = double.Parse(dr1["Fee2"].ToString());
                    }
                }
                tab1.Close();
                Fee = Fee * this.GetTrainWeight() * this.YuXingLiCheng * 2 * 365; //合适的标准*列车的重量*运用的里程*2*365
            }
            else
            {
                int                lineid    = (int)this.TrainLine;
                JTable             tab1      = new JTable("TRAINLINEKINDPROFILE");
                List <SearchField> condition = new List <SearchField>();
                condition.Add(new SearchField("lineid", lineid + "", SearchFieldType.NumericType));
                DataRow dr1 = tab1.GetFirstDataRow(condition, "*");
                if (dr1 != null)
                {
                    Fee = Fee + (double.Parse(dr1["JIECHUFEE"].ToString()) + double.Parse(dr1["DIANFEE"].ToString()))
                          * this.YuXingLiCheng * this.GetTrainWeight();
                }
                tab1.Close();
            }
            return(Fee);
        }
        //更新编制的值
        private void UpdateData()
        {
            JTable        tab1  = new JTable("TRAINPERSON");
            List <String> list1 = ViewState["tabData1"] as List <string>;

            if (list1 != null && list1.Count > 0)
            {
                foreach (String m in list1)
                {
                    String m1 = Request.Form["ctl00$ContentPlaceHolder1$" + m];
                    if (m1.Trim() == String.Empty)
                    {
                        m1 = "0";
                    }
                    String[] arr       = m.Split('_');
                    String   gw        = arr[0];
                    String   traintype = arr[1];
                    this.SetValue(tab1, gw, traintype, double.Parse(m1), "0");
                }
            }

            List <String> list2 = ViewState["tabData2"] as List <string>;

            if (list2 != null && list2.Count > 0)
            {
                foreach (String m in list2)
                {
                    String m1 = Request.Form["ctl00$ContentPlaceHolder1$" + m];
                    if (m1.Trim() == String.Empty)
                    {
                        m1 = "0";
                    }
                    String[] arr       = m.Split('_');
                    String   gw        = arr[0];
                    String   traintype = arr[1];
                    this.SetValue(tab1, gw, traintype, double.Parse(m1), "1");
                }
            }
            tab1.Close();
        }
Beispiel #16
0
        //增加某年的税金
        public static void AddRate(int year)
        {
            double result = 0.9676;
            JTable tab1   = new JTable("SRATEPROFILE");

            tab1.OrderBy = "byear desc";
            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("byear", year + ""));
            DataSet   ds1 = tab1.SearchData(condition, -1, "*");
            DataTable dt1 = ds1.Tables[0];

            if (dt1.Rows.Count == 0)
            {
                DataRow dr1 = dt1.NewRow();
                dr1["byear"] = year;
                dr1["srate"] = result;
                dt1.Rows.Add(dr1);
                tab1.Update(ds1.Tables[0]);
            }
            tab1.Close();
        }
        protected void Button2_Click(object sender, EventArgs e)
        {
            JTable             tab       = new JTable("NEWTRAIN");
            List <SearchField> condition = new List <SearchField> ();

            if (!string.IsNullOrEmpty(Request.QueryString["TrainName"]))
            {
                condition.Add(new SearchField("TrainName", Request.QueryString["TrainName"].ToString()));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["AStation"]))
            {
                condition.Add(new SearchField("AStation", Request.QueryString["AStation"].ToString()));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["BStation"]))
            {
                condition.Add(new SearchField("BStation", Request.QueryString["BStation"].ToString()));
            }
            System.Data.DataTable dt = new System.Data.DataTable();
            dt = tab.SearchData(condition, -1, new string[] { "*" }).Tables[0];
            tab.Close();
            ExportExcel(dt, "TrainInfo");
        }
Beispiel #18
0
        //得到列车的岗位
        public static void GetTrainGw(out String[] gw1, out String[] gw2)
        {
            gw1 = null;
            gw2 = null;
            JTable             tab1      = new JTable();
            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("gw is not null", "", SearchOperator.UserDefine));

            tab1.TableName = "persongz";
            tab1.OrderBy   = "kind,num";
            DataSet ds1 = tab1.SearchData(condition, -1, "*");

            if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
            {
                DataRow[] drs1 = ds1.Tables[0].Select("kind='0'");
                DataRow[] drs2 = ds1.Tables[0].Select("kind='1'");
                if (drs1 != null && drs1.Length > 0)
                {
                    gw1 = new String[drs1.Length];
                    for (int i = 0; i < drs1.Length; i++)
                    {
                        gw1[i] = drs1[i]["gw"].ToString();
                    }
                }


                gw2 = new String[drs2.Length];
                if (drs2 != null && drs2.Length > 0)
                {
                    gw2 = new String[drs2.Length];
                    for (int i = 0; i < drs2.Length; i++)
                    {
                        gw2[i] = drs2[i]["gw"].ToString();
                    }
                }
            }
            tab1.Close();
        }
Beispiel #19
0
        //根据类别名称得到列车数组
        private static String[] GetTrainListByKind(String kindName)
        {
            String[]           arr1      = null;
            JTable             tab1      = new JTable("NEWTRAIN");
            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("TRAINTYPE", kindName));
            DataSet ds1 = tab1.SearchData(condition, -1, "distinct TRAINNAME");

            if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
            {
                arr1 = new String[ds1.Tables[0].Rows.Count];
                int index1 = 0;
                foreach (DataRow dr1 in ds1.Tables[0].Rows)
                {
                    arr1[index1] = dr1[0].ToString();
                    index1++;
                }
            }
            tab1.Close();
            return(arr1);
        }
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="passWord"></param>
        /// <returns></returns>
        public bool Login(String userName, String passWord)
        {
            bool               succ      = false;
            JTable             tab1      = new JTable(TableName);
            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("UserName", userName));
            DataSet ds1 = tab1.SearchData(condition, 1, "*");

            if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
            {
                DataRow dr1 = ds1.Tables[0].Rows[0];
                if (JString.MD5(passWord) == dr1["password"].ToString() ||
                    passWord == dr1["password"].ToString())
                {
                    succ = true;
                    JCookie.SetCookieValue("CurrentLogin", userName);
                    if (dr1["isAdmin"].ToString().Trim() == "1")
                    {
                        HttpContext.Current.Session["isAdmin"] = true;
                    }
                    else
                    {
                        HttpContext.Current.Session["isAdmin"] = false;
                    }

                    dr1["LastLogin"] = DateTime.Now.ToString();
                    if (passWord == dr1["password"].ToString())
                    {
                        dr1["password"] = JString.MD5(passWord);
                    }
                    tab1.Update(ds1.Tables[0]);
                }
            }
            ds1.Dispose();
            tab1.Close();
            return(succ);
        }
        public static void SetData()
        {
            JTable    tab1 = new JTable("QIANYINFEEPROFILE");
            DataTable dt1  = tab1.SearchData(null, -1, "*").Tables[0];

            foreach (DataRow dr1 in dt1.Rows)
            {
                String kind = dr1["QIANYINTYPE"].ToString().Trim();
                if (kind == "0")
                {
                    Fee01 = double.Parse(dr1["Fee1"].ToString());
                    Fee02 = double.Parse(dr1["Fee2"].ToString());
                    Fee03 = double.Parse(dr1["Fee3"].ToString());
                }
                else
                {
                    Fee11 = double.Parse(dr1["Fee1"].ToString());
                    Fee12 = double.Parse(dr1["Fee2"].ToString());
                    Fee13 = double.Parse(dr1["Fee3"].ToString());
                }
            }
            tab1.Close();
        }
Beispiel #22
0
        public static string GetIPs()
        {
            daConnect = JConnect.GetConnect();

            JTable tab1 = new JTable(daConnect, TableName);

            List <SearchField> condition = new List <SearchField>();

            condition.Add(new SearchField("STRID", "KIP"));
            bool    hasdata = tab1.HasData(condition);
            DataRow data1   = tab1.GetFirstDataRow(condition, "STRTEXT");

            tab1.Close();

            if (!hasdata)
            {
                return("");
            }
            else
            {
                return(data1["STRTEXT"].ToString().Trim());
            }
        }
Beispiel #23
0
    private void BindList()
    {
        String num2 = Request.QueryString["num2"];

        if (String.IsNullOrEmpty(num2) == false)
        {
            String             connectString = ConfigurationManager.ConnectionStrings["DefaultConnstring"].ConnectionString;
            JConnect           conn1         = JConnect.GetConnectForWinForm(connectString, WebDbType.SqlServer);
            JTable             tab1          = new JTable(conn1, "my1");
            List <SearchField> condition     = new List <SearchField>();
            condition.Add(new SearchField("盒号", num2));
            DataSet ds1 = tab1.SearchData(condition, -1, "*");
            this.repeater1.DataSource = ds1;
            this.repeater1.DataBind();

            //设置默认的第一条信息
            if (ds1.Tables[0].Rows.Count > 0)
            {
                this.五级分类.Text = ds1.Tables[0].Rows[0]["五级分类"].ToString();
            }
            tab1.Close(true);
        }
    }
        void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            String userid = e.CommandArgument.ToString();

            if (String.IsNullOrEmpty(userid) == false)
            {
                JTable             tab1      = new JTable("MYUSERNAME");
                List <SearchField> condition = new List <SearchField>();
                condition.Add(new SearchField("UserName", userid));
                tab1.DeleteData(condition);
                tab1.Close();

                //更新角色中的相关数据
                JTable tab2 = new JTable();
                tab2.TableName = "JROLEUSERS";
                condition.Clear();
                condition.Add(new SearchField("RoleID", "001"));
                condition.Add(new SearchField("UserID", userid));
                tab2.DeleteData(condition);
                tab2.Close();
                this.Repeater1.DataBind();
            }
        }
Beispiel #25
0
        //人员配置初始化
        public static void PersonInit()
        {
            //得到动车和客车的类型数组
            String[] trainType1 = GetTrainType(false);
            String[] trainType2 = GetTrainType(true);

            String[] gw1 = null;
            String[] gw2 = null;

            JTable tab1 = new JTable("TrainPerson");

            GetTrainGw(out gw1, out gw2);
            if (trainType1 != null && trainType1.Length > 0 && gw1 != null && gw1.Length > 0)
            {
                foreach (String type1 in trainType1)
                {
                    foreach (String gw in gw1)
                    {
                        InsertData(type1, gw, "0", tab1);
                    }
                }
            }


            //设置动车组
            if (trainType2 != null && trainType2.Length > 0 && gw2 != null && gw2.Length > 0)
            {
                foreach (String type1 in trainType2)
                {
                    foreach (String gw in gw2)
                    {
                        InsertData(type1, gw, "1", tab1);
                    }
                }
            }
            tab1.Close();
        }
Beispiel #26
0
        /// <summary>
        /// 将客运机车牵引费导入到系统中
        /// </summary>
        /// <param name="FileName"></param>
        public static void ImportGTTrainDragFeeToSystem(String FileName)
        {
            String FileName1 = HttpContext.Current.Server.MapPath("~/Attachment/" + FileName);
            JTable tab1      = new JTable("GTTRAINDRAGFEE");
            Dictionary <String, object> data1 = new Dictionary <string, object>();

            String[] fs = new String[] { "线别", "交路", "机种", "牵引费", "接触网电费" };

            String[] fs1 = new String[] { "LINETYPE", "CROSSROAD", "MACTYPE", "DRAGFEE", "NETFEE" };


            if (File.Exists(FileName1))
            {
                DataSet ds1 = PubCode.Util.xsldata(FileName1, "Table1");
                if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow dr1 in ds1.Tables[0].Rows)
                    {
                        if (dr1["线别"].ToString().Trim() != String.Empty)
                        {
                            data1.Clear();
                            for (int i = 0; i < fs.Length; i++)
                            {
                                object obj1 = dr1[fs[i]];

                                data1.Add(fs1[i], obj1);
                            }
                            tab1.InsertData(data1);
                        }
                    }
                }

                //得到客专电费的数据
                tab1.Close();
            }
        }
Beispiel #27
0
        /// <summary>
        /// 将客专公司电费导入到系统中
        /// </summary>
        /// <param name="FileName"></param>
        public static void ImportGSCorpElecFeeToSystem(String FileName)
        {
            String FileName1 = HttpContext.Current.Server.MapPath("~/Attachment/" + FileName);
            JTable tab1      = new JTable("GSCORPELECFEE");
            Dictionary <String, object> data1 = new Dictionary <string, object>();

            String[] fs = new String[] { "公司名称", "铁路局", "接触网使用费", "电费" };

            String[] fs1 = new String[] { "CORPNAME", "RWBUREAU", "NETFEE", "ELECFEE" };


            if (File.Exists(FileName1))
            {
                DataSet ds1 = PubCode.Util.xsldata(FileName1, "Table1");
                if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
                {
                    foreach (DataRow dr1 in ds1.Tables[0].Rows)
                    {
                        if (dr1["公司名称"].ToString().Trim() != String.Empty)
                        {
                            data1.Clear();
                            for (int i = 0; i < fs.Length; i++)
                            {
                                object obj1 = dr1[fs[i]];

                                data1.Add(fs1[i], obj1);
                            }
                            tab1.InsertData(data1);
                        }
                    }
                }

                //得到客专电费的数据
                tab1.Close();
            }
        }
        public static void SetData()
        {
            JTable tab1 = new JTable("COMMTRAINWEIGHTPROFILE");

            tab1.OrderBy = "TRAINTYPE";
            DataSet ds1 = tab1.SearchData(null, -1, "*");

            Data.Clear();
            foreach (DataRow dr1 in ds1.Tables[0].Rows)
            {
                CommonTrainData data1 = new CommonTrainData();
                JObject.FillObjectByDataRow(data1, dr1);
                String type1 = dr1["TRAINTYPE"].ToString();

                if (type1 == "25B")
                {
                    Data.Add(ECommTrainType.绿皮车25B, data1);
                }
                else if (type1 == "25G")
                {
                    Data.Add(ECommTrainType.空调车25G, data1);
                }
                else if (type1 == "25T")
                {
                    Data.Add(ECommTrainType.空调车25T, data1);
                }
                else if (type1 == "25K")
                {
                    Data.Add(ECommTrainType.空调车25K, data1);
                }
                else
                {
                }
            }
            tab1.Close();
        }
Beispiel #29
0
        /// <summary>
        /// 车辆消耗备用品
        /// </summary>
        /// <returns></returns>
        public double GetXiaoHaoCost()
        {
            double fee = 0;

            if (this.TrainBigKind == ETrainBigKind.普通列车)
            {
                JTable             tab1      = new JTable("CHEXIANWEIGHTPROFILE");
                List <SearchField> condition = new List <SearchField>();
                tab1.OrderBy = "CHEXIANTYPE";
                DataSet ds1 = tab1.SearchData(null, -1, "*");
                foreach (DataRow dr1 in ds1.Tables[0].Rows)
                {
                    ECommCheXian type1 = (ECommCheXian)(int.Parse(dr1["CHEXIANTYPE"].ToString()));
                    switch (type1)
                    {
                    case ECommCheXian.硬座:
                        fee = fee + this.YinZuo * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;

                    case ECommCheXian.软座:
                        fee = fee + this.RuanZuo * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;

                    case ECommCheXian.开放式硬卧:
                        fee = fee + this.OpenYinWo * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;

                    case ECommCheXian.包房式硬卧:
                        fee = fee + this.CloseYinWo * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;

                    case ECommCheXian.软卧:
                        fee = fee + this.RuanWo * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;

                    case ECommCheXian.高级软卧:
                        fee = fee + this.AdvanceRuanWo * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;

                    case ECommCheXian.餐车:
                        fee = fee + this.CanChe * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;

                    case ECommCheXian.供电车:
                        fee = fee + this.FaDianChe * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;

                    case ECommCheXian.宿营车:
                        fee = fee + this.ShuYinChe * double.Parse(dr1["UNITXHCOST"].ToString());
                        break;
                    }
                }
                tab1.Close();
                fee = fee * this.YongCheDiShu;
            }
            else
            {
                double db = 0;
                if (this.HighTrainBigKind == EHighTrainBigKind.动车200公里)
                {
                    db = double.Parse(JStrInfoBU.GetStrTextByID("200公里动车客运消耗备用备品成本"));
                }
                else
                {
                    db = double.Parse(JStrInfoBU.GetStrTextByID("300公里动车客运消耗备用备品成本"));
                }
                fee = db;                     //分200公里/300公里 标准2个标准
            }
            return(fee);
        }
Beispiel #30
0
        /// <summary>
        /// 根据列车名称得到列车对象
        /// </summary>
        /// <param name="TrainName"></param>
        /// <returns></returns>
        public static CommTrainBU GetTrainObjectByTrainName(String TrainName)
        {
            CommTrainBU obj1 = null;

            if (String.IsNullOrEmpty(TrainName) == false)
            {
                JTable             tab1      = new JTable("Train");
                List <SearchField> condition = new List <SearchField>();
                condition.Add(new SearchField("TrainName", TrainName));
                DataRow dr1 = tab1.GetFirstDataRow(condition, "*");
                if (dr1 != null)
                {
                    obj1               = new CommTrainBU();
                    obj1.Num           = dr1["num"].ToString();
                    obj1.TrainName     = dr1["TrainName"].ToString();
                    obj1.TrainBigKind  = (ETrainBigKind)(int.Parse(dr1["TrainBigKind"].ToString()));
                    obj1.TrainType     = dr1["TrainType"].ToString();
                    obj1.YuXingLiCheng = int.Parse(dr1["YuXingLiCheng"].ToString());

                    obj1.YinZuo        = int.Parse(dr1["YinZuo"].ToString());
                    obj1.RuanZuo       = int.Parse(dr1["RuanZuo"].ToString());
                    obj1.OpenYinWo     = int.Parse(dr1["OpenYinWo"].ToString());
                    obj1.CloseYinWo    = int.Parse(dr1["CloseYinWo"].ToString());
                    obj1.RuanWo        = int.Parse(dr1["RuanWo"].ToString());
                    obj1.AdvanceRuanWo = int.Parse(dr1["AdvanceRuanWo"].ToString());
                    obj1.CanChe        = int.Parse(dr1["CanChe"].ToString());
                    obj1.FaDianChe     = int.Parse(dr1["FaDianChe"].ToString());
                    obj1.ShuYinChe     = int.Parse(dr1["ShuYinChe"].ToString());

                    //车厢价格
                    obj1.YinZuoPrice        = int.Parse(dr1["YinZuoPrice"].ToString());
                    obj1.RuanZuoPrice       = int.Parse(dr1["RuanZuoPrice"].ToString());
                    obj1.OpenYinWoPrice     = int.Parse(dr1["OpenYinWoPrice"].ToString());
                    obj1.CloseYinWoPrice    = int.Parse(dr1["CloseYinWoPrice"].ToString());
                    obj1.RuanWoPrice        = int.Parse(dr1["RuanWoPrice"].ToString());
                    obj1.AdvanceRuanWoPrice = int.Parse(dr1["AdvanceRuanWoPrice"].ToString());
                    obj1.CanChePrice        = int.Parse(dr1["CanChePrice"].ToString());
                    obj1.FaDianChePrice     = int.Parse(dr1["FaDianChePrice"].ToString());
                    obj1.ShuYinChePrice     = int.Parse(dr1["ShuYinChePrice"].ToString());

                    obj1.JiaKuai = (ECommJiaKuai)(int.Parse(dr1["JiaKuai"].ToString()));
                    if (dr1["KongTiaoFee"].ToString().Trim() == "1")
                    {
                        obj1.KongTiaoFee = true;
                    }
                    else
                    {
                        obj1.KongTiaoFee = false;
                    }

                    obj1.XieBieZhengJiaFee = int.Parse(dr1["XieBieZhengJiaFee"].ToString());
                    obj1.QianYinType       = (EQianYinType)(int.Parse(dr1["QianYinType"].ToString()));
                    obj1.GongDianType      = (EGongDianType)(int.Parse(dr1["GongDianType"].ToString()));
                    obj1.WaterCount        = int.Parse(dr1["WaterCount"].ToString());
                    obj1.ServerPerson      = (EServerPerson)(int.Parse(dr1["ServerPerson"].ToString()));
                    obj1.RunHour           = int.Parse(dr1["RunHour"].ToString());

                    obj1.YongCheDiShu = double.Parse(dr1["YongCheDiShu"].ToString());
                    obj1.CheDiShu     = double.Parse(dr1["CheDiShu"].ToString());

                    obj1.Line0 = int.Parse(dr1["Line0"].ToString());
                    obj1.Line1 = int.Parse(dr1["Line1"].ToString());
                    obj1.Line2 = int.Parse(dr1["Line2"].ToString());
                    obj1.Line3 = int.Parse(dr1["Line3"].ToString());
                    obj1.Line4 = int.Parse(dr1["Line4"].ToString());
                    obj1.Line5 = int.Parse(dr1["Line5"].ToString());
                    obj1.Line6 = int.Parse(dr1["Line6"].ToString());
                    obj1.Line7 = int.Parse(dr1["Line7"].ToString());
                    obj1.Line8 = int.Parse(dr1["Line8"].ToString());

                    obj1.HighTrainBianZhu = (EHighTrainBianZhu)(int.Parse(dr1["HighTrainBianZhu"].ToString()));
                    obj1.HighTrainBigKind = (EHighTrainBigKind)(int.Parse(dr1["HighTrainBigKind"].ToString()));
                    obj1.CunZengMoShi     = (ECunZengMoShi)(int.Parse(dr1["CunZengMoShi"].ToString()));
                }
                tab1.Close();
            }
            return(obj1);
        }