//设施
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 BindDropDownList(DropDownList ddl, string keyName, string STNDNAME)
{
CODEINFO temp = new CODEINFO();
temp.STNDNAME = STNDNAME;// "ROADWAY.ROADNUM";
List <CODEINFO> lst = MyApp.Bll.CodeInfo.Get <CODEINFO>(temp);
ddl.DataSource = lst;
ddl.DataTextField = "info";
ddl.DataValueField = "CODE";
ddl.DataBind();
ddl.SelectedItem.Text = keyName;//指定显示项
}
//次要方向
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 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);
}
}
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)
{
//添加道路设备
string FacilCode = lst_Facility.SelectedValue;
//FacilCode& = FacilityList.ItemData(FacilityList.ListIndex) 得到被选的设备value
bool RoadFound = false;
//判断是否在Codeinfo已经存在,赋值给 RoadFound%
//应该来自用户数据库
CODEINFO temp = new CODEINFO();
temp.STNDNAME = "ROADWAY.ROADNUM";
temp.INFO = ddl_RoadName.SelectedItem.Text;
List <CODEINFO> lst = MyApp.Bll.CodeInfo.Get <CODEINFO>(temp);
int curCode = 0;
foreach (CODEINFO code in lst)
{
//取出当前RoadNum
if (code.INFO == temp.INFO)
{
curCode = code.CODE;
RoadFound = true;
break;
}
}
if (!RoadFound)
{
// RNumCode& = SELECT Max(Val(CODE)) AS MAXRNUM FROM CODEINFO WHERE STNDNAME = 'ROADWAY.ROADNUM' +1
CODEINFO code = new CODEINFO
{
CODE = MyApp.Bll.CodeInfo.GetMaxNum()[0] + 1, //应该来自基础数据库
STNDNAME = "ROADWAY.ROADNUM",
INFO = ddl_RoadName.Text // 道路名称
};
MyApp.Bll.CodeInfo.Insert(code); //保存到基础数据库
}
else
{
ROADWAY r = new ROADWAY()
{
FACILITY = FacilCode,
ROADNUM = curCode.ToString()
};
if (MyApp.Bll.RoadWay.Get <ROADWAY>(r).Count > 0) //应该来自基础数据库
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('所选道路已存在的此设备,无法添加一个新的道路');</script>");
return;
}
}
// else{
//SELECT * FROM ROADWAY WHERE FACILITY = '" & Format$(FacilCode&) & "' AND ROADNUM = ' + curCode
//提示已经存在
// }
//Find new RDWAYID.
ROADWAY roadWayInfo = new ROADWAY {
RDWAYID = MyApp.Bll.RoadWay.GetMaxNum()[0] + 1, //应该来自基础数据库
FACILITY = FacilCode,
REVDATE = DateTime.Now,
PRIMARYDIR = ddl_PriDir.SelectedValue.ToString(),
SECONDDIR = ddl_SecDir.SelectedValue.ToString(),
COMMENTS = txt_Comment.Text,
BEGINDATE = Convert.ToDateTime(txt_BeginTime.Text),
TYPE = "1",
STATUS = "1",
MAINTRESP = "1",
ROADNUM = curCode.ToString()
};
//RdWayDs("ROADNUM") = Format$(RNumCode&)
MyApp.Bll.RoadWay.Insert(roadWayInfo); //应该来自基础数据库
//添加到roadway表
Response.Write("<script>alert('添加成功！');window.opener.location.href=window.opener.location.href;window.close();</script>");
}
