private void SetInfo(Foresight.DataAccess.Wechat_Business data) { this.tdBusinessName.Value = data.BusinessName; this.tdBusinessSummary.Value = data.BusinessSummary; this.tdIsPublish.Value = data.IsPublish ? "1" : "0"; this.tdPhoneNumber.Value = data.PhoneNumber; this.BusinessImgPath = !string.IsNullOrEmpty(data.BusinessImg) ? WebUtil.GetContextPath() + data.BusinessImg : string.Empty; }
public static Ui.DataGrid GeWechat_BusinessGridByKeywords(string Keywords, string orderBy, long startRowIndex, int pageSize) { long totalRows = 0; List <SqlParameter> parameters = new List <SqlParameter>(); List <string> conditions = new List <string>(); conditions.Add(" 1=1 "); if (!string.IsNullOrEmpty(Keywords)) { conditions.Add("([BusinessName] like @Keywords or [PhoneNumber] like @Keywords)"); parameters.Add(new SqlParameter("@Keywords", "%" + Keywords + "%")); } string fieldList = "[Wechat_Business].*"; string Statement = " from [Wechat_Business] where " + string.Join(" and ", conditions.ToArray()); Wechat_Business[] list = new Wechat_Business[] { }; list = GetList <Wechat_Business>(fieldList, Statement, parameters, orderBy, startRowIndex, pageSize, out totalRows).ToArray(); DataAccess.Ui.DataGrid dg = new Ui.DataGrid(); dg.rows = list; dg.total = totalRows; dg.page = pageSize; return(dg); }