/// <summary> /// 得到某年的税金 /// </summary> /// <param name="year"></param> /// <returns></returns> public static double GetRate(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 + "")); DataRow dr1 = tab1.GetFirstDataRow(condition, "srate"); if (dr1 != null) { result = double.Parse(dr1[0].ToString()); } else { condition.Clear(); dr1 = tab1.GetFirstDataRow(null, "srate"); if (dr1 != null) { result = double.Parse(dr1[0].ToString()); } } tab1.Close(); return(result); }
/// <summary> /// 得到动车的满员人数 /// </summary> /// <returns></returns> private int GetTotalPersonForHighTrain() { int total = 0; if (this.TrainBigKind == ETrainBigKind.动车) { JTable tab1 = new JTable("HighTrainProfile"); List <SearchField> condition = new List <SearchField>(); if (String.IsNullOrEmpty(this.TrainType) == false) { condition.Add(new SearchField("HighTrainType", TrainType)); } else { condition.Add(new SearchField("HighTrainType", "-1")); } DataRow dr1 = tab1.GetFirstDataRow(condition, "*"); if (dr1 != null) { for (int i = 1; i <= 4; i++) { total = total + int.Parse(dr1["PCount" + i].ToString()); } } tab1.Close(); } return(total); }
/// <summary> /// 计算动车组的票价总收入 /// </summary> /// <param name="HighTrainType"></param> /// <returns></returns> private double GetTotalShouruForHighTrain() { double Fee = 0; if (this.TrainBigKind == ETrainBigKind.动车) { JTable tab1 = new JTable("HighTrainProfile"); List <SearchField> condition = new List <SearchField>(); if (String.IsNullOrEmpty(this.TrainType) == false) { condition.Add(new SearchField("HighTrainType", TrainType)); } else { condition.Add(new SearchField("HighTrainType", "-1")); } DataRow dr1 = tab1.GetFirstDataRow(condition, "*"); if (dr1 != null) { for (int i = 1; i <= 4; i++) { Fee = Fee + this.YuXingLiCheng * double.Parse(dr1["PCount" + i].ToString()) * double.Parse(dr1["Rate" + i].ToString()); } } tab1.Close(); } return(Fee); }
/// <summary> /// 得到加快的费率 /// </summary> /// <param name="type1"></param> /// <returns></returns> private double GetJiaKuaiFeeByKind(ECommJiaKuai type1) { double fee0 = 0; JTable tab1 = new JTable("JiaKuaiProfile"); List <SearchField> condition = new List <SearchField>(); if (type1 == ECommJiaKuai.加快) { condition.Add(new SearchField("JiaKuaiType", "jk1")); } else if (type1 == ECommJiaKuai.特快) { condition.Add(new SearchField("JiaKuaiType", "jk2")); } else if (type1 == ECommJiaKuai.特快附加) { condition.Add(new SearchField("JiaKuaiType", "jk3")); } else { condition.Add(new SearchField("JiaKuaiType", "-1")); } DataRow dr1 = tab1.GetFirstDataRow(condition, "*"); if (dr1 != null) { fee0 = double.Parse(dr1["Fee"].ToString()); } tab1.Close(); return(fee0); }
/// <summary> /// 得到所有别名的List项 /// </summary> /// <param name="A"></param> /// <returns></returns> public List <String> GetAlias(String A) { List <String> list0 = new List <string>(); if (String.IsNullOrEmpty(A) == false) { JTable tab1 = new JTable("TRAINALIAS"); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("TRAINNAME", A)); DataRow dr1 = tab1.GetFirstDataRow(condition, " TRAINALIAS "); if (dr1 != null) { String t1 = dr1[0].ToString(); if (String.IsNullOrEmpty(t1) == false) { String[] s1 = t1.Replace(",", ",").Split(','); foreach (String m in s1) { if (list0.Contains(m) == false) { list0.Add(m); } } } } tab1.Close(); //把自己加入 if (list0.Contains(A) == false) { list0.Add(A); } } return(list0); }
/// <summary> /// 得到下一个编号 /// </summary> /// <returns></returns> public static int GetNextNum(String TableName, String ColumnName) { int result = 1; JTable tab1 = null; try { tab1 = new JTable(TableName); DataRow dr1 = tab1.GetFirstDataRow(null, "max(" + ColumnName + ") as max1"); if (dr1 != null && dr1[0].ToString() != String.Empty) { int.TryParse(dr1[0].ToString(), out result); result++; } } catch (Exception err) { result = 1; } finally { if (tab1 != null) { tab1.Close(); } } return(result); }
/// <summary> /// 得到满足条件的第一行数据 /// </summary> /// <param name="condition">查询条件</param> /// <param name="Fields">数据字段</param> /// <returns>满足条件的行</returns> public DataRow GetFirstDataRow(List <SearchField> condition, params String[] Fields) { JTable tab1 = new JTable(daConnect, TableName); DataRow data1 = tab1.GetFirstDataRow(condition, Fields); tab1.Close(); return(data1); }
/// <summary> /// 得到下一个用户的编号 /// </summary> /// <returns></returns> public int GetNextNum() { int num1 = 1; JTable tab1 = new JTable(this.daConnect, TableName); DataRow dr1 = tab1.GetFirstDataRow(null, "max(num)"); if (dr1 != null && dr1[0].ToString() != String.Empty) { num1 = int.Parse(dr1[0].ToString()) + 1; } return(num1); }
/// <summary> /// 得到动车的折扣计算 /// </summary> /// <returns></returns> private static double GetDiscount(EHighTrainType trainType, TrainLine Line, int YunXingLiCheng) { double result = 0; String RateName = String.Empty; //300公里的动车 if (trainType == EHighTrainType.CRH2C || trainType == EHighTrainType.CRH380A || trainType == EHighTrainType.CRH380AL || trainType == EHighTrainType.CRH380B || trainType == EHighTrainType.CRH380BL) //增加了动车车型的CRH380B和CRH380BL的处理 { RateName = "Rate3"; } else { RateName = "Rate2"; if (Line != null) { foreach (LineNode node1 in Line.Nodes) { int type1 = int.Parse(node1.LineType); if (type1 > 2) { RateName = "Rate1"; //普通线路 break; } } } } //计算动车的折扣 if (String.IsNullOrEmpty(RateName) == false) { JTable tab1 = new JTable("HIGHTRAINPRICERATE"); tab1.OrderBy = "LICHENG desc"; List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("LICHENG", YunXingLiCheng + "", SearchOperator.SmallerAndEqual, SearchFieldType.NumericType)); DataRow dr1 = tab1.GetFirstDataRow(condition, RateName); if (dr1 != null) { result = double.Parse(dr1[0].ToString()); result = result / 100d; } tab1.Close(); } return(result); }
//得到编制的值 private double GetValue(JTable tab1, String gw, String traintype) { double result = 0; List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("gw", gw)); condition.Add(new SearchField("traintype", traintype)); DataRow dr = tab1.GetFirstDataRow(condition, "pcount"); if (dr != null) { result = double.Parse(dr[0].ToString()); } return(result); }
/// <summary> /// 得到不同车厢的重量配置 /// </summary> /// <param name="type1"></param> /// <returns></returns> private static double GetCheXianWeight(ECommCheXian type1) { double d1 = 0; JTable tab1 = new JTable("CHEXIANWEIGHTPROFILE"); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("CHEXIANTYPE", (int)type1 + "", SearchFieldType.NumericType)); DataRow dr1 = tab1.GetFirstDataRow(condition, "Weight"); if (dr1 != null) { d1 = double.Parse(dr1[0].ToString()); } tab1.Close(); return(d1); }
//得到下一个序号 public static int GetNextNum() { int result = 1; JTable tab1 = new JTable("CHANGJIAOQYFEE"); DataRow dr1 = tab1.GetFirstDataRow(null, "max(num)"); if (dr1 != null) { if (dr1[0].ToString() != String.Empty) { result = int.Parse(dr1[0].ToString()) + 1; } } tab1.Close(); return(result); }
/// <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); }
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(); }
/// <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); }
/// <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); }
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()); } }
/// <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); }
/// <summary> /// 获取指定运行里程下所有的票价信息 /// </summary> /// <param name="Yxlc">运行里程</param> /// <returns></returns> public bool GetPriceInfo(int Yxlc, int trainType) { bool result = false; JTable tab = new JTable("TicketPrice"); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("StartMile", Yxlc.ToString(), SearchOperator.SmallerAndEqual, SearchFieldType.NumericType)); condition.Add(new SearchField("EndMile", Yxlc.ToString(), SearchOperator.BiggerAndEqual, SearchFieldType.NumericType)); condition.Add(new SearchField("TrainType", trainType.ToString(), SearchOperator.Equal, SearchFieldType.NumericType)); DataRow dr = tab.GetFirstDataRow(condition, new string[] { "*" }); string sql = tab.CommandText; if (dr != null) { if (!Convert.IsDBNull(dr["YZPrice"]) && dr["YZPrice"] != null) { this.YZPrice = Convert.ToDouble(dr["YZPrice"]); } if (!Convert.IsDBNull(dr["RZPrice"]) && dr["RZPrice"] != null) { this.RZPrice = Convert.ToDouble(dr["RZPrice"]); } if (!Convert.IsDBNull(dr["PTJKPrice"]) && dr["PTJKPrice"] != null) { this.PTJKPrice = Convert.ToDouble(dr["PTJKPrice"]); } if (!Convert.IsDBNull(dr["KSJKPrice"]) && dr["KSJKPrice"] != null) { this.KSJKPrice = Convert.ToDouble(dr["KSJKPrice"]); } if (!Convert.IsDBNull(dr["YWSPrice"]) && dr["YWSPrice"] != null) { this.YWSPrice = Convert.ToDouble(dr["YWSPrice"]); } if (!Convert.IsDBNull(dr["YWZPrice"]) && dr["YWZPrice"] != null) { this.YWZPrice = Convert.ToDouble(dr["YWZPrice"]); } if (!Convert.IsDBNull(dr["YWXPrice"]) && dr["YWXPrice"] != null) { this.YWXPrice = Convert.ToDouble(dr["YWXPrice"]); } if (!Convert.IsDBNull(dr["RWSPrice"]) && dr["RWSPrice"] != null) { this.RWSPrice = Convert.ToDouble(dr["RWSPrice"]); } if (!Convert.IsDBNull(dr["RWZPrice"]) && dr["RWZPrice"] != null) { this.RWZPrice = Convert.ToDouble(dr["RWZPrice"]); } if (!Convert.IsDBNull(dr["RWXPrice"]) && dr["RWXPrice"] != null) { this.RWXPrice = Convert.ToDouble(dr["RWXPrice"]); } if (!Convert.IsDBNull(dr["KDPrice"]) && dr["KDPrice"] != null) { this.KDPrice = Convert.ToDouble(dr["KDPrice"]); } result = true; } else { result = false;//没有找到对应里程的数据 } tab.Dispose(); tab.Close(); return(result); }
//更新数据 public bool UpdateData(Dictionary <String, object> data1) { bool result = false; List <SearchField> condition = new List <SearchField>(); JTable tab1 = new JTable(); JTable tab2 = new JTable(); JTable tab3 = new JTable("LineStation"); try { tab1.MyConnect.BeginTrans(); //更新CHANGJIAOQYFEE表中信息 tab1.TableName = "CHANGJIAOQYFEE"; String lineid = String.Empty; if (data1["lineid"] == null || data1["lineid"].ToString() == String.Empty || data1["lineid"].ToString() == "-1") { data1.Remove("lineid"); tab1.InsertData(data1); tab2.TableName = "CHANGJIAOQYFEE"; condition.Clear(); condition.Add(new SearchField("linename", data1["linename"].ToString().Trim())); tab2.OrderBy = "lineid desc"; DataRow dr1 = tab2.GetFirstDataRow(condition, "lineid"); if (dr1 != null) { lineid = dr1["lineid"].ToString().Trim(); } tab2.Close(); } else { lineid = data1["lineid"].ToString(); condition.Clear(); condition.Add(new SearchField("lineid", data1["lineid"].ToString().Trim(), SearchFieldType.NumericType)); tab1.EditData(data1, condition); } //更新LineStation中的相关数据 if (String.IsNullOrEmpty(lineid) == false) { //线路 String error = String.Empty; String lineName = data1["linename"].ToString(); List <String> arrlineID = CheckLine(lineName, out error); int fee1 = int.Parse(data1["fee1"].ToString()); int fee2 = int.Parse(data1["fee2"].ToString()); int fee3 = 0; if (String.IsNullOrEmpty(error)) { Dictionary <String, object> data2 = new Dictionary <string, object>(); data2["checkflag"] = "1"; JTable tab4 = new JTable("CHANGJIAOQYFEE"); condition.Clear(); condition.Add(new SearchField("lineid", lineid, SearchFieldType.NumericType)); tab4.EditData(data2, condition); tab4.Close(); //线路站点 String jiaolu = data1["jiaolu"].ToString(); String[] arrJiaolu = jiaolu.Replace("~", "-").Replace("~", "-").Replace("-", "-").Split('-'); for (int i = 0; i < arrJiaolu.Length - 1; i++) { //调整字符中的分隔符。 String[] a0 = arrJiaolu[i].Trim().Replace("、", ";").Replace(",", ";").Replace(",", ";").Replace(".", ";") .Replace("(", ";").Replace(")", "").Replace("(", ";").Replace(")", "").Split(';'); String[] a1 = arrJiaolu[i + 1].Trim().Replace("、", ";").Replace(",", ";").Replace(",", ";").Replace(".", ";") .Replace("(", ";").Replace(")", "").Replace("(", ";").Replace(")", "").Split(';'); for (int j = 0; j < a0.Length; j++) { a0[j] = a0[j].Trim(); if (j > 0) { if (a0[j] == "东" || a0[j] == "南" || a0[j] == "西" || a0[j] == "北") { a0[j] = a0[j - 1] + a0[j]; } } } for (int j = 0; j < a1.Length; j++) { a1[j] = a1[j].Trim(); if (j > 0) { if (a1[j] == "东" || a1[j] == "南" || a1[j] == "西" || a1[j] == "北") { a1[j] = a1[j - 1] + a1[j]; } } } //提交数据更新 foreach (String Astation in a0) { foreach (String Bstation in a1) { UpdateLineStation(tab3, arrlineID, Astation, Bstation, fee1, fee2, fee3); } } } } else { JAjax.Alert(error); } } //提交事务处理 tab1.MyConnect.CommitTrans(); result = true; } catch (Exception err) { tab1.MyConnect.RollBackTrans(); ; } tab1.Close(); tab2.Close(); tab3.Close(); return(result); }