|  |  | 
 |  |  |                 HGridString = HGridString.Substring(0, HGridString.Length - 1); | 
 |  |  |  | 
 |  |  |                 oCN.RunProc("Delete from Xt_grdAlignment_WMES where HUserName='" + user + "' and HModName='" + HModName + "' "); | 
 |  |  |                 oCN.RunProc("insert into Xt_grdAlignment_WMES (HUserName,HModName,HGridString,HFixCols" + | 
 |  |  |  | 
 |  |  |                 string sql = "insert into Xt_grdAlignment_WMES (HUserName,HModName,HGridString,HFixCols" + | 
 |  |  |                     ",HFontSize,HHeadTextHeight,HTextHeight,HSortFlag,HSelTotal,HColumnWidth,HPageSize" + | 
 |  |  |                     ")  values('" + user + "','" + HModName + "','" + HGridString + "'," + (omdelMian.HFixCols == "" ? "0" : omdelMian.HFixCols) + | 
 |  |  |                     "," + (omdelMian.HFontSize == "" ? "0" : omdelMian.HFontSize) + ",0" + | 
 |  |  |                     ",0,'" + omdelMian.HSortFlag + "','" + omdelMian.HSelTotal + "'" + | 
 |  |  |                     "," + (omdelMian.HColumnWidth == "" ? "0" : omdelMian.HColumnWidth) + "," + (omdelMian.HPageSize == "" ? "0" : omdelMian.HPageSize) + ")"); | 
 |  |  |                     "," + (omdelMian.HColumnWidth == "" ? "0" : omdelMian.HColumnWidth) + "," + ((omdelMian.HPageSize == null || omdelMian.HPageSize == "") ? "0" : omdelMian.HPageSize) + ")"; | 
 |  |  |  | 
 |  |  |                 oCN.RunProc(sql); | 
 |  |  |  | 
 |  |  |  | 
 |  |  |                 objJsonResult.code = "1"; | 
 |  |  | 
 |  |  |                     foreach (DataRow row in ds.Tables[0].Rows) | 
 |  |  |                     { | 
 |  |  |                         TreeModel Three = new TreeModel(); | 
 |  |  |                         Three.id = ds.Tables[0].Rows[0]["HInterID"].ToString(); | 
 |  |  |                         Three.title = ds.Tables[0].Rows[0]["HName"].ToString(); | 
 |  |  |                         Three.id = row["HInterID"].ToString(); | 
 |  |  |                         Three.title = row["HName"].ToString(); | 
 |  |  |                         treeModels.Add(Three); | 
 |  |  |                     } | 
 |  |  |                 } |