protected void txt_wtdepart_TextChanged(object sender, EventArgs e)
{
DAl.Station StationObj = new DAl.Station();
DataTable dt = StationObj.GetWTByName(txt_wtdepart.Text.Trim());
if (dt != null)
{
if (dt.Rows.Count == 1)
{
if (dt.Rows[0]["单位详细地址"].ToString() != " ")
{
txt_address.Text = dt.Rows[0]["单位详细地址"].ToString();
}
if (dt.Rows[0]["环保负责人"].ToString() != " ")
{
txt_lxman.Text = dt.Rows[0]["环保负责人"].ToString();
}
if (dt.Rows[0]["mobile3"].ToString() != " ")
{
txt_lxtel.Text = dt.Rows[0]["mobile3"].ToString();
}
if (dt.Rows[0]["电子邮箱"].ToString() != " ")
{
txt_lxemail.Text = dt.Rows[0]["电子邮箱"].ToString();
}
}
}
}
private void Query()
{
//strSelectedId=txt_samplequery.Text;
string strSample = "";
string strDate = "";
if (txt_samplequery.Text != "")
{
strSample = "and ReportName like'%" + txt_samplequery.Text + "%'";
}
if (drop_tkwether.SelectedValue.Trim() == "0")
{
strSample += " and (StatusID=6)";
}
else
{
strSample += " and (StatusID>=2 and StatusID!=6 )";
}
if (cb_query_fa.Checked)
{
strSample += " and hanwether=1";
}
else
{
strSample += " and hanwether=0";
}
if (txt_QueryTime.Text != "")
{
strDate = " and ReportAccessDate>= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00") + "' ";
}
if (txt_QueryTimeEnd.Text != "")
{
strDate = " and ReportAccessDate<= '" + DateTime.Parse(txt_QueryTimeEnd.Text.Trim() + " 00:00:00") + "'";
}
//TBD//项目负责人只能看到自己的项目
string strSql = "select t_Y_FlowInfo.id,t_Y_FlowInfo.ReportAccessDate 时间,t_Y_FlowInfo.ItemType,ItemName 项目类型,ReportName 报告标识,urgent 备注,t_Y_FlowInfo.Ulevel,Projectname 项目名称,rwclass,jcmethod,address,lxman,lxtel,lxemail,wtdepart,wether,varman1,vardate1,varremark1,t_Y_FlowInfo.chargeman,hanwether from t_Y_FlowInfo,t_M_ItemInfo where t_Y_FlowInfo.ItemType=t_M_ItemInfo.ItemID " + strSample + strDate + " order by t_Y_FlowInfo.ReportAccessDate";
DataSet ds = new MyDataOp(strSql).CreateDataSet();
DataColumn dcc = new DataColumn("紧急程度");
ds.Tables[0].Columns.Add(dcc);
DataColumn dc = new DataColumn("监测方式");
ds.Tables[0].Columns.Add(dc);
DataColumn dc0 = new DataColumn("任务类型");
ds.Tables[0].Columns.Add(dc0);
DataColumn dc1 = new DataColumn("委托单位");
ds.Tables[0].Columns.Add(dc1);
DataColumn dc2 = new DataColumn("项目负责人");
ds.Tables[0].Columns.Add(dc2);
DAl.Sample getobj = new DAl.Sample();
DataTable dtmode = getobj.GetMode("", "mode", "");
DAl.Station get = new DAl.Station();
DataTable dtstation = get.GetWTByName("");
DAl.User.Users userobj = new DAl.User.Users();
DataTable dtuser = userobj.GetUsersDt("");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["rwclass"].ToString() == "1")
{
dr["任务类型"] = "委托监测";
}
else
{
dr["任务类型"] = "例行监测";
}
DataRow[] drsel = dtmode.Select("code='" + dr["jcmethod"].ToString() + "'");
if (drsel.Length == 1)
{
dr["监测方式"] = drsel[0]["name"].ToString();
}
else
{
dr["监测方式"] = "";
}
dr["委托单位"] = dr["wtdepart"].ToString();
if (dr["chargeman"].ToString() != "")
{
DataRow[] druser = dtuser.Select("UserID='" + dr["chargeman"].ToString().Trim() + "'");
if (druser.Length == 1)
{
dr["项目负责人"] = druser[0]["name"].ToString();
}
else
{
dr["项目负责人"] = "";
}
}
}
if (ds.Tables[0].Rows.Count == 0)
{
//没有记录仍保留表头
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
int intColumnCount = grdvw_List.Rows[0].Cells.Count;
grdvw_List.Rows[0].Cells.Clear();
grdvw_List.Rows[0].Cells.Add(new TableCell());
grdvw_List.Rows[0].Cells[0].ColumnSpan = intColumnCount;
}
else
{
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
}
ds.Dispose();
}
private void Query()
{
//strSelectedId=txt_samplequery.Text;
string strSample = "";
string strDate = "";
if (txt_samplequery.Text != "")
{
strSample = "and ReportName like'%" + txt_samplequery.Text + "%'";
}
strSample += " and tkwether='1'";
if (drop_tkwether.SelectedValue.ToString() == "3")
{
strSample += " and (statusID='3')";
btn_OK.Visible = true;
btn_Save.Visible = true;
panel_han.Visible = true;
btn_print.Visible = false;
btn_back.Visible = true;
grdvw_List.Caption = "<FONT style='WIDTH: 102.16%; COLOR:#2292DD;font-size:14pt; LINE-HEIGHT: 150%; FONT-FAMILY: 楷体_GB2312; HEIGHT: 35px'><b>编制整改函</b></font>";
}
else
{
strSample += " and (statusID='5')";
if (Request.Cookies["Cookies"].Values["u_purview"].ToString().Substring(2, 1) != "1")
{
btn_OK.Visible = false;
}
else
{
btn_OK.Visible = true;
}
btn_back.Visible = false;
btn_Save.Visible = false;
panel_han.Visible = true;
btn_print.Visible = true;
grdvw_List.Caption = "<FONT style='WIDTH: 102.16%; COLOR:#2292DD;font-size:14pt; LINE-HEIGHT: 150%; FONT-FAMILY: 楷体_GB2312; HEIGHT: 35px'><b>编制整改函</b></font>";
}
if (Request.Cookies["Cookies"].Values["u_purview"].ToString().Substring(2, 1) != "1")
{
strSample += " and chargeman='" + Request.Cookies["Cookies"].Values["u_id"].ToString() + "'";
}
if (txt_QueryTime.Text != "")
{
strDate = " and (year(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Year + "' AND month(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Month + "' and day(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Day + "')";
}
string strSql = "select t_Y_FlowInfo.id,t_Y_FlowInfo.ReportAccessDate 时间,t_Y_FlowInfo.ItemType,ItemName 项目类型,ReportName 报告标识,urgent 备注,t_Y_FlowInfo.Ulevel,Projectname 项目名称,t_R_UserInfo.Name 项目负责人,rwclass,jcmethod,address,lxman,lxtel,lxemail,wtdepart,wether,varman1,vardate1,varremark1,t_Y_FlowInfo.chargeman,varman2,vardate2,varremark2,tkwether,hcontent,hfwdw,hcs,hanNO 函文号 from t_Y_FlowInfo,t_M_ItemInfo,t_R_UserInfo where t_Y_FlowInfo.ItemType=t_M_ItemInfo.ItemID and chargeman=t_R_UserInfo.UserID and hanwether=1 " + strSample + strDate + " order by t_Y_FlowInfo.ReportAccessDate";
DataSet ds = new MyDataOp(strSql).CreateDataSet();
DataColumn dcc = new DataColumn("紧急程度");
ds.Tables[0].Columns.Add(dcc);
DataColumn dc = new DataColumn("监测方式");
ds.Tables[0].Columns.Add(dc);
DataColumn dc0 = new DataColumn("任务类型");
ds.Tables[0].Columns.Add(dc0);
DataColumn dc1 = new DataColumn("委托单位");
ds.Tables[0].Columns.Add(dc1);
DAl.Sample getobj = new DAl.Sample();
DataTable dtmode = getobj.GetMode("", "mode", "");
DAl.Station get = new DAl.Station();
DataTable dtstation = get.GetWTByName("");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["Ulevel"].ToString() == "1")
{
dr["紧急程度"] = "紧急";
}
else
{
dr["紧急程度"] = "一般";
}
if (dr["rwclass"].ToString() == "1")
{
dr["任务类型"] = "委托监测";
}
else
{
dr["任务类型"] = "例行监测";
}
DataRow[] drsel = dtmode.Select("code='" + dr["jcmethod"].ToString() + "'");
if (drsel.Length == 1)
{
dr["监测方式"] = drsel[0]["name"].ToString();
}
else
{
dr["监测方式"] = "";
}
//if (dr["wtdepart"].ToString().Trim() != "")
//{
// DataRow[] drdep = dtstation.Select("id=" + dr["wtdepart"].ToString().Trim() + "");
// if (drdep.Length == 1)
// dr["委托单位"] = drdep[0]["单位全称"].ToString();
// else
dr["委托单位"] = dr["wtdepart"].ToString().Trim();
// }
}
if (ds.Tables[0].Rows.Count == 0)
{
//没有记录仍保留表头
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
int intColumnCount = grdvw_List.Rows[0].Cells.Count;
grdvw_List.Rows[0].Cells.Clear();
grdvw_List.Rows[0].Cells.Add(new TableCell());
grdvw_List.Rows[0].Cells[0].ColumnSpan = intColumnCount;
}
else
{
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
}
ds.Dispose();
}
private void Query()
{
//strSelectedId=txt_samplequery.Text;
string strSample = "";
string strDate = "";
if (txt_samplequery.Text != "")
{
strSample = "and ReportName like'%" + txt_samplequery.Text + "%'";
}
if (drop_tkwether.SelectedIndex == 0)
{
strSample += " and (StatusID='2') ";
}
else
{
strSample += " and tkwether='1' and StatusID='2'";
}
if (Request.Cookies["Cookies"].Values["u_purview"].ToString().Substring(2, 1) != "1")
{
strSample += " and chargeman='" + Request.Cookies["Cookies"].Values["u_id"].ToString() + "'";
}
if (txt_QueryTime.Text != "")
{
strDate = " and (year(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Year + "' AND month(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Month + "' and day(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Day + "')";
}
string strSql = "select t_Y_FlowInfo.id,t_Y_FlowInfo.ReportAccessDate 时间,t_Y_FlowInfo.ItemType,ItemName 项目类型,ReportName 报告标识,urgent 备注,t_Y_FlowInfo.Ulevel,Projectname 项目名称,t_R_UserInfo.Name 项目负责人,rwclass,jcmethod,address,lxman,lxtel,lxemail,wtdepart,wether,varman1,vardate1,varremark1,t_Y_FlowInfo.chargeman,varman2,vardate2,varremark2,tkwether,fanbackflag ,fanbackremark ,backflag,varremark3 from t_Y_FlowInfo,t_M_ItemInfo,t_R_UserInfo where t_Y_FlowInfo.ItemType=t_M_ItemInfo.ItemID and chargeman=t_R_UserInfo.UserID " + strSample + strDate + " and hanwether=1 order by t_Y_FlowInfo.ReportAccessDate";
DataSet ds = new MyDataOp(strSql).CreateDataSet();
DataColumn dcc = new DataColumn("紧急程度");
ds.Tables[0].Columns.Add(dcc);
DataColumn dc = new DataColumn("监测方式");
ds.Tables[0].Columns.Add(dc);
DataColumn dc0 = new DataColumn("任务类型");
ds.Tables[0].Columns.Add(dc0);
DataColumn dc1 = new DataColumn("委托单位");
ds.Tables[0].Columns.Add(dc1);
DataColumn dc2 = new DataColumn("踏勘是否通过");
ds.Tables[0].Columns.Add(dc2);
DAl.Sample getobj = new DAl.Sample();
DataTable dtmode = getobj.GetMode("", "mode", "");
DAl.Station get = new DAl.Station();
DataTable dtstation = get.GetWTByName("");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["Ulevel"].ToString() == "1")
{
dr["紧急程度"] = "紧急";
}
else
{
dr["紧急程度"] = "一般";
}
if (dr["rwclass"].ToString() == "1")
{
dr["任务类型"] = "委托监测";
}
else
{
dr["任务类型"] = "例行监测";
}
if (dr["tkwether"].ToString() == "1")
{
dr["踏勘是否通过"] = "未通过";
}
else if (dr["tkwether"].ToString() == "0")
{
dr["踏勘是否通过"] = "通过";
}
else
{
dr["踏勘是否通过"] = "";
}
DataRow[] drsel = dtmode.Select("code='" + dr["jcmethod"].ToString() + "'");
if (drsel.Length == 1)
{
dr["监测方式"] = drsel[0]["name"].ToString();
}
else
{
dr["监测方式"] = "";
}
//if (dr["wtdepart"].ToString().Trim() != "")
//{
// DataRow[] drdep = dtstation.Select("id=" + dr["wtdepart"].ToString().Trim() + "");
// if (drdep.Length == 1)
dr["委托单位"] = dr["wtdepart"].ToString();
// else
// dr["委托单位"] = "";
//}
}
if (ds.Tables[0].Rows.Count == 0)
{
//没有记录仍保留表头
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
int intColumnCount = grdvw_List.Rows[0].Cells.Count;
grdvw_List.Rows[0].Cells.Clear();
grdvw_List.Rows[0].Cells.Add(new TableCell());
grdvw_List.Rows[0].Cells[0].ColumnSpan = intColumnCount;
}
else
{
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
}
ds.Dispose();
}
private void Query()
{
//strSelectedId=txt_samplequery.Text;
string strSample = "";
string strDate = "";
if (txt_samplequery.Text.Trim() != "")
{
strSample = "and ReportName like'%" + txt_samplequery.Text.Trim() + "%'";
}
if (txt_QueryWTDW.Text.Trim() != "")
{
strSample = "and wtdepart like'%" + txt_QueryWTDW.Text.Trim() + "%'";
}
if (txt_QueryTime.Text.Trim() != "")
{
strDate = " and (year(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Year + "' AND month(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Month + "' and day(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Day + "')";
}
string strSql = "select t_M_ReporInfo.id,t_M_ReporInfo.ReportAccessDate 时间,t_M_ReporInfo.ItemType,ItemName 项目类型,ReportName 报告标识,urgent 备注,t_M_ReporInfo.Ulevel,Projectname 项目名称, ItemName 项目负责人,rwclass,jcmethod,address,lxman,lxtel,lxemail,wtdepart,Green , chargeman from t_M_ReporInfo,t_M_ItemInfo where t_M_ReporInfo.ItemType=t_M_ItemInfo.ItemID and (StatusID=0) and wetherscance=0 " + strSample + strDate + " order by t_M_ReporInfo.id";
DataSet ds = new MyDataOp(strSql).CreateDataSet();
DataColumn dcc = new DataColumn("紧急程度");
ds.Tables[0].Columns.Add(dcc);
DataColumn dc = new DataColumn("监测方式");
ds.Tables[0].Columns.Add(dc);
DataColumn dc0 = new DataColumn("任务类型");
ds.Tables[0].Columns.Add(dc0);
DataColumn dc1 = new DataColumn("委托单位");
ds.Tables[0].Columns.Add(dc1);
DataColumn dc11 = new DataColumn("是否走绿色通道");
ds.Tables[0].Columns.Add(dc11);
DAl.Sample getobj = new DAl.Sample();
DataTable dtmode = getobj.GetMode("", "mode", "");
DAl.Station get = new DAl.Station();
DataTable dtstation = get.GetWTByName("");
string strtemp = "select Name,UserID from t_R_UserInfo";
DataSet ds_User = new MyDataOp(strtemp).CreateDataSet();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["chargeman"].ToString().Trim() != "")
{
DataRow[] druser = ds_User.Tables[0].Select("UserID='" + dr["chargeman"].ToString().Trim() + "'");
if (druser.Length == 1)
{
dr["项目负责人"] = druser[0]["Name"].ToString();
}
else
{
dr["项目负责人"] = "";
}
}
else
{
dr["项目负责人"] = "";
}
if (dr["Ulevel"].ToString() == "1")
{
dr["紧急程度"] = "紧急";
}
else
{
dr["紧急程度"] = "一般";
}
if (dr["rwclass"].ToString() == "1")
{
dr["任务类型"] = "委托监测";
}
else
{
dr["任务类型"] = "例行监测";
}
DataRow[] drsel = dtmode.Select("code='" + dr["jcmethod"].ToString() + "'");
if (drsel.Length == 1)
{
dr["监测方式"] = drsel[0]["name"].ToString();
}
else
{
dr["监测方式"] = "";
}
if (dr["Green"].ToString() == "1")
{
dr["是否走绿色通道"] = "是";
}
else
{
dr["是否走绿色通道"] = "否";
}
dr["委托单位"] = dr["wtdepart"].ToString();
}
if (ds.Tables[0].Rows.Count == 0)
{
//没有记录仍保留表头
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
int intColumnCount = grdvw_List.Rows[0].Cells.Count;
grdvw_List.Rows[0].Cells.Clear();
grdvw_List.Rows[0].Cells.Add(new TableCell());
grdvw_List.Rows[0].Cells[0].ColumnSpan = intColumnCount;
}
else
{
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
}
ds.Dispose();
}
private void Query()
{
//strSelectedId=txt_samplequery.Text;
string strSample = "";
string strDate = "";
if (txt_wt_Query.Text.Trim() != "")
{
strSample += "and wtdepart like'%" + txt_samplequery.Text + "%'";
}
if (txt_wt_Query.Text.Trim() != "")
{
strSample += "and wtdepart like'%" + txt_samplequery.Text + "%'";
}
if (txt_project_Query.Text != "")
{
strSample += "and Projectname like'%" + txt_project_Query.Text + "%'";
}
if (txt_QueryTime.Text != "")
{
strDate = " and (year(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Year + "' AND month(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Month + "' and day(ReportAccessDate)= '" + DateTime.Parse(txt_QueryTime.Text.Trim() + " 00:00:00").Day + "')";
}
if (drop_status.SelectedValue.Trim() == "0")//受理中
{
strSample += " and (StatusID='0' and wether=0)";
}
else if (drop_status.SelectedValue.Trim() == "1.7")//初审不通过
{
strSample += " and (StatusID='0' and wether=1)";
}
else if (drop_status.SelectedValue.Trim() == "2.5")//函编制完成
{
strSample += " and (StatusID='5' and wether=0 and tkwether=1)";
}
else
{
strSample += " and (StatusID>'0')";
}
string strSql = "select t_Y_FlowInfo.id,t_Y_FlowInfo.ReportAccessDate 时间,t_Y_FlowInfo.ItemType,ItemName 项目类型,ReportName 报告标识,urgent 备注,t_Y_FlowInfo.Ulevel,Projectname 项目名称,rwclass,jcmethod,address,lxman,lxtel,lxemail,wtdepart,backflag ,varremark1,wether from t_Y_FlowInfo,t_M_ItemInfo where t_Y_FlowInfo.ItemType=t_M_ItemInfo.ItemID " + strSample + strDate + " order by t_Y_FlowInfo.ReportAccessDate desc";
DataSet ds = new MyDataOp(strSql).CreateDataSet();
DataColumn dcc = new DataColumn("紧急程度");
ds.Tables[0].Columns.Add(dcc);
DataColumn dc = new DataColumn("监测方式");
ds.Tables[0].Columns.Add(dc);
DataColumn dc0 = new DataColumn("任务类型");
ds.Tables[0].Columns.Add(dc0);
DataColumn dc1 = new DataColumn("委托单位");
ds.Tables[0].Columns.Add(dc1);
DAl.Sample getobj = new DAl.Sample();
DataTable dtmode = getobj.GetMode("", "mode", "");
DAl.Station get = new DAl.Station();
DataTable dtstation = get.GetWTByName("");
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["Ulevel"].ToString() == "1")
{
dr["紧急程度"] = "紧急";
}
else
{
dr["紧急程度"] = "一般";
}
if (dr["rwclass"].ToString() == "1")
{
dr["任务类型"] = "委托监测";
}
else
{
dr["任务类型"] = "例行监测";
}
DataRow[] drsel = dtmode.Select("code='" + dr["jcmethod"].ToString() + "'");
if (drsel.Length == 1)
{
dr["监测方式"] = drsel[0]["name"].ToString();
}
else
{
dr["监测方式"] = "";
}
dr["委托单位"] = dr["wtdepart"].ToString();
}
if (ds.Tables[0].Rows.Count == 0)
{
//没有记录仍保留表头
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
int intColumnCount = grdvw_List.Rows[0].Cells.Count;
grdvw_List.Rows[0].Cells.Clear();
grdvw_List.Rows[0].Cells.Add(new TableCell());
grdvw_List.Rows[0].Cells[0].ColumnSpan = intColumnCount;
}
else
{
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
}
ds.Dispose();
}
