/// <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
}
}
