public static Model.ProductCenterModel[] DataSetToModel(DataTable dt) { Model.ProductCenterModel[] models = new Model.ProductCenterModel[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { models[i] = DataRowToModel(dt.Rows[i]); } return(models); }
public string DelProduct(HttpContext context) { int ID = Convert.ToInt32(context.Request["ID"]); DBOperation.DBOperationManagment dbm = new DBOperation.DBOperationManagment(); string msg = string.Empty; string error = string.Empty; string jsonStr = string.Empty; try { if (dbm.Open()) { Dictionary <string, string> r1 = new Dictionary <string, string>(); Model.ProductCenterModel pcm = Factory.GetExecution().SelectByID <Model.ProductCenterModel>(ID); if (pcm != null) { DataTable dt = DAL.GetDataTable.GetProductModelDetail(pcm.ProductModelID, dbm); if (dt != null && dt.Rows.Count > 0) { msg = "false"; error = "此产品型号已被绑定,不能删除!"; r1.Add("msg", msg); r1.Add("error", error); jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(r1); context.Response.Write(jsonStr); return(jsonStr); } } if (Factory.GetExecution().Delete <Model.ProductCenterModel>(ID)) { msg = "true"; } else { msg = "false"; error = "删除失败!"; } r1.Add("msg", msg); r1.Add("error", error); jsonStr = Newtonsoft.Json.JsonConvert.SerializeObject(r1); context.Response.Write(jsonStr); return(jsonStr); } } catch (Exception ex) { LogTool.LogWriter.WriteError("读取资源出错,!", ex); } finally { dbm.Close(); } return(jsonStr); }
public static Model.ProductCenterModel DataRowToModel(DataRow row) { if (row != null) { DataTable dt = row.Table; Model.ProductCenterModel model = new Model.ProductCenterModel(); if (dt.Columns.Contains("ID") && row["ID"] != DBNull.Value && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (dt.Columns.Contains("Language") && row["Language"] != DBNull.Value && row["Language"].ToString() != "") { model.Language = int.Parse(row["Language"].ToString()); } if (dt.Columns.Contains("ProductModelID") && row["ProductModelID"] != DBNull.Value) { model.ProductModelID = row["ProductModelID"].ToString(); } if (dt.Columns.Contains("ProductID") && row["ProductID"] != DBNull.Value) { model.ProductID = row["ProductID"].ToString(); } if (dt.Columns.Contains("ProductModel") && row["ProductModel"] != DBNull.Value) { model.ProductModel = row["ProductModel"].ToString(); } if (dt.Columns.Contains("CreateTime") && row["CreateTime"] != DBNull.Value && !string.IsNullOrEmpty(row["CreateTime"].ToString())) { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (dt.Columns.Contains("UpdateTime") && row["UpdateTime"] != DBNull.Value && !string.IsNullOrEmpty(row["UpdateTime"].ToString())) { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } return(model); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { int ProductType = Convert.ToInt32(Request["ProductType"]); int Language = Convert.ToInt32(Request.Form["language"]); DBOperation.DBOperationManagment dbm = new DBOperation.DBOperationManagment(); try { dbm.Open(); if (view_action == "notify") { Model.ProductCenter cp = Factory.GetExecution().SelectByID <Model.ProductCenter>(requestID); if (cp != null) { List <Model.ProductCenter> pcList = Factory.GetExecution().GetByWhereSqlList <Model.ProductCenter>(" and ProductType=" + ProductType + " and Language=" + Language, " UpdateTime desc"); if (pcList != null && pcList.Count > 0 && cp.Language != Language) { Common.MessageBox.ShowLayer(this, "同一种语言只能新建一个产品分类!", 2); return; } cp.Language = Language; cp.ProductTitle = txtTitle.Text; cp.CreatePeople = txtCreatePeople.Text; cp.LogoUrl = HomePageUploadFileName.Text; cp.CreatePeople = txtCreatePeople.Text; cp.UpdateTime = DateTime.Now; cp.Keywords = txtKeywords.Text.Trim(); cp.Description = txtDescription.Text.Trim(); bool flag2 = true; //flag2 = DAL.GetDataTable.Delete<Model.ProductCenterModel>(cp.ProductID); if (!string.IsNullOrEmpty(hfArrList.Value)) { List <Prm> list = JsonConvert.DeserializeObject <List <Prm> >(hfArrList.Value); foreach (Prm item in list) { if (!string.IsNullOrEmpty(item.ProductModel)) { DataTable dt = DAL.GetDataTable.IsExistProductModel(item.ProductModel, cp.ProductID, dbm); if (dt != null && dt.Rows.Count > 0) { } else { Model.ProductCenterModel pcm = new Model.ProductCenterModel(); pcm.ProductModelID = RuleUtility.IDsCreater.GetCreater().CreateProductModelID(dbm); pcm.Language = Language; pcm.ProductID = cp.ProductID; pcm.ProductModel = item.ProductModel; pcm.CreateTime = DateTime.Now; pcm.UpdateTime = DateTime.Now; flag2 = Factory.GetExecution().Add <Model.ProductCenterModel>(pcm); } } } } bool flag = Factory.GetExecution().Update <Model.ProductCenter>(cp); if (flag && flag2) { Common.MessageBox.ShowRedirect(this, "/ProductCenter/ServoDriver.aspx?ProductType=" + ProductType); } } } else { List <Model.ProductCenter> pcList = Factory.GetExecution().GetByWhereSqlList <Model.ProductCenter>(" and ProductType=" + ProductType + " and Language=" + Language, " UpdateTime desc"); if (pcList != null && pcList.Count > 0) { Common.MessageBox.ShowLayer(this, "同一种语言只能新建一个产品分类!", 2); return; } Model.ProductCenter cp = new Model.ProductCenter(); cp.ProductID = RuleUtility.IDsCreater.GetCreater().CreateProductID(dbm); cp.Language = Language; cp.ProductType = ProductType; cp.ProductTitle = txtTitle.Text; cp.CreatePeople = txtCreatePeople.Text; cp.LogoUrl = HomePageUploadFileName.Text; cp.CreatePeople = txtCreatePeople.Text; cp.UpdateTime = DateTime.Now; cp.CreateTime = DateTime.Now; cp.Keywords = txtKeywords.Text.Trim(); cp.Description = txtDescription.Text.Trim(); bool flag1 = Factory.GetExecution().Add <Model.ProductCenter>(cp); bool flag2 = true; if (!string.IsNullOrEmpty(hfArrList.Value)) { List <Prm> list = JsonConvert.DeserializeObject <List <Prm> >(hfArrList.Value); foreach (Prm item in list) { if (!string.IsNullOrEmpty(item.ProductModel)) { Model.ProductCenterModel pcm = new Model.ProductCenterModel(); pcm.ProductModelID = RuleUtility.IDsCreater.GetCreater().CreateProductModelID(dbm); pcm.Language = Language; pcm.ProductID = cp.ProductID; pcm.ProductModel = item.ProductModel; pcm.CreateTime = DateTime.Now; pcm.UpdateTime = DateTime.Now; flag2 = Factory.GetExecution().Add <Model.ProductCenterModel>(pcm); } } } if (flag1 && flag2) { Common.MessageBox.ShowRedirect(this, "/ProductCenter/ServoDriver.aspx?ProductType=" + ProductType); } } } catch (Exception ex) { Common.MessageBox.ShowLayer(this, "添加失败!" + ex.Message, 2); } finally { dbm.Close(); BindData(); } }