/// <summary> /// 通过部门获取数据【或者纯粹获取某个成员的】 /// </summary> /// <param name="type"></param> /// <param name="Data_selfs"></param> /// <returns></returns> private static IEnumerable <follow_up> Check_And_Get_List_dep(string departmentID, string memmberID, IEnumerable <follow_up> Data_selfs) { try { if (!string.IsNullOrEmpty(memmberID)) { Data_selfs = (from w in Data_selfs where w.follow_userid == memmberID select w); } else if (!string.IsNullOrEmpty(departmentID)) { //先获取部门信息 DepartMent department = Constant.DepartMent_List.FirstOrDefault(d => d.ID == departmentID); var UniqueNo_string = (from userInfo in department.UserInfo_List select userInfo.UniqueNo); //取到部门,获取下列信息 if (department != null) { Data_selfs = (from w in Data_selfs where UniqueNo_string.Contains(w.follow_userid) select w); } } } catch (Exception ex) { LogHelper.Error(ex); } return(Data_selfs); }
protected void btnSure_Click(object sender, EventArgs e) { DepartMent dep=new DepartMent(); WebFormHelper.GetDataFromForm(this, dep); if(dep.Id<0) { if (SimpleOrmOperator.Create(dep)) { WebTools.Alert("添加成功!"); } else { WebTools.Alert("添加失败!"); } } else{ if (SimpleOrmOperator.Update(dep)) { WebTools.Alert("修改成功!"); } else { WebTools.Alert("修改失败!"); } } }
public static string Login(string name, string pwd) { string sql = "select * from table_users where c_login_name='" + DALSecurityTool.TransferInsertField(name) + "' and c_pwd='" + DALSecurityTool.TransferInsertField(SecurityFactory.GetSecurity().Encrypt(pwd)) + "'"; ArrayList lists = FT.DAL.Orm.SimpleOrmOperator.QueryList(typeof(UserObject), sql); if (lists.Count == 0) { return("2"); } else { UserObject user = lists[0] as UserObject; RoleObject role = FT.DAL.Orm.SimpleOrmOperator.Query <RoleObject>(user.RoleId); DepartMent dept = FT.DAL.Orm.SimpleOrmOperator.Query <DepartMent>(user.DepId); OperatorTick ot = new OperatorTick(user.Id, user.FullName, user.DepId, role.RoleString, pwd); ot.Desp1 = user.WorkId; ot.Desp2 = dept.ParentCode; ot.Desp3 = dept.DepCode; ot.Desp4 = dept.DepFullName; ot.Desp5 = user.FullName; ot.Desp6 = role.RoleName; ot.Desp7 = user.Km; ot.Desp8 = string.Empty; return(FT.Web.OperatorTick.GenerateOpTicket(ot)); } //return "1"; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.ProcedurePager1.TableName = "table_school_car_info"; this.ProcedurePager1.FieldString = @"id , clpp , hmhp , name, idcard , coachno , mobile , depname " .Replace("\r\n", "").Replace("\t", ""); if (!string.IsNullOrEmpty(Request.Params["school"])) { int depId = this.Operator.DeptId; DepartMent dep = SimpleOrmOperator.Query <DepartMent>(depId); ViewState["dep"] = dep; this.ProcedurePager1.RowFilter = string.Format(" DEPCODE ='{0}'", dep.DepCode); } this.ProcedurePager1.SortString = " order by depname desc"; } }
protected void btnSure_Click(object sender, EventArgs e) { DepartMent dep = new DepartMent(); WebFormHelper.GetDataFromForm(this, dep); if (dep.Id < 0) { if (SimpleOrmOperator.Create(dep)) { WebTools.Alert("添加成功!"); } else { WebTools.Alert("添加失败!"); } } else { if (SimpleOrmOperator.Update(dep)) { WebTools.Alert("修改成功!"); } else { WebTools.Alert("修改失败!"); } } }
public static void Seed(StuDBContext context) { var d1 = new DepartMent() { Name = "电子信息工程学院", SortCode = "001", Description = "第一大学院" }; var d2 = new DepartMent() { Name = "机电工程学院", SortCode = "002", Description = "第二大学院" }; var d3 = new DepartMent() { Name = "汽车工程学院", SortCode = "003", Description = "第三大学院" }; var d4 = new DepartMent() { Name = "财经与物流学院", SortCode = "004", Description = "第四大学院" }; context.DepartMents.Add(d1); context.DepartMents.Add(d2); context.DepartMents.Add(d3); context.DepartMents.Add(d4); context.SaveChanges(); }
protected void btnSure_Click(object sender, EventArgs e) { int depId = this.Operator.DeptId; DepartMent dep = SimpleOrmOperator.Query <DepartMent>(depId); DrvAuthObject auth = SimpleOrmOperator.Query <DrvAuthObject>(dep.DepCode); if (auth == null || auth.YLR_IND != 1) { WebTools.Alert("未获得授权不能使用预录入功能!"); return; } StudentApplyInfo entity = new StudentApplyInfo(); WebFormHelper.GetDataFromForm(this, entity); entity.Csrq = this.txtCsrq.Value.Trim(); entity.Tjrq = this.txtTjrq.Value.Trim(); //借用一下这个字段 entity.PhotoSrc = this.cbBustype.SelectedValue; if (!string.IsNullOrEmpty(Request.Params["cbDjzsxzqhValue"])) { entity.Djzsxzqh = Request.Params["cbDjzsxzqhValue"]; } entity.CheckDate = DateTime.Now.ToString("yyyy-MM-dd"); // entity.DepName = this.cbDepCodeValue.SelectedItem.Text; if (entity.Id < 0) { entity.Jxdm = this.Operator.Desp3; entity.Jxmc = this.Operator.Desp4; if (SimpleOrmOperator.Create(entity)) { WebTools.Alert("添加成功!"); } else { WebTools.Alert("添加失败!"); } } else { if (SimpleOrmOperator.Update(entity)) { WebTools.Alert("修改成功!"); } else { WebTools.Alert("修改失败!"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.Params["id"] != null) { DepartMent dep = SimpleOrmOperator.Query <DepartMent>(Convert.ToInt32(Request.Params["id"])); WebFormHelper.SetDataToForm(this, dep); } } }
public void AddDepartMent(DepartMent mm) { mm.Num = 0; string json = JsonConvert.SerializeObject(mm); string result = HttpClientHelpers.Send("post", "/api/WangLuChao/AddDepartMent", json); if (Convert.ToInt32(result) > 0) { Response.Write("<script>alert('ok');location.href='/WangLuChao/ShowDepartMent'</script>"); } else { Response.Write("<script>alert('bu ok')</script>"); } }
private void Pop(int id) { string url = "SchoolCarInfoEdit.aspx"; DepartMent dep = ViewState["dep"] as DepartMent; if (id > 0 && dep != null) { url += string.Format("?id={0}&depId={1}", id, dep.Id); } else if (dep != null) { url += string.Format("?depId={0}", dep.Id); } WebTools.ShowModalWindows(this, url, 1000, 350); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DepartMentOperator.Bind(this.cbDepCodeValue, "驾校"); if (Request.Params["id"] != null) { SchoolCarInfo entity = SimpleOrmOperator.Query <SchoolCarInfo>(Convert.ToInt32(Request.Params["id"])); WebFormHelper.SetDataToForm(this, entity); } if (!string.IsNullOrEmpty(Request.Params["depId"])) { int depId = this.Operator.DeptId; DepartMent dep = SimpleOrmOperator.Query <DepartMent>(depId); cbDepCodeValue.SelectedValue = dep.DepCode; cbDepCodeValue.Enabled = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["userID"] == null) { Response.Redirect("ADLogin.aspx", true); } if (!IsPostBack) { #region 設定餐點類型 Category.Items.Add(new ListItem("不拘", "不拘")); Category.Items.Add(new ListItem("中餐", "0")); Category.Items.Add(new ListItem("點心", "1")); Category.Items.Add(new ListItem("飲料", "2")); #endregion #region 設定素食選項 IsVegetarianism.Items.Add(new ListItem("不拘", "不拘")); IsVegetarianism.Items.Add(new ListItem("否", "false")); IsVegetarianism.Items.Add(new ListItem("是", "true")); #endregion #region 設定部門別 DepartMent.Items.Add(new ListItem("不拘", "不拘")); using (SqlConnection conn = new SqlConnection(DBTools.ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("SELECT * FROM Department", conn)) { using (SqlDataReader dr = cmd.ExecuteReader()) { //while (dr.Read()) // DepartMent.Items.Add(new ListItem(dr.GetString(1), dr.GetString(1))); DepartMent.DataTextField = "DepartmentName"; DepartMent.DataValueField = "DepartmentName"; DepartMent.DataSource = dr; DepartMent.DataBind(); } cmd.Cancel(); } } #endregion #region 查詢菜單內容 if (!string.IsNullOrWhiteSpace(Request["ShopName"])) { QueryString.Add("ShopName", Request["ShopName"]); ShopName.Text = Request["ShopName"]; } if (!string.IsNullOrWhiteSpace(Request["Category"])) { QueryString.Add("Category", Request["Category"]); Category.Items.FindByValue(Request["Category"]).Selected = true; } if (!string.IsNullOrWhiteSpace(Request["IsVegetarianism"]) && (Request["IsVegetarianism"].Equals("是") || Request["IsVegetarianism"].Equals("否"))) { QueryString.Add("IsVegetarianism", Request["IsVegetarianism"]); IsVegetarianism.Items.FindByText(Request["IsVegetarianism"]).Selected = true; } if (!string.IsNullOrWhiteSpace(Request["Department"])) { QueryString.Add("Department", Request["Department"]); DepartMent.Items.FindByText(Request["Department"]).Selected = true; } if (!string.IsNullOrWhiteSpace(Request["Creator"])) { QueryString.Add("Creator", Request["Creator"]); Creator.Text = Request["Creator"]; } int PageNumber; if (string.IsNullOrWhiteSpace(Request["Page"]) || !int.TryParse(Request["Page"], out PageNumber)) { PageNumber = 1; } ucPagination.CPage = PageNumber; Query(PageNumber); #endregion } }