コード例 #1
0
ファイル: Car.cs プロジェクト: lexzh/Myproject
 public DataTable GetPhoneNumTextByCarid(string string_0)
 {
     if (string.IsNullOrEmpty(string_0))
     {
         return null;
     }
     SqlDataAccess access = new SqlDataAccess();
     string str = string.Concat(new object[] { " select Param from GpsCarSetParam where CarID=", string_0, "and MsgType=", 0x4017 });
     object returnBySql = access.GetReturnBySql(str);
     if (returnBySql == null)
     {
         return null;
     }
     string str2 = returnBySql.ToString();
     string[] separator = new string[] { "#" };
     DataTable table = new DataTable();
     DataColumn column = new DataColumn("Flag");
     DataColumn column2 = new DataColumn("Phone");
     DataColumn column3 = new DataColumn("Name");
     table.Columns.AddRange(new DataColumn[] { column, column2, column3 });
     string[] strArray2 = str2.Split(separator, StringSplitOptions.RemoveEmptyEntries);
     for (int i = 0; i < strArray2.Length; i++)
     {
         DataRow row = table.NewRow();
         string[] strArray3 = strArray2[i].Split(new char[] { ',' });
         if (strArray3.Length == 3)
         {
             row["Flag"] = strArray3[0];
             row["Phone"] = strArray3[1];
             row["Name"] = strArray3[2];
             table.Rows.Add(row);
         }
     }
     return table;
 }