/// <summary>
/// 批量删除数据（启用事务
/// </summary>
/// <param name="json"></param>
/// <returns></returns>
public bool DeleteBatchResidentialUnit(string json)
{
ResidentialUnit bll = new ResidentialUnit();
IList <object> list = (IList <object>)JsonConvert.DeserializeObject(json);
return(bll.DeleteBatch(list));
}
/// <summary>
/// 获取数据分页列表，并返回所有记录数
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecords"></param>
/// <param name="sqlWhere"></param>
/// <param name="cmdParms"></param>
/// <returns></returns>
public string GetResidentialUnitList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
ResidentialUnit bll = new ResidentialUnit();
List <ResidentialUnitInfo> list = bll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, cmdParms);
if (list == null || list.Count == 0)
{
return("[]");
}
return(JsonConvert.SerializeObject(list));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <returns></returns>
public string GetResidentialUnitList()
{
ResidentialUnit bll = new ResidentialUnit();
List <ResidentialUnitInfo> list = bll.GetList();
if (list == null || list.Count == 0)
{
return("[]");
}
return(JsonConvert.SerializeObject(list));
}
/// <summary>
/// 获取满足当前条件的数据列表
/// </summary>
/// <param name="sqlWhere"></param>
/// <param name="cmdParms"></param>
/// <returns></returns>
public string GetResidentialUnitList(string sqlWhere, params SqlParameter[] cmdParms)
{
ResidentialUnit bll = new ResidentialUnit();
List <ResidentialUnitInfo> list = bll.GetList(sqlWhere, cmdParms);
if (list == null || list.Count == 0)
{
return("[]");
}
return(JsonConvert.SerializeObject(list));
}
private void GetJsonForDatagrid(HttpContext context)
{
int totalRecords = 0;
int pageIndex = 1;
int pageSize = 10;
int.TryParse(context.Request.QueryString["page"], out pageIndex);
int.TryParse(context.Request.QueryString["rows"], out pageSize);
string sqlWhere = string.Empty;
ParamsHelper parms = null;
if (!string.IsNullOrEmpty(context.Request.QueryString["unitCode"]))
{
sqlWhere = "and UnitCode like @UnitCode ";
SqlParameter parm = new SqlParameter("@UnitCode", SqlDbType.VarChar, 50);
parm.Value = "%" + context.Request.QueryString["unitCode"].Trim() + "%";
if (parms == null)
{
parms = new ParamsHelper();
}
parms.Add(parm);
}
if (!string.IsNullOrEmpty(context.Request.QueryString["buildingId"]))
{
Guid buildingId = Guid.Parse(context.Request.QueryString["buildingId"]);
sqlWhere = "and ResidentialBuildingId = @ResidentialBuildingId ";
SqlParameter parm = new SqlParameter("@ResidentialBuildingId", SqlDbType.UniqueIdentifier);
parm.Value = buildingId;
if (parms == null)
{
parms = new ParamsHelper();
}
parms.Add(parm);
}
ResidentialUnit bll = new ResidentialUnit();
var list = bll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, parms != null ? parms.ToArray() : null);
if (list == null || list.Count == 0)
{
context.Response.Write("{\"total\":0,\"rows\":[]}");
return;
}
StringBuilder sb = new StringBuilder();
foreach (var model in list)
{
sb.Append("{\"Id\":\"" + model.Id + "\",\"UnitCode\":\"" + model.UnitCode + "\"},");
}
context.Response.Write("{\"total\":" + totalRecords + ",\"rows\":[" + sb.ToString().Trim(',') + "]}");
}
private void Bind(ref string myDataAppend)
{
if (!Id.Equals(Guid.Empty))
{
Page.Title = "编辑楼单元信息";
ResidentialUnit bll = new ResidentialUnit();
ResidentialUnitInfo model = bll.GetModelByJoin(Id);
if (model != null)
{
txtName.Value = model.UnitCode;
txtaRemark.Value = model.Remark;
myDataAppend += "{ \"Id\":\"" + model.Id + "\",\"PropertyCompanyId\":\"" + model.PropertyCompanyId + "\",\"ResidenceCommunityId\":\"" + model.ResidenceCommunityId + "\",\"ResidentialBuildingId\":\"" + model.ResidentialBuildingId + "\",\"CompanyName\":\"" + model.CompanyName + "\",\"CommunityName\":\"" + model.CommunityName + "\",\"BuildingCode\":\"" + model.BuildingCode + "\"}";
}
}
}
private void Bind()
{
//查询条件
GetSearchItem();
List <ResidentialUnitInfo> list = null;
int totalRecords = 0;
ResidentialUnit bll = new ResidentialUnit();
if (parms != null && parms.Count() > 0)
{
list = bll.GetListByJoin(pageIndex, pageSize, out totalRecords, sqlWhere, parms == null ? null : parms.ToArray());
}
else
{
list = bll.GetListByJoin(pageIndex, pageSize, out totalRecords, "", null);
}
rpData.DataSource = list;
rpData.DataBind();
myDataAppend += "<div id=\"myDataForPage\" style=\"display:none;\">[{\"PageIndex\":\"" + pageIndex + "\",\"PageSize\":\"" + pageSize + "\",\"TotalRecord\":\"" + totalRecords + "\",\"QueryStr\":\"" + queryStr + "\"}]</div>";
}
/// <summary>
/// 获取对应的数据
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ResidentialUnitInfo GetResidentialUnitModel(object Id)
{
ResidentialUnit bll = new ResidentialUnit();
return(bll.GetModel(Id));
}
/// <summary>
/// 删除对应数据
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public int DeleteResidentialUnit(object Id)
{
ResidentialUnit bll = new ResidentialUnit();
return(bll.Delete(Id));
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateResidentialUnit(ResidentialUnitInfo model)
{
ResidentialUnit bll = new ResidentialUnit();
return(bll.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertResidentialUnit(ResidentialUnitInfo model)
{
ResidentialUnit bll = new ResidentialUnit();
return(bll.Insert(model));
}
