public virtual bool SavePOApprovalSetEntity(CasPoApprovalSettingsEntity poApprovalSetEntity, ref string strError)
{
poApprovalSetEntity.LastModifiedBy = WebCaching.UserAccount;
poApprovalSetEntity.LastModifiedTime = DateTime.Now;
try
{
var isExist = IsExist(poApprovalSetEntity, ref strError);
if (isExist)
{
poApprovalSetEntity.UserId = poApprovalSetEntity.ApprovalUserValue;
//更新
if (UpdateApprovalSet(poApprovalSetEntity))
{
return(true);
}
}
else
{
//新增
poApprovalSetEntity.PoApprovalId = Guid.NewGuid().ToString();
poApprovalSetEntity.CreatedBy = WebCaching.UserAccount;
poApprovalSetEntity.CreateTime = DateTime.Now;
//poApprovalSetEntity.UserId = poApprovalSetEntity.ApprovalUserValue;
if (InsertApprovalSet(poApprovalSetEntity))
{
return(true);
}
}
}
catch (Exception exception)
{
strError = exception.Message;
}
return(false);
}
/// <summary>
/// 新增POApprovalSet
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool InsertApprovalSet(CasPoApprovalSettingsEntity entity)
{
var poApprovalSetEntities = new List <CasPoApprovalSettingsEntity>();
string[] userId = entity.ApprovalUserValue.ToString().Split(',');
for (int i = 0; i < userId.Length; i++)
{
var poApprovalSetEntity = new CasPoApprovalSettingsEntity();
poApprovalSetEntity.PoApprovalId = Guid.NewGuid().ToString();
poApprovalSetEntity.Company = entity.Company;
poApprovalSetEntity.ContractTypeId = entity.ContractTypeId;
poApprovalSetEntity.UserId = userId[i];
poApprovalSetEntity.CreatedBy = WebCaching.UserId;
poApprovalSetEntity.CreateTime = DateTime.Now;
poApprovalSetEntity.LastModifiedBy = WebCaching.UserId;
poApprovalSetEntity.LastModifiedTime = DateTime.Now;
poApprovalSetEntities.Add(poApprovalSetEntity);
}
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
broker.BeginTransaction();
DataAccess.Insert <CasPoApprovalSettingsEntity>(poApprovalSetEntities, broker);
broker.Commit();
return(true);
}
catch (Exception ex)
{
broker.RollBack();
return(false);
}
}
//return true;
}
/// <summary>
/// 跟新PO审批人
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool UpdateApprovalSet(CasPoApprovalSettingsEntity entity)
{
var delValue = DeletePoApprovalSet(entity.ContractTypeId, entity.Company);
bool insValue = false;
if (delValue)
{
insValue = InsertApprovalSet(entity);
}
return(insValue);
}
public virtual bool IsExist(CasPoApprovalSettingsEntity poApprovalSetEntity, ref string strError)
{
if (poApprovalSetEntity.PoApprovalId == null)
{
return(false);
}
var strsql = new StringBuilder();
strsql.AppendFormat("SELECT 1 FROM CAS_PO_APPROVAL_SETTINGS WHERE PO_APPROVAL_ID = {0}",
Utils.ToSQLStr(poApprovalSetEntity.PoApprovalId).Trim());
var val = DataAccess.SelectScalar(strsql.ToString());
if (string.IsNullOrEmpty(val) || val != "1")
{
return(false);
}
strError = "该PO审批设置已经存在";
return(true);
}
public ActionResult Edit(CasPoApprovalSettingsEntity entity, string id, string type)
{
string typeValue = "";
if (type == "check")
{
ViewBag.Type = "3";
typeValue = "3";
}
string strError = "";
if (!IsPost)
{
entity = BusinessDataService.POApprovalSetService.CreatePoApprovalSettEntity("MDM");
if (!string.IsNullOrEmpty(id))
{
entity = BusinessDataService.POApprovalSetService.GetById <CasPoApprovalSettingsEntity>(id);
//编辑
ViewBag.EditType = (!string.IsNullOrWhiteSpace(typeValue)) ? typeValue : "0";
}
else
{
//新增
ViewBag.EditType = "1";
}
}
else
{
if (BusinessDataService.POApprovalSetService.SavePOApprovalSetEntity(entity, ref strError))
{
return(Json(AjaxResult.Success()));
}
return(Json(AjaxResult.Error("Update failed")));
}
ViewBag.strError = strError;
return(View(entity));
}
public ActionResult Delet(CasPoApprovalSettingsEntity entity, string id, string company)
{
var a = BusinessDataService.POApprovalSetService.DeletePoApprovalSet(id, company);
return(Json(AjaxResult.Success()));
}
