public Area_Out GetWorkShopOfArea(string input) { Area_Out json = new Area_Out(); RRsWorkShop workShop = null; Area_In model = null; try { model = Newtonsoft.Json.JsonConvert.DeserializeObject <Area_In>(input); string strSql = "select * from TAB_Org_WorkShop where strAreaGUID = @strAreaGUID order by strWorkShopName"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strAreaGUID", model.AreaGUID), }; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; json.data = new List <RRsWorkShop>(); foreach (DataRow row in table.Rows) { workShop = new RRsWorkShop(); workShop.strAreaGUID = row["strAreaGUID"].ToString(); workShop.strWorkShopGUID = row["strWorkShopGUID"].ToString(); workShop.strWorkShopName = row["strWorkShopName"].ToString(); json.data.Add(workShop); } json.result = "0"; json.resultStr = "获取车间成功"; } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); throw ex; } return(json); }
public Name_Out GetWorkShopGUIDByName(string input) { Name_Out json = new Name_Out(); Name_In model = null; RRsWorkShop work = new RRsWorkShop(); try { model = Newtonsoft.Json.JsonConvert.DeserializeObject <Name_In>(input); string strSql = "select strWorkShopGUID from TAB_Org_WorkShop where strWorkShopName =@strWorkShopName"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strWorkShopName", model.WorkShopName), }; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; if (table.Rows.Count > 0) { DataRow row = table.Rows[0]; work.strWorkShopGUID = row["strWorkShopGUID"].ToString(); json.data = work; json.result = "0"; json.resultStr = "获取车间GUID成功"; } else { work.strWorkShopGUID = ""; json.data = work; json.result = "0"; json.resultStr = "未找到此名称的GUID"; } } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); throw ex; } return(json); }