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