private DataTable GetSource() { string sortField = Grid1.SortField; string sortDirection = Grid1.SortDirection; IInfobasisDataSource db = InfobasisDataSource.Create(); DataTable table2 = db.ExecuteTable("SELECT ID, 'test' AS DeptName, ChineseName, Gender FROM SYtbUser WHERE CompanyID = @CompanyID", UserInfo.Current.CompanyID); DataView view2 = table2.DefaultView; view2.Sort = String.Format("{0} {1}", sortField, sortDirection); List <string> filters = new List <string>(); string searchKeyword = ttbSearch.Text.Trim(); if (!String.IsNullOrEmpty(searchKeyword) && ttbSearch.ShowTrigger1) { // RowFilter的用法:http://www.csharp-examples.net/dataview-rowfilter/ filters.Add(String.Format("ChineseName LIKE '*{0}*'", EscapeLikeValue(searchKeyword))); } if (filters.Count > 0) { view2.RowFilter = String.Join(" AND ", filters.ToArray()); } return(view2.ToTable()); }
private void BindGrid() { IInfobasisDataSource db = InfobasisDataSource.Create(); DataTable table = db.ExecuteTable("SELECT * FROM SYtbModule ORDER BY DisplayOrder"); ModuleGrid.DataSource = table; ModuleGrid.DataBind(); }
private void InitDropDownMainMaterialType() { IInfobasisDataSource db = InfobasisDataSource.Create(); int companyID = UserInfo.Current.CompanyID; DataTable table = db.ExecuteTable("SELECT * FROM SYtbEntityList WHERE GroupCode = 'Material' AND CompanyID = @CompanyID ORDER BY DisplayOrder", companyID); DropDownMainMaterialType.DataSource = table; DropDownMainMaterialType.DataTextField = "Name"; DropDownMainMaterialType.DataValueField = "ID"; DropDownMainMaterialType.DataBind(); DropDownMainMaterialType.Items.Insert(0, new FineUIPro.ListItem("", "-1")); //DropDownMainMaterialType.Items[0].Selected = true; }
private void InitUserDept() { int provinceID = 0; if (DropDownProvince.SelectedValue != null) { provinceID = Infobasis.Web.Util.Change.ToInt(DropDownProvince.SelectedValue); } IInfobasisDataSource db = InfobasisDataSource.Create(); DataTable table = db.ExecuteTable("EXEC usp_SY_GetDeptByType @CompanyID, @DepartmentControlType, @ProvinceID", UserInfo.Current.CompanyID, Infobasis.Data.DataEntity.DepartmentControlType.Design, provinceID); gridDept.DataSource = table; gridDept.DataBind(); }
private void InitDesigner() { int deptID = Infobasis.Web.Util.Change.ToInt(ddbDesignerDept.Value); if (deptID > 0) { IInfobasisDataSource db = InfobasisDataSource.Create(); DataTable table = db.ExecuteTable("EXEC usp_SY_GetEmployeeByDept @CompanyID, @DeptID", UserInfo.Current.CompanyID, deptID); gridDesigner.DataSource = table; gridDesigner.DataBind(); ddbDesigner.Enabled = true; } else { ddbDesigner.Enabled = false; } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "application/json"; String term = context.Request.QueryString["term"]; int companyID = UserInfo.Current.CompanyID; IInfobasisDataSource db = InfobasisDataSource.Create(); DataTable _t = db.ExecuteTable("SELECT [Name] FROM [SYtbUser] Where CompanyID = @companyID AND [Name] like '%' + @ke + '%'", companyID, term); DataRow[] list = new DataRow[_t.Rows.Count]; _t.Rows.CopyTo(list, 0); var wapper = new { query = term, suggestions = (from row in list select row["Name"].ToString()).ToArray() //, data = new[] { "LR", "LY", "LI", "LT" } }; var suggestions = (from row in list select row["Name"].ToString()).ToArray(); context.Response.Write(JsonConvert.SerializeObject(suggestions)); }
protected void ProcessEntityFieldPermission <T>(T entity, string entityCode) { int companyID = UserInfo.GetCurrentCompanyID(); IInfobasisDataSource db = InfobasisDataSource.Create(); DataTable dtFields = db.ExecuteTable("EXEC usp_EasyHR_GetFieldPermission @CompanyID, @EntityCode", companyID, entityCode); List <string> columns = dtFields.AsEnumerable().Select(r => Change.ToString(r["ColumnName"])).Distinct().ToList(); Type type = entity.GetType(); foreach (PropertyInfo pi in type.GetProperties()) { string name = pi.Name; if (columns.Contains(name)) { continue; } Type valueType = pi.PropertyType; if (pi.CanWrite) { if (valueType.IsGenericType && valueType.GetGenericTypeDefinition() == typeof(Nullable <>)) { // If it is NULLABLE, then get the underlying type. eg if "Nullable<int>" then this will return just "int" //columnType = p.PropertyType.GetGenericArguments()[0]; pi.SetValue(entity, null, null); continue; } switch (valueType.ToString()) { case "System.Nullable": pi.SetValue(entity, null, null); break; case "System.String": pi.SetValue(entity, "", null); break; case "System.Boolean": pi.SetValue(entity, null, null); break; case "System.Int32": pi.SetValue(entity, 0, null); break; case "System.Decimal": pi.SetValue(entity, 0, null); break; case "System.DateTime": pi.SetValue(entity, DateTime.MinValue, null); break; default: pi.SetValue(entity, null, null); break; } } } }