public ResResultModel DeleteSiteMulti(string itemAppend)
{
try
{
if (!HttpContext.Current.User.IsInRole("Administrators"))
{
throw new ArgumentException(MC.Role_InvalidError);
}
if (string.IsNullOrWhiteSpace(itemAppend))
{
throw new ArgumentException(MC.Request_Params_InvalidError);
}
var items = itemAppend.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
var bll = new SiteMulti();
if (bll.DeleteBatch(items))
{
return(ResResult.Response(true, MC.M_Save_Ok, ""));
}
else
{
return(ResResult.Response(false, MC.M_Save_Error, ""));
}
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel GetSiteMultiList(ListModel model)
{
try
{
MenusDataProxy.ValidateAccess((int)EnumOperationAccess.浏览, true);
var bll = new SiteMulti();
int totalRecord = 0;
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
if (!string.IsNullOrWhiteSpace(model.Keyword))
{
parms = new ParamsHelper();
sqlWhere = new StringBuilder("and (Coded like @Keyword or Named like @Keyword) ");
var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50);
parm.Value = parm.Value = "%" + model.Keyword + "%";
parms.Add(parm);
}
var list = bll.GetListByJoin(model.PageIndex, model.PageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
return(ResResult.Response(true, "", JsonConvert.SerializeObject(list)));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
public ResResultModel SaveSiteMulti(SiteMultiModel model)
{
try
{
if (!HttpContext.Current.User.IsInRole("Administrators"))
{
throw new ArgumentException(MC.Role_InvalidError);
}
Guid id = Guid.Empty;
if (model.Id != null)
{
Guid.TryParse(model.Id.ToString(), out id);
}
var modelInfo = new SiteMultiInfo(id, model.Coded, model.Named, model.SiteLogo, model.SiteTitle, model.CultureName, DateTime.Now);
var bll = new SiteMulti();
int effect = 0;
if (id.Equals(Guid.Empty))
{
var code = bll.GetCode();
modelInfo.Coded = code;
effect = bll.Insert(modelInfo);
}
else
{
var oldInfo = bll.GetModel(id);
modelInfo.Coded = oldInfo.Coded;
effect = bll.Update(modelInfo);
}
if (effect > 0)
{
return(ResResult.Response(true, MC.M_Save_Ok, ""));
}
else
{
return(ResResult.Response(false, MC.M_Save_Error, ""));
}
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, ""));
}
}
private void GetSiteMultiList(HttpContext context, int pageIndex, int pageSize, string keyword)
{
var bll = new SiteMulti();
int totalRecord = 0;
StringBuilder sqlWhere = null;
ParamsHelper parms = null;
if (!string.IsNullOrWhiteSpace(keyword))
{
parms = new ParamsHelper();
sqlWhere = new StringBuilder("and (Coded like @Keyword or Named like @Keyword) ");
var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50);
parm.Value = parm.Value = "%" + keyword + "%";
parms.Add(parm);
}
var list = bll.GetListByJoin(pageIndex, pageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray());
context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}"));
}
