/// <summary>
///
/// </summary>
/// <param name="qualityControl"></param>
/// <returns></returns>
public int InsertInterroomQualityControl(InterroomQualityControl qualityControl)
{
string sql = "INSERT INTO InterroomQualityControl(InterroomQualityControlId, ProductName, Description, Img, CategoryId, CategoryName, Concentration, SingleSpecification, PackingSpecification, Status, StorageCondition, UsefulLife, PreservationStability, ProductMatrix, ContainedItems, CreateTime, ModifyTime, Enable) VALUES";
sql += "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}', '{15}','{16}',{17});";
sql = string.Format(sql,
qualityControl.InterroomQualityControlId, //0
qualityControl.ProductName, //1
qualityControl.Description, //2
qualityControl.Img, //3
qualityControl.CategoryId, //4
qualityControl.CategoryName, //5
qualityControl.Concentration, //6
qualityControl.SingleSpecification, //7
qualityControl.PackingSpecification, //8
qualityControl.Status, //9
qualityControl.StorageCondition, //10
qualityControl.UsefulLife, //11
qualityControl.PreservationStability, //12
qualityControl.ProductMatrix, //13
qualityControl.ContainedItems, //14
qualityControl.CreateTime, //15
qualityControl.ModifyTime, //16
qualityControl.Enable); //17
return(SQLHelper.Update(sql));
}
/// <summary>
/// 根据id精确查询质控品名称
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public InterroomQualityControl GetInterroomQualityControlDetail(string id)
{
InterroomQualityControl interroomQualityControl = null;
string sql = "SELECT * FROM InterroomQualityControl WHERE InterroomQualityControlId = '{0}'";
sql = string.Format(sql, id);
SqlDataReader reader = SQLHelper.GetReader(sql);
if (reader.Read())
{
interroomQualityControl = new InterroomQualityControl();
interroomQualityControl.InterroomQualityControlId = reader["InterroomQualityControlId"].ToString();
interroomQualityControl.ProductName = reader["ProductName"].ToString();
interroomQualityControl.Description = reader["Description"].ToString();
interroomQualityControl.Img = reader["Img"].ToString();
interroomQualityControl.CategoryId = (reader["CategoryId"] == null) ? "" : reader["CategoryId"].ToString();
interroomQualityControl.CategoryName = (reader["CategoryName"] == null) ? "" : reader["CategoryName"].ToString();
interroomQualityControl.Concentration = reader["Concentration"].ToString();
interroomQualityControl.SingleSpecification = reader["SingleSpecification"].ToString();
interroomQualityControl.PackingSpecification = reader["PackingSpecification"].ToString();
interroomQualityControl.Status = reader["Status"].ToString();
interroomQualityControl.StorageCondition = reader["StorageCondition"].ToString();
interroomQualityControl.UsefulLife = reader["UsefulLife"].ToString();
interroomQualityControl.PreservationStability = reader["PreservationStability"].ToString();
interroomQualityControl.ProductMatrix = reader["ProductMatrix"].ToString();
interroomQualityControl.ContainedItems = reader["ContainedItems"].ToString();
interroomQualityControl.CreateTime = Convert.ToDateTime(reader["CreateTime"]);
interroomQualityControl.ModifyTime = Convert.ToDateTime(reader["ModifyTime"]);
interroomQualityControl.Enable = Convert.ToInt16(reader["Enable"]);
}
return(interroomQualityControl);
}
public ActionResult ModifyInterroomQualityControl(InterroomQualityControl interroomQuaControl)
{
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase File = files["Img"] != null ? files["Img"] : null;//根据name属性获取文件
string img_path = UploadFile(File);
interroomQuaControl.Img = img_path;
DateTime dt = DateTime.Now;
interroomQuaControl.ModifyTime = dt;
int ret = new InterroomQualityControlManager().UpdateInterroomQualityControl(interroomQuaControl);
return(RedirectToRoute("Admin_route2", new { controller = "Home", action = "InterroomQualityControl" }));
}
/// <summary>
/// 室间质控品明细动作
/// </summary>
/// <returns></returns>
public ActionResult GetInterroomQualityControlProductDetail()
{
Dictionary <string, string> d = new Dictionary <string, string>();
string id = RouteData.Values["id"].ToString();
string proId = "";
d = ParseUrlId(id);
InterroomQualityControl iqc = null;
if (GetUrlFiled(d, "id") != "")
{
proId = GetUrlFiled(d, "id");
iqc = new InterroomQualityControlManager().GetInterroomQualityControlDetail(proId);
}
@ViewBag.iqc = iqc;
return(PartialView("ProductDetail"));
}
public int UpdateInterroomQualityControl(InterroomQualityControl qualityControl)
{
bool deleteFlag = true;
string oldImageName = GetImgPath(qualityControl.InterroomQualityControlId);
if (qualityControl.Img == String.Empty)
{
qualityControl.Img = oldImageName;
deleteFlag = false;
}
qualityControl.CategoryId = new ProductCategoryManager().GetProductCategoryId(qualityControl.CategoryName);
int ret = new InterroomQualityControlService().UpdateInterroomQualityControl(qualityControl);
if (ret > 0 && deleteFlag)
{
new Common().DeleteFile(oldImageName, fileType.ImageType);
}
return(ret);
}
/// <summary>
/// 更新质控品信息
/// </summary>
/// <param name="qualityControl"></param>
/// <returns></returns>
public int UpdateInterroomQualityControl(InterroomQualityControl qualityControl)
{
string sql = "UPDATE InterroomQualityControl SET ProductName = '{1}', Description = '{2}', Img = '{3}', CategoryId = '{4}', CategoryName = '{5}', Concentration = '{6}', SingleSpecification = '{7}', PackingSpecification = '{8}', Status = '{9}', StorageCondition = '{10}', UsefulLife = '{11}', PreservationStability = '{12}', ProductMatrix = '{13}', ContainedItems = '{14}', ModifyTime = '{15}' WHERE InterroomQualityControlId = '{0}';";
sql = string.Format(sql,
qualityControl.InterroomQualityControlId, //0
qualityControl.ProductName, //1
qualityControl.Description, //2
qualityControl.Img, //3
qualityControl.CategoryId, //4
qualityControl.CategoryName, //5
qualityControl.Concentration, //6
qualityControl.SingleSpecification, //7
qualityControl.PackingSpecification, //8
qualityControl.Status, //9
qualityControl.StorageCondition, //10
qualityControl.UsefulLife, //11
qualityControl.PreservationStability, //12
qualityControl.ProductMatrix, //13
qualityControl.ContainedItems, //14
qualityControl.ModifyTime); //15
return(SQLHelper.Update(sql));
}
public int InsertInterroomQualityControl(InterroomQualityControl qualityControl)
{
qualityControl.CategoryId = new ProductCategoryManager().GetProductCategoryId(qualityControl.CategoryName);
return(new InterroomQualityControlService().InsertInterroomQualityControl(qualityControl));
}
