//protected void grv_b_RowCreated(object sender, GridViewRowEventArgs e)
//{
// if (e.Row.RowType == DataControlRowType.Header)
// {
// e.Row.Cells[3].Text = "监测项目";
// TableCell headerDetail = new TableCell();
// headerDetail.Text = "分析方法选择";
// headerDetail.BackColor = System.Drawing.Color.FromArgb(227, 239, 255);
// headerDetail.Width = 600;
// e.Row.Cells.Add(headerDetail);
// }
// if (e.Row.RowType == DataControlRowType.DataRow)
// {
// //鼠标移动到每项时颜色交替效果
// e.Row.Attributes.Add("OnMouseOut", "this.style.backgroundColor='';");
// e.Row.Attributes.Add("OnMouseOver", "this.style.backgroundColor='#00ffee'");
// //int id = e.Row.RowIndex + 1;
// //e.Row.Cells[0].Text = id.ToString();
// //手动添加详细和删除按钮
// TableCell tabcDetail = new TableCell();
// tabcDetail.Style.Add("text-align", "center");
// RadioButtonList ibtnDetail = new RadioButtonList();
// ibtnDetail.ID = "cbl";
// ibtnDetail.SelectedIndex = 0;
// tabcDetail.Controls.Add(ibtnDetail);
// e.Row.Cells.Add(tabcDetail);
// }
// if (e.Row.RowType != DataControlRowType.Pager)
// {
// ////绑定数据后，隐藏4,5,6,7列
// e.Row.Cells[1].Visible = false;
// e.Row.Cells[2].Visible = false;
// }
//}
//protected void grv_b_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// if (e.Row.RowType == DataControlRowType.DataRow)
// {
// if (e.Row.Cells[1].Text.Trim() != " ")
// {
// DataTable Method = itemObj.GetMethod(e.Row.Cells[1].Text.Trim());//dtItem.Select("ClassID='" + e.Row.Cells[1].Text.Trim() + "'");
// RadioButtonList cbl_temp = e.Row.Cells[4].FindControl("cbl") as RadioButtonList;
// cbl_temp.RepeatDirection = RepeatDirection.Vertical;
// cbl_temp.DataSource = Method;
// cbl_temp.DataValueField = "id";
// cbl_temp.DataTextField = "Standard";
// cbl_temp.DataBind();
// }
// }
//}
protected void btn_save_b_OnClick(object sender, EventArgs e)
{
DAl.User.Users userobj = new DAl.User.Users();
Entity.User.Users userentity = new Entity.User.Users();
userentity.UserID = txt_UserName.Text;
for (int p = 0; p < Repeater_B.Items.Count; p++)
{
CheckBoxList cbl_ItemlistB = Repeater_B.Items[p].FindControl("cbl_ItemlistB") as CheckBoxList;
//TBD AB角信息初始化
for (int i = 0; i < cbl_ItemlistB.Items.Count; i++)
{
if (cbl_ItemlistB.Items[i].Selected)
{
Entity.SampleItem item = new Entity.SampleItem();
item.MonitorID = int.Parse(cbl_ItemlistB.Items[i].Value);
item.MonitorItem = cbl_ItemlistB.Items[i].Text.Trim();
userentity.AitemList.Add(item);
}
}
}
//保存用户AB角
if (userobj.SaveAB(userentity, "B") == 1)
{
Repeater_B.Visible = false;
btn_b_add.Text = "+分析员B角设定";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('B角设定成功！');", true);
ABRoleGroup(userentity.UserID);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('B角设定失败！');", true);
}
}
protected void btn_save_b_OnClick(object sender, EventArgs e)
{
DAl.User.Users userobj = new DAl.User.Users();
Entity.User.Users userentity = new Entity.User.Users();
userentity.UserID = txt_UserName.Text;
//TBD AB角信息初始化
for (int i = 0; i < cbl_ItemlistB.Items.Count; i++)
{
if (cbl_ItemlistB.Items[i].Selected)
{
Entity.SampleItem item = new Entity.SampleItem();
item.TypeID = int.Parse(drop_type_b.SelectedValue.ToString().Trim());
item.MonitorID = int.Parse(cbl_ItemlistB.Items[i].Value);
item.MonitorItem = cbl_ItemlistB.Items[i].Text.Trim();
userentity.AitemList.Add(item);
}
}
//保存用户AB角
if (userobj.SaveAB(userentity, "B", drop_type_b.SelectedValue.ToString().Trim()) == 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('B角设定成功！');", true);
panel_b.Visible = false;
ABRoleGroup(userentity.UserID);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('B角设定失败！');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//this.Title = "监测报告数据组成表";
if (!IsPostBack)
{
#region 初始化页面
txt_StartTime.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd'})");
txt_EndTime.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd'})");
txt_StartTime.Text = DateTime.Now.Date.ToString("yyyy-01-01");
txt_EndTime.Text = DateTime.Now.Date.ToString("yyyy-MM-dd");
for (int i = 0; i < cbl_sampleType.Items.Count; i++)
{
cbl_sampleType.Items[i].Selected = true;
}
DAl.User.Users userobj = new DAl.User.Users();
fxman = userobj.QueryUsersDT("", "48, 49, 50, 51, 52, 58");
cbl_man.DataSource = fxman;
cbl_man.DataTextField = "Name";
cbl_man.DataValueField = "UserID";
cbl_man.DataBind();
//ListItem li = new ListItem("请选择", "0");
//drop_man.Items.Add(li);
//drop_man.SelectedIndex = drop_man.Items.Count - 1;
Query(0);
#endregion
}
}
protected void btn_OK_Click(object sender, EventArgs e)
{
string strErrorInfo = Verify(lbl_Type.Text);
if (strErrorInfo != "")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('" + strErrorInfo + "');", true);
return;
}
//获得所属地id
string strAttribtionID = "";
strAttribtionID = drop_ThrSca_Name.SelectedValue;
DateTime nowTime = DateTime.Parse(DateTime.Now.ToString());
DAl.User.Users userobj = new DAl.User.Users();
Entity.User.Users userentity = new Entity.User.Users();
userentity.UserID = txt_UserName.Text;
userentity.PWD = Txt_pwd.Text.Trim();
userentity.DepartID = int.Parse(strAttribtionID);
userentity.RoleID = int.Parse(drop_Role.SelectedValue);
userentity.PWDModifyTime = nowTime;
userentity.Name = txt_name.Text.Trim();
#region 添加新纪录
if (lbl_Type.Text == "添加")
{
int ret = userobj.AddUsers(userentity);
if (ret >= 1)
{
strSelectedId = ret.ToString();
panel_role.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据添加成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据添加失败！');", true);
}
}
#endregion
#region 编辑记录
if (lbl_Type.Text == "编辑")
{
userentity.ID = int.Parse(strSelectedId);
if (userobj.EditUsers(userentity) == 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据编辑成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据编辑失败！');", true);
}
}
#endregion
Query();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//txt_AccessTime.Attributes.Add("OnFocus", "javascript:calendar()");
txt_QueryTime.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd'})");
DAl.User.Users userobj = new DAl.User.Users();
DAl.User.UserRole userrole = new DAl.User.UserRole();
string strrole = userrole.RoleListListStr(1);
fxman = userobj.QueryUsersDT("", strrole);
ReportQuery();
grdvw_List.Caption = "<FONT style='WIDTH: 102.16%; COLOR: #2292DD;font-size:14pt; LINE-HEIGHT: 150%; FONT-FAMILY: 楷体_GB2312; HEIGHT: 35px'><b>分工指派</b></font>";
}
}
protected void grv_b_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DAl.User.Users userobj = new DAl.User.Users();
Entity.User.Users userentity = new Entity.User.Users();
userentity.UserID = txt_UserName.Text;
string type = grv_b.Rows[e.RowIndex].Cells[0].Text.Trim();
if (userobj.DeleteAB(userentity, "B", type) == 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('删除成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('删除失败！');", true);
}
ABRoleGroup(userentity.UserID);
}
protected void btn_save_b_OnClick(object sender, EventArgs e)
{
DAl.User.Users userobj = new DAl.User.Users();
Entity.User.Users userentity = new Entity.User.Users();
userentity.UserID = txt_UserName.Text;
for (int p = 0; p < Repeater_B.Items.Count; p++)
{
GridView grv_b = Repeater_B.Items[p].FindControl("grv_b") as GridView;
//TBD AB角信息初始化
for (int i = 0; i < grv_b.Rows.Count; i++)
{
CheckBox cb = grv_b.Rows[i].Cells[0].FindControl("autoid") as CheckBox;
if (cb.Checked)
{
Entity.SampleItem item = new Entity.SampleItem();
item.MonitorID = int.Parse(grv_b.Rows[i].Cells[1].Text.Trim());
item.MonitorItem = grv_b.Rows[i].Cells[3].Text.Trim();
RadioButtonList cbl = grv_b.Rows[i].Cells[4].FindControl("cbl") as RadioButtonList;
for (int j = 0; j < cbl.Items.Count; j++)
{
if (cbl.Items[j].Selected)
{
item.Method = cbl.Items[j].Value.Trim();
}
}
userentity.AitemList.Add(item);
}
}
}
//保存用户AB角
if (userobj.SaveAB(userentity, "B") == 1)
{
Repeater_B.Visible = false;
btn_b_add.Text = "+分析员B角设定";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('B角设定成功！');", true);
ABRoleGroup(userentity.UserID);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('B角设定失败！');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Cookies"] != null)
{
if (!IsPostBack)
{
#region 初始化页面元素
DAl.User.Users userobj = new DAl.User.Users();
userdt = userobj.QueryUsersDT("", "");
string sql = "select name from t_R_UserInfo where userid = '" + Request.Cookies["Cookies"].Values["u_id"].ToString().Trim() + "'";
DataSet ds = new MyDataOp(sql).CreateDataSet();
name = ds.Tables[0].Rows[0][0].ToString();
MyStaVoid.BindList("DepartName", "DepartID", "select DepartName,DepartID from t_M_DepartInfo where flag='1'", drop_depart);
ListItem li = new ListItem("所有", "-1");
drop_depart.Items.Add(li);
drop_depart.SelectedIndex = drop_depart.Items.Count - 1;
//SetTxt();
//SetButton();
txts_time1.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd'})");
txts_time1.Text = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
txts_time2.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd'})");
txts_time2.Text = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
txt_date.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd'})");
grdvw_List.Caption = "<FONT style='WIDTH: 102.16%; COLOR: #2292DD;font-size:14pt; LINE-HEIGHT: 100%; FONT-FAMILY: 楷体_GB2312; HEIGHT: 35px'><b>外出记录列表</b></font>";
txt_time1.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'HH:mm'})");
txt_time2.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'HH:mm'})");
#endregion
Query();
}
}
else
{
Response.Write("<script language='javascript'>alert('您没有权限进入本页或当前登录用户已过期！\\n请重新登录或与管理员联系！');parent.location='../login.aspx';</script>");
}
}
protected void btn_OK_Click(object sender, EventArgs e)
{
string strFlag = Verify();
if (strFlag != "")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('" + strFlag + "');", true);
return;
}
else
{
string compay = "0";
string cyman = "0";
//获取采样人，现场分析人
DAl.User.Users userobj = new DAl.User.Users();
Entity.User.Users user = null; //= new Entity.User.Users();
user = userobj.GetUsers(txt_xmfzr.Text.Trim());
if (user != null)
{
cyman = user.UserID.ToString();
}
else
{
if (rbl_wether.SelectedValue.ToString() == "0")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('系统不存在项目负责人/报告编制人，请核实！');", true);
return;
}
}
Entity.AccessReport entity = new Entity.AccessReport();
entity.classID = int.Parse(drop_rwtype.SelectedValue.ToString());//任务类型
compay = txt_wtdepart.Text.Trim();
if (ck_fa.Checked)
{
entity.hanwether = "1";
}
else
{
entity.hanwether = "0";
}
entity.WTMan = compay;//委托单位
entity.lxEmail = txt_lxemail.Text.Trim();
entity.lxMan = txt_lxman.Text.Trim();;
entity.lxtel = txt_lxtel.Text.Trim();;
entity.address = txt_address.Text.Trim();
entity.CreateDate = DateTime.Now; //创建时间
entity.CreateUser = Request.Cookies["Cookies"].Values["u_id"].ToString(); //创建人
entity.WTDate = DateTime.Parse(txt_CreateDate.Text.Trim()); //委托日期，任务接收日期
entity.chargeman = cyman; //项目负责人
//entity.level = drop_level.SelectedValue.ToString();//紧急程度
entity.Mode = drop_mode.SelectedValue.ToString(); //监测方式
entity.Remark = drop_urgent.Text.Trim(); //备注
entity.WTNO = txt_ReportID.Text.Trim(); //委托协议编码，报告标识
entity.ProjectName = txt_Projectname.Text.Trim(); //项目名称
entity.TypeID = int.Parse(drop_ItemList.SelectedValue.ToString().Trim());
entity.CreateDate = DateTime.Now; //创建时间
entity.CreateUser = Request.Cookies["Cookies"].Values["u_id"].ToString(); //创建人
entity.chargeman = cyman; //项目负责人
entity.level = drop_level.SelectedValue.ToString(); //紧急程度
// entity.Mode = drop_mode.SelectedValue.ToString();//监测方式
//if (rbl_wether.SelectedValue.ToString() == "0")
//{
// entity.csflag = 0;
//}
//else
//{
// entity.csflag = 1;
//}
entity.StatusID = 6;
entity.Remark = txt_remak1.Text.Trim();//备注
DAl.Report reportobj = new DAl.Report();
entity.StatusID = 1;
entity.ID = int.Parse(strReportId);
if (reportobj.UpateYSzp(entity) == 1)
{
WebApp.Components.Log.SaveLog("创建样品原单编辑成功！", Request.Cookies["Cookies"].Values["u_id"].ToString(), 5);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "clickAddSuccess", "hiddenDetail();alert('数据保存成功！')", true);
}
else
{
WebApp.Components.Log.SaveLog("创建样品原单编辑失败！", Request.Cookies["Cookies"].Values["u_id"].ToString(), 5);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "clickAddFail", "hiddenDetail();alert('数据添保存失败！')", true);
}
}
Query();
}
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();
}
