protected void dgv_Man_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow drv = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent)); //此得出的值是表示那行被选中的索引值
//取主键
int key = Convert.ToInt32(dgv_Man.DataKeys[drv.RowIndex].Value);
if (e.CommandName == "xg") //修改
{
//取值
string RoadNum = ((DropDownList)dgv_Man.Rows[drv.RowIndex].FindControl("ddl_Road")).SelectedValue;
string FACILITYNum = ((DropDownList)dgv_Man.Rows[drv.RowIndex].FindControl("ddl_FACILITY")).SelectedValue;
string PRIMARYDIRNum = ((DropDownList)dgv_Man.Rows[drv.RowIndex].FindControl("ddl_PRIMARYDIR")).SelectedValue;
string SECONDDIRNum = ((DropDownList)dgv_Man.Rows[drv.RowIndex].FindControl("ddl_SECONDDIR")).SelectedValue;
DateTime BegeinTime = Convert.ToDateTime(((TextBox)dgv_Man.Rows[drv.RowIndex].FindControl("txt_Time")).Text);
string COMMENTS = ((TextBox)dgv_Man.Rows[drv.RowIndex].FindControl("txt_COMMENTS")).Text;
MyApp.Bll.RoadWay.Update(new ROADWAY {
RDWAYID = key, ROADNUM = RoadNum,
FACILITY = FACILITYNum, BEGINDATE = BegeinTime, PRIMARYDIR = PRIMARYDIRNum,
SECONDDIR = SECONDDIRNum, COMMENTS = COMMENTS
});
}
else if (e.CommandName == "del") //删除
{
ROADWAY r = new ROADWAY()
{
RDWAYID = key
};
MyApp.Bll.RoadWay.Del(r);
//Del(key);
}
dgv_Man.EditIndex = -1;
Bind();
}
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>");
}
