protected void Search_Click(object sender, EventArgs e)
{
string jobskyerID = name_dropList.SelectedValue;
///根据值重新绑定表单
DB db1 = new DB();
SqlConnection con1 = new SqlConnection();
con1 = db1.GetCon();
con1.Open();
string str1 = "SELECT myDutyTime.jobskyerID,dutyRecordID,DATENAME(WEEKDAY,dutyInTime)+CONVERT(varchar(12),dutyInTime,108) AS MyDutyInTime,DATENAME(WEEKDAY,dutyOutTime)+CONVERT(varchar(12),dutyOutTime,108) AS MyDutyOutTime,jobName FROM myDutyTime,jobskyer WHERE myDutyTime.jobskyerID=JOBSKYER.jobskyerID AND myDutyTime.jobskyerID='" + jobskyerID + "'";
SqlCommand com1 = new SqlCommand(str1, con1);
SqlDataReader da1 = com1.ExecuteReader();
try
{
DutyRecord_repeater.DataSource = da1;
DutyRecord_repeater.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
com1.Dispose();
con1.Close();
}
DB db = new DB();
SqlConnection con = new SqlConnection();
con = db.GetCon();
con.Open();
string str = "SELECT dutyRecordID,flag0,flag1 FROM myDutyTime WHERE myDutyTime.jobskyerID='" + jobskyerID + "'";
SqlCommand com = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
int k = ds.Tables[0].Rows.Count;
for (int i = 0; i < k; ++i)
{
switch (ds.Tables[0].Rows[i]["flag1"].ToString())
{
case "0":
{
ds.Tables[0].Rows[i]["flag1"] = "准时签退";
break;
}
case "1":
{
ds.Tables[0].Rows[i]["flag1"] = "早退";
break;
}
case "2":
{
ds.Tables[0].Rows[i]["flag1"] = "未签退";
break;
}
}
switch (ds.Tables[0].Rows[i]["flag0"].ToString())
{
case "0":
{
ds.Tables[0].Rows[i]["flag0"] = "准时签到";
break;
}
case "1":
{
ds.Tables[0].Rows[i]["flag0"] = "迟到";
break;
}
case "2":
{
ds.Tables[0].Rows[i]["flag0"] = "未签到";
ds.Tables[0].Rows[i]["flag1"] = "未签退";
break;
}
}
}
try
{
Duty_state.DataSource = ds;
Duty_state.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
com.Dispose();
con.Close();
}
DB db2 = new DB();
SqlConnection con2 = new SqlConnection();
con2 = db2.GetCon();
string str2 = "SELECT dutyRecordID,toJobskyerID,flag0 AS toName,jobskyerID FROM myDutyTime WHERE jobskyerID='" + jobskyerID + "'";
SqlCommand com2 = new SqlCommand(str2, con2);
SqlDataAdapter da2 = new SqlDataAdapter(com2);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
int m = ds2.Tables[0].Rows.Count;
for (int i = 0; i < m; ++i)
{
string tojobskyerID = ds.Tables[0].Rows[i]["toJobskyerID"].ToString();
string select = "SELECT jobName FROM JOBSKYER WHERE jobskyerID='" + tojobskyerID + "'";
DB db3 = new DB();
SqlConnection conn = new SqlConnection();
conn = db3.GetCon();
conn.Open();
SqlCommand comm = new SqlCommand(select, conn);
SqlDataAdapter da3 = new SqlDataAdapter(comm);
DataSet ds3 = new DataSet();
da3.Fill(ds3);
string jobname = ds3.Tables[0].Rows[0]["jobName"].ToString();
ds3.Tables[0].Rows[i]["jobName"] = jobname;
if (i == m)
{
comm.Dispose();
conn.Close();
}
}
try
{
Replace_Name.DataSource = ds2;
Replace_Name.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
com2.Dispose();
con2.Close();
}
}
public bool state_Bind()
{
DB db = new DB();
SqlConnection con = new SqlConnection();
con = db.GetCon();
con.Open();
string str = "SELECT dutyRecordID,flag0,flag1 FROM MY_DUTY_TIME";
SqlCommand com = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
int k = ds.Tables[0].Rows.Count;
for (int i = 0; i < k; ++i)
{
switch (ds.Tables[0].Rows[i]["flag1"].ToString())
{
case "0":
{
ds.Tables[0].Rows[i]["flag1"] = "准时签退";
break;
}
case "1":
{
ds.Tables[0].Rows[i]["flag1"] = "早退";
break;
}
case "2":
{
ds.Tables[0].Rows[i]["flag1"] = "未签退";
break;
}
}
switch (ds.Tables[0].Rows[i]["flag0"].ToString())
{
case "0":
{
ds.Tables[0].Rows[i]["flag0"] = "准时签到";
break;
}
case "1":
{
ds.Tables[0].Rows[i]["flag0"] = "迟到";
break;
}
case "2":
{
ds.Tables[0].Rows[i]["flag0"] = "未签到";
ds.Tables[0].Rows[i]["flag1"] = "未签退";
break;
}
}
}
try
{
Duty_state.DataSource = ds;
Duty_state.DataBind();
}
catch (Exception ex)
{
//Response.Write("状态绑定错误！");
return(false);
}
finally
{
com.Dispose();
con.Close();
}
return(true);
}
