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);
}
