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