//设施 void BindFacility(string Road_ID) { //应该来自用户数据库 //取出Road.ID using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { CODEINFO temp = new CODEINFO(); temp.STNDNAME = "ROADWAY.FACILITY"; sence.Context = new ZZHMHN.Web.Core.InvokeContext("", Road_ID); List <CODEINFO> lst = sence.Bll.CodeInfo.Get <CODEINFO>(temp); lst_Facility.DataSource = lst; lst_Facility.DataTextField = "info"; lst_Facility.DataValueField = "CODE"; lst_Facility.DataBind(); if (lst_Facility.Items.Count > -1) { lst_Facility.SelectedIndex = 0; } } //CODEINFO temp = new CODEINFO(); //temp.STNDNAME = "ROADWAY.FACILITY"; //List<CODEINFO> lst = MyApp.Bll.CodeInfo.Get<CODEINFO>(temp); }
//材料类型 void BindMatl(string Road_ID) { //应该来自用户数据库 using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { CODEINFO temp = new CODEINFO(); temp.STNDNAME = "RDLAY.MTRLTYPE"; sence.Context = new ZZHMHN.Web.Core.InvokeContext("", Road_ID); List <CODEINFO> lst = sence.Bll.CodeInfo.Get <CODEINFO>(temp); List <CODEINFO> newLst = new List <CODEINFO>(); foreach (CODEINFO c in lst) { if ((c.CODE >= 120 && c.CODE <= 139) || (c.CODE >= 170 && c.CODE <= 190)) { newLst.Add(c); } } cmbMatl.DataSource = newLst; cmbMatl.DataTextField = "info"; cmbMatl.DataValueField = "CODE"; cmbMatl.DataBind(); cmbMatl.SelectedIndex = 0; } }
//次要方向 void BindSecDir(string Road_ID) { //应该来自用户数据库 using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { CODEINFO temp = new CODEINFO(); temp.STNDNAME = "ROADWAY.SECONDDIR"; sence.Context = new ZZHMHN.Web.Core.InvokeContext("", Road_ID); List <CODEINFO> lst = sence.Bll.CodeInfo.Get <CODEINFO>(temp); ddl_SecDir.DataSource = lst; ddl_SecDir.DataTextField = "info"; ddl_SecDir.DataValueField = "CODE"; ddl_SecDir.DataBind(); } }
//添加类型 void BindAsphalt(string Road_ID) { //应该来自用户数据库 using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { CODEINFO temp = new CODEINFO(); temp.STNDNAME = "RDLAY.ASPHTYPE"; sence.Context = new ZZHMHN.Web.Core.InvokeContext("", Road_ID); List <CODEINFO> lst = sence.Bll.CodeInfo.Get <CODEINFO>(temp); cmbAsphalt.DataSource = lst; cmbAsphalt.DataTextField = "info"; cmbAsphalt.DataValueField = "CODE"; cmbAsphalt.DataBind(); cmbAsphalt.SelectedIndex = 0; } }
void BindParm(string Road_ID) { using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { sence.Context = new ZZHMHN.Web.Core.InvokeContext("", Road_ID); List <PMSELTS> lst = sence.Bll.Pmselts.Get <PMSELTS>(new PMSELTS { UPDATE_MULT = -1 }); ddl_Parm.DataSource = lst; ddl_Parm.DataTextField = "ENGL_NAME"; ddl_Parm.DataValueField = "STND_NAME"; ddl_Parm.DataBind(); ddl_Parm.SelectedIndex = 0; ddl_Parm_SelectedIndexChanged(this, null); } }
//应该来自用户数据库 void BindRoadName(string Road_ID) { using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { CODEINFO temp = new CODEINFO(); temp.STNDNAME = "ROADWAY.ROADNUM"; sence.Context = new ZZHMHN.Web.Core.InvokeContext("", Road_ID); List <CODEINFO> lst = sence.Bll.CodeInfo.Get <CODEINFO>(temp); ddl_RoadName.DataSource = lst; ddl_RoadName.DataTextField = "info"; ddl_RoadName.DataValueField = "CODE"; ddl_RoadName.DataBind(); ddl_RoadName.SelectedIndex = 0; ddl_RoadName_SelectedIndexChanged(this, null); } }
//查询用户库的SegID private string GetSegID() { string segIDs = ""; using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { sence.Context = new ZZHMHN.Web.Core.InvokeContext("", ViewState["Road_ID"].ToString()); List <Selection> lstSelection = sence.Bll.Selection.Get <Selection>(); foreach (Selection s in lstSelection) { segIDs += s.SEGID + ","; } if (segIDs != "") { segIDs = segIDs.Substring(0, segIDs.Length - 1); } } Session["segIDs"] = segIDs; return(segIDs); }
protected void ddl_Parm_SelectedIndexChanged(object sender, EventArgs e) { //找到ddl_parm值所在的Val_op1 List <string> val_op1 = null; using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { sence.Context = new ZZHMHN.Web.Core.InvokeContext("", ViewState["Road_ID"].ToString()); val_op1 = sence.Bll.Pmselts.GetVal_OP(ddl_Parm.SelectedValue.Trim());//STNDNAME } if (val_op1 != null && val_op1[0].Trim() == "T") { txtParamValue.Visible = false; //绑定ddl_ParmValue using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { sence.Context = new ZZHMHN.Web.Core.InvokeContext("", ViewState["Road_ID"].ToString()); CODEINFO temp = new CODEINFO() { STNDNAME = ddl_Parm.SelectedValue.Trim() }; List <CODEINFO> lstCode = sence.Bll.CodeInfo.Get <CODEINFO>(temp); ddl_Value.DataSource = lstCode; ddl_Value.DataTextField = "info"; ddl_Value.DataValueField = "code"; ddl_Value.DataBind(); ddl_Value.SelectedIndex = 0; ddl_Value.Visible = true; } } else { txtParamValue.Visible = true; ddl_Value.Visible = false; } }
protected void btn_OK_Click(object sender, EventArgs e) { //根据ddl_Parm.SelectedValue取出 using (ZZHMHN.IBase.I_Core.IScene sence = MyApp.Scene) { sence.Context = new ZZHMHN.Web.Core.InvokeContext("", ViewState["Road_ID"].ToString()); List <PMSELTS> lst = sence.Bll.Pmselts.Get <PMSELTS>(new PMSELTS { STND_NAME = ddl_Parm.SelectedValue }); //查询单个PMSELTS PMSELTS temp = null; if (lst.Count > 0) { temp = lst[0]; string tableName, fieldName, fieldValue = null; string[] tableName_fieldName = temp.STND_NAME.Split('.');//得到用户库的segid if (tableName_fieldName.Length == 2) { tableName = tableName_fieldName[0].Trim(); fieldName = tableName_fieldName[1].Trim(); //根据判断更新 if (temp.VAL_OP1.Trim() == "T") { fieldValue = ddl_Value.SelectedValue; } else if (temp.TYPE.Trim() == "C") { if (txtParamValue.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请输入有效文字');</script>"); return; } fieldValue = txtParamValue.Text; } else if (temp.TYPE.Trim() == "D") { if (Common.Rex.Regexlib.IsDate(txtParamValue.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请输入有效日期');</script>"); return; } fieldValue = "#" + txtParamValue.Text + "#"; } else if (temp.TYPE.Trim() == "N") { double UpdtVal = Conversion.Val(txtParamValue.Text); if (temp.VAL_OP1.Trim() == ">=") { if (temp.VAL_LOG_OP.Trim() == "A") { if (temp.VAL_OP2.Trim() == "<=") { if (UpdtVal < Conversion.Val(temp.VAL_ARG1) || UpdtVal > Conversion.Val(temp.VAL_ARG2)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于等于" + temp.VAL_ARG1.Trim() + "且小于等于" + temp.VAL_ARG2.Trim() + "');</script>"); return; } } else if (temp.VAL_OP2.Trim() == "<") { if (UpdtVal < Conversion.Val(temp.VAL_ARG1) || UpdtVal >= Conversion.Val(temp.VAL_ARG2)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于等于" + temp.VAL_ARG1.Trim() + "且小于" + temp.VAL_ARG2.Trim() + "');</script>"); return; } } } else if (temp.VAL_LOG_OP.Trim() == "O") { if (temp.VAL_OP2.Trim() == "<=") { if (!(UpdtVal >= Conversion.Val(temp.VAL_ARG1) || UpdtVal <= Conversion.Val(temp.VAL_ARG2))) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于等于" + temp.VAL_ARG1.Trim() + "或小于等于" + temp.VAL_ARG2.Trim() + "');</script>"); return; } } else if (temp.VAL_OP2.Trim() == "<") { if (!(UpdtVal >= Conversion.Val(temp.VAL_ARG1) || UpdtVal < Conversion.Val(temp.VAL_ARG2))) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于等于" + temp.VAL_ARG1.Trim() + "或小于" + temp.VAL_ARG2.Trim() + "');</script>"); return; } } } else { if (UpdtVal < Conversion.Val(temp.VAL_ARG1)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于等于" + temp.VAL_ARG1.Trim() + "');</script>"); return; } } } else if (temp.VAL_OP1.Trim() == ">") { if (temp.VAL_LOG_OP.Trim() == "A") { if (temp.VAL_OP2.Trim() == "<=") { if (UpdtVal <= Conversion.Val(temp.VAL_ARG1) || UpdtVal > Conversion.Val(temp.VAL_ARG2)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于" + temp.VAL_ARG1.Trim() + "且小于等于" + temp.VAL_ARG2.Trim() + "');</script>"); return; } } else if (temp.VAL_OP2.Trim() == "<") { if (UpdtVal <= Conversion.Val(temp.VAL_ARG1) || UpdtVal >= Conversion.Val(temp.VAL_ARG2)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于" + temp.VAL_ARG1.Trim() + "且小于" + temp.VAL_ARG2.Trim() + "');</script>"); return; } } } else if (temp.VAL_LOG_OP.Trim() == "O") { if (temp.VAL_OP2.Trim() == "<=") { if (!(UpdtVal > Conversion.Val(temp.VAL_ARG1) || UpdtVal <= Conversion.Val(temp.VAL_ARG2))) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于" + temp.VAL_ARG1.Trim() + "或小于等于" + temp.VAL_ARG2.Trim() + "');</script>"); return; } } else if (temp.VAL_OP2.Trim() == "<") { if (!(UpdtVal > Conversion.Val(temp.VAL_ARG1) || UpdtVal < Conversion.Val(temp.VAL_ARG2))) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于" + temp.VAL_ARG1.Trim() + "或小于" + temp.VAL_ARG2.Trim() + "');</script>"); return; } } } else { if (UpdtVal <= Conversion.Val(temp.VAL_ARG1)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该值必须大于" + temp.VAL_ARG1.Trim() + "');</script>"); return; } } } fieldValue = UpdtVal.ToString(); } //执行修改 MyApp.Bll.Pmselts.ExcuteSqlByIHPMS(tableName, fieldName, fieldValue, ViewState["RoadCode"].ToString(), Session["segIDs"].ToString(), ViewState["BeginPoint"].ToString(), ViewState["EndPotin"].ToString()); Response.Write("<script>alert('修改成功!');window.close();</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('表或字段此参数的名称不完整,多段更新无法完成');</script>"); } } } }