public JsonResult AddSql(ViewModel model)
{
if (SysUser != null)
{
model.INPUTER = SysUser.UserCode;
}
else
{
return(FailResult("未登录状态"));
}
var verifymodel = ModelVerify.First(model);
if (verifymodel != null)
{
return(FailResult(verifymodel.ErrorMessage));
}
if (model.COMMAND_TEXT.Length > 2000)
{
return(FailResult("该SQL超出长度"));
}
if (!string.IsNullOrEmpty(model.VIEW_NAME))
{
if (sqlManager.IsExists(model.VIEW_NAME))
{
return(FailResult("标题已存在，不可用"));
}
}
if (!sqlManager.IsCorrect(model.COMMAND_TEXT))
{
return(FailResult(sqlManager.PromptInfo.Message));
}
Tsql_View daView = new Tsql_View()
{
ViewName = model.VIEW_NAME,
ClassifyId = model.CLASSIFY_ID,
CommandText = model.COMMAND_TEXT,
ViewTemplate = model.VIEW_TEMPLATE,
CacheStatus = model.CACHE_STATUS,
PageRow = model.PAGE_ROW,
Status = 1,
Inputer = model.INPUTER,
Remarks = model.REMARKS,
};
if (!daView.Insert())
{
return(FailResult(daView.PromptInfo.Message));
}
else
{
//添加删除缓存数据
ViewFacade viewfacade = new ViewFacade();
viewfacade.AddOrUpdateCache(daView.ViewId, Convert.ToInt32(daView.CacheStatus), Isparameter(daView.CommandText));
}
return(SuccessResult());
}
/// <summary>
/// 验证表单提交数据合法性
/// </summary>
/// <returns></returns>
private bool SaveVerify(string groupName)
{
var verifyResult = ModelVerify.First(this, groupName);
if (verifyResult != null)
{
Alert(ResultType.非法数值, verifyResult.ErrorMessage);
return(false);
}
//TODO:其他的检查
return(true);
}
/// <summary>
/// 执行更新操作
/// </summary>
/// <returns></returns>
public bool Update()
{
if (_address == null)
{
Alert("收货地址信息不能为空");
return(false);
}
if (_address.Consignee == null)
{
_address.Consignee = new ConsigneeInfo();
}
var vres0 = ModelVerify.Verify(_address, "update");
if (!vres0.IsSuccess)
{
Alert(vres0.Verifys.FirstOrDefault().ErrorMessage);
return(false);
}
int addressId = _address.Address_Id;
Tnet_Shipping_Address daShippingAddress = new Tnet_Shipping_Address();
if (!daShippingAddress.SelectByPk(addressId))
{
Alert("收货地址信息不存在");
return(false);
}
if (_address.Owner_Id > 0 && daShippingAddress.Owner_Id != _address.Owner_Id)
{
Alert("操作不允许");
return(false);
}
_address.Owner_Id = daShippingAddress.Owner_Id;
_address.Owner_Type = (Address_Owner_Type)daShippingAddress.Owner_Type;
Tnet_Consignee daConsignee = new Tnet_Consignee();
if (!daConsignee.SelectByPk(daShippingAddress.Consignee_Id))
{
Alert("收件人信息有误");
return(false);
}
//如果收货人信息传入null，表示不需要修改此项，则将已有的收货人信息写入 _address.Consignee
Extend(_address.Consignee, daConsignee);
var oldAddressId = _address.Address_Id;
BeginTransaction();
ConsigneeCreationProvider creationProvider = new ConsigneeCreationProvider(_address);
creationProvider.ReferenceTransactionFrom(Transaction);
if (!creationProvider.Create())
{
Rollback();
Alert("更新收货地址失败，请重试！");
return(false);
}
this._address = creationProvider.ShippingAddress;//new shipping address
Commit();
OnSuccess(this._address);
return(true);
}
