private void GetFactoryType()
{
int id = Convert.ToInt32(Request.QueryString["id"]);
FactoryTypeBLL ftb = new FactoryTypeBLL();
List <FactoryTypeModel> list = new List <FactoryTypeModel>();
ftb.GetFactoryTypeInfo(id, out list);
if (list.Count > 0)
{
FactoryTypeModel model = (FactoryTypeModel)list[0];
name_txt.Text = model.FactoryTypeName;
namep_txt.Text = model.ProductSecondLevelNameDefalut;
}
}
/// <summary>
/// 得到厂家类别未被使用过的
/// </summary>
/// <returns></returns>
public List <FactoryTypeModel> GetFactoryTypeInfoByNotUsed()
{
List <FactoryTypeModel> olist = new List <FactoryTypeModel>();
SqlConnection sqlConnection = new SqlConnection(Config.ConnectionString);
SqlCommand sqlcommand = new SqlCommand("sp_FactoryTypeInfo", sqlConnection);
sqlcommand.CommandType = CommandType.StoredProcedure;
SqlParameter _op = new SqlParameter("@op", "Select");
_op.Direction = ParameterDirection.Input;
sqlcommand.Parameters.Add(_op);
SqlParameter _FactoryTypeId = new SqlParameter("@FactoryTypeId", (Object)DBNull.Value);
_FactoryTypeId.Direction = ParameterDirection.Input;
sqlcommand.Parameters.Add(_FactoryTypeId);
SqlParameter _FactoryTypeName = new SqlParameter("@FactoryTypeName", (Object)DBNull.Value);
_FactoryTypeName.Direction = ParameterDirection.Input;
sqlcommand.Parameters.Add(_FactoryTypeName);
SqlParameter _ProductSecondLevelNameDefalute = new SqlParameter("@ProductSecondLevelNameDefalut", (Object)DBNull.Value);
_ProductSecondLevelNameDefalute.Direction = ParameterDirection.Input;
sqlcommand.Parameters.Add(_ProductSecondLevelNameDefalute);
SqlParameter _CreatorId = new SqlParameter("@CreatorId", (Object)DBNull.Value);
_CreatorId.Direction = ParameterDirection.Input;
sqlcommand.Parameters.Add(_CreatorId);
SqlParameter _result = new SqlParameter("@result", SqlDbType.VarChar, 10);
_result.Direction = ParameterDirection.Output;
sqlcommand.Parameters.Add(_result);
try
{
sqlConnection.Open();
using (IDataReader idr = sqlcommand.ExecuteReader())
{
while (idr.Read())
{
FactoryTypeModel oCModel = new FactoryTypeModel();
if (idr["FactoryTypeId"] != DBNull.Value)
{
oCModel.FactoryTypeId = (int)idr["FactoryTypeId"];
}
if (idr["FactoryTypeName"] != DBNull.Value)
{
oCModel.FactoryTypeName = (string)idr["FactoryTypeName"];
}
if (idr["ProductSecondLevelNameDefalut"] != DBNull.Value)
{
oCModel.ProductSecondLevelNameDefalut = (string)idr["ProductSecondLevelNameDefalut"];
}
if (idr["CreatorId"] != DBNull.Value)
{
oCModel.CreatorId = (int)idr["CreatorId"];
}
if (idr["CreateTime"] != DBNull.Value)
{
oCModel.CreateTime = (DateTime)idr["CreateTime"];
}
olist.Add(oCModel);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlConnection.Close();
}
return(olist);
}
