public OperationResult Update(UpdatePROD_GROUP_ITEMModel model)
{
//因为这里使用两个联合主键为约束
/*
* StringBuilder sb = new StringBuilder();
* sb.AppendLine("UPDATE dbo.[PROD_GROUP_ITEM]");
* sb.AppendLine(" SET [ProductID] = @ProductID");
* sb.AppendLine(" ,[GROUP_INDEX] = @GROUP_INDEX");
* sb.AppendLine(" ,[Notes] = @Notes");
* sb.AppendLine(" ,[Picture] = @Picture");
* sb.AppendLine(" ,[Status] = @Status");
* sb.AppendLine(" WHERE [ProductID] = @oldProductID");
* sb.AppendLine(" and [GROUP_INDEX] = @oldGROUP_INDEX");
*
* System.Data.SqlClient.SqlParameter[] parameters = {
* new System.Data.SqlClient.SqlParameter("@ProductID",model.NewProductID),
* new System.Data.SqlClient.SqlParameter("@GROUP_INDEX",model.NewGROUP_INDEX),
* new System.Data.SqlClient.SqlParameter("@Notes",model.Notes),
* new System.Data.SqlClient.SqlParameter("@Picture",model.Picture),
* new System.Data.SqlClient.SqlParameter("@Status",model.Status),
* new System.Data.SqlClient.SqlParameter("@oldProductID",model.ProductID),
* new System.Data.SqlClient.SqlParameter("@oldGROUP_INDEX",model.GROUP_INDEX),
* };
* //这里以在数据库中修改成功;
* PROD_GROUP_ITEMRepository.ExcuteNoQuery(sb.ToString(), System.Data.Entity.TransactionalBehavior.DoNotEnsureTransaction,false,"", parameters);
* //这里的Entities没有更新??
*/
var entity = PROD_GROUP_ITEMList.First(t => t.ProductID == model.ProductID && t.GROUP_INDEX == model.GROUP_INDEX);
//entity.ProductID = model.NewProductID;
//entity.GROUP_INDEX = model.NewGROUP_INDEX;
entity.Notes = model.Notes;
entity.Picture = model.Picture;
entity.Status = (byte)(model.Status ? 1 : 0);
PROD_GROUP_ITEMRepository.Update(entity);
return(new OperationResult(OperationResultType.Success, "update completed"));
}
public ActionResult Edit(string ProductID, string GROUP_INDEX)
{
var model = new UpdatePROD_GROUP_ITEMModel();
var entity = PROD_GROUP_ITEMService.PROD_GROUP_ITEMList.FirstOrDefault(t => t.ProductID == ProductID && t.GROUP_INDEX == GROUP_INDEX);
if (null != entity)
{
model = new UpdatePROD_GROUP_ITEMModel
{
ProductID = entity.ProductID,
NewProductID = entity.ProductID,
GROUP_INDEX = entity.GROUP_INDEX,
NewGROUP_INDEX = entity.GROUP_INDEX,
Notes = entity.Notes,
Picture = entity.Picture,
Status = entity.Status == 1?true:false,
};
model.Groups = GetParentGroup();
//InitParentGroup(model);
model.Products = GetProducts();
}
return(PartialView(model));
}
public ActionResult Edit(UpdatePROD_GROUP_ITEMModel model)
{
if (ModelState.IsValid)
{
//this.UpdateBaseData<UpdatePROD_GROUP_ITEMModel>(model);
OperationResult result = PROD_GROUP_ITEMService.Update(model);
if (result.ResultType == OperationResultType.Success)
{
return(Json(result));
}
else
{
model.Groups = GetParentGroup();
model.Products = GetProducts();
return(PartialView(model));
}
}
else
{
model.Groups = GetParentGroup();
model.Products = GetProducts();
return(PartialView(model));
}
}
