//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(); }