public void bindapply()
{
conn obj = new conn();
String sql = "SELECT * FROM apply";
DataSet ds = obj.GetDataSet(sql);
Repeater2.DataSource = ds;
Repeater2.DataBind();
String sql3 = "select * from applyadvise ORDER BY Score DESC";
DataSet ds3 = obj.GetDataSet(sql3);
Repeater3.DataSource = ds3;
Repeater3.DataBind();
}
public void bindall()
{
conn obj = new conn();
String sql = "SELECT Name,salary.WID,salary.SalaID, salary.Month,salary.Money,salary.SendWay,state.StateName,salary.SendTime,salary.GetTime,salary.Remark FROM salary ,staffinfo ,state WHERE salary.WID = staffinfo.WID AND salary.StateID=state.StateID order by WID";
DataSet ds = obj.GetDataSet(sql);
GridView2.DataSource = ds;
GridView2.DataBind();
}
public void bindadvise()
{
conn obj = new conn();
String sql = "select * from applyadvise ORDER BY Score DESC";
DataSet ds = obj.GetDataSet(sql);
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
public void bind()
{
conn obj = new conn();
String sql = "SELECT * FROM staffinfo,power,state where staffinfo.Power=power.Power AND staffinfo.StateID=state.StateID and staffinfo.power>0";
DataSet ds = obj.GetDataSet(sql);
Repeater.DataSource = ds;
Repeater.DataBind();
}
}//签到绑定
public void bindonduty()
{
conn onduty = new conn();
String sql = "select staffinfo.WID,Name,Tel,Email,QQ,PowerName from onduty,staffinfo,power where WorkState=21 and staffinfo.WID=onduty.WID and power.Power=staffinfo.Power";
DataSet ds = onduty.GetDataSet(sql);
Repeater1.DataSource = ds;
Repeater1.DataBind();
}//工作人员绑定
public void bind()
{
conn obj = new conn();
String sql = "SELECT salary.SalaID, salary.Month,salary.Year,salary.Money,salary.SendWay,state.StateName,salary.SendTime,salary.GetTime,salary.Remark,SalaryTypeName FROM salary ,staffinfo ,state,salarytype WHERE staffinfo.SID =" + Session["userid"] + " AND salary.WID = staffinfo.WID AND salary.StateID=state.StateID AND salary.SalaryTypeID=salarytype.SalaryTypeID order by Month";
DataSet ds = obj.GetDataSet(sql);
Repeater2.DataSource = ds;
Repeater2.DataBind();
}
protected void bind()
{
conn userinfo = new conn();
String sql = "SELECT * from staffinfo,power,state WHERE state.StateID=staffinfo.StateID and staffinfo.Power=power.Power and staffinfo.SID =" + Session["userid"];//顺序比较重要 如果把参数放到中间 这句话将不能够执行
//MySqlParameter[] mysp ={ new MySqlParameter ("?username",MySqlDbType.VarChar)
//mysp[0].Value = Session["username"];
DataSet ds = userinfo.GetDataSet(sql);
Repeater1.DataSource = ds;
//int num = ds.Tables["staffinfo"].Rows.Count; 可以试着判断是否只有一条满足要求的记录
//GridView1.DataKeyNames = new string[] { "id" };//主键
Repeater1.DataBind();
}
public void bind()
{
conn obj = new conn();
String sql = "SELECT salary.SalaID, salary.Month,salary.Money,salary.SendWay,state.StateName,salary.SendTime,salary.GetTime,salary.Remark FROM salary ,staffinfo ,state WHERE staffinfo.SID =" + Session["userid"] + " AND salary.WID = staffinfo.WID AND salary.StateID=state.StateID order by Month";
//MySqlParameter[] mysp ={ new MySqlParameter ("?username",MySqlDbType.VarChar)
// };
//mysp[0].Value = Session["username"];
DataSet ds = obj.GetDataSet(sql);
GridView1.DataSource = ds;
//GridView1.DataKeyNames = new string[] { "id" };//主键
GridView1.DataBind();
//sqlcon.Close();
}
public void bind()
{
//this.DropDownList1.DataTextField = "";
conn time = new conn();
String sql = "select * from time where TIMEDIFF(CURRENT_TIME(),Time)>0 ORDER BY TimeID DESC LIMIT 0,2";
DataSet ds = time.GetDataSet(sql);
DropDownList1.DataSource = ds;
this.DropDownList1.SelectedIndex = 0;
this.DropDownList1.DataTextField = "Time"; //dropdownlist的Text的字段
this.DropDownList1.DataValueField = "TimeID"; //dropdownlist的Value的字段
//DropDownList1.Items.Add(new ListItem("-=请选择=-", "0"));
this.DropDownList1.DataBind();
}//签到绑定