protected void RadButton1_Click(object sender, EventArgs e) { string yh = "MachineFatherName='" + TextBox1.Text + "'"; string search1 = TextBox1.Text; string xxdz1 = TextBox1.Text.Trim(); Regex pattern1 = new Regex("[%--`~!@#$^&*()=|{}':;',\\[\\].<>/?~!@#¥……&*()——|{}【】‘;:”“'。,、? ’ ']");//特殊字符正则判断 if ((pattern1.IsMatch(xxdz1) == true)) { Response.Write("<script>alert('请不要输入特殊字符!')</script>"); return; } DataSet ds = MachineFatherType_bll.GetList(yh); if (TextBox1.Text == "")//判断输入框是否为空 { Response.Write("<script>alert('请输入设备父类别!')</script>"); return; } else if (MachineFatherType_bll.GetRecordCount(" MachineFatherName ='" + TextBox1.Text + "' ") != 0 && TextBox1.Text != name)//判断是否存在该父类别名称 { Response.Write("<script>.0alert('该父类别名称已存在!')</script>"); } else { //Maticsoft.Model.GoodsParentForm modelfclass1 = BLLFClass.GetModel(Request.QueryString["ID"].ToString());//引用id的所有信息 MachineFatherType_Model = MachineFatherType_bll.GetModel(Request.QueryString["ID"].ToString()); //引用id的所有信息 MachineFatherType_Model.MachineFatherName = TextBox1.Text; //添加数据 MachineFatherType_bll.Update(MachineFatherType_Model); //更新数据 RadAjaxManager1.Alert("修改成功!"); //提示 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>CloseAndRebind();</script>"); //关闭弹窗 } }
protected void Page_Load(object sender, EventArgs e) { if (UsersInfo.UserID == "") //判断是否登录 { Response.Write("<script> alert('请先登录'); window.location.href='/BackLogin.aspx' </script>"); //提示并登录 } else { if (!IsPostBack) { Maticsoft.Model.MachineFatherType MachineFatherType_Model = MachineFatherType_bll.GetModel(Request.QueryString["ID"].ToString()); //引用id的所有信息 name = TextBox1.Text = MachineFatherType_Model.MachineFatherName; //为输入框赋值 } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.MachineFatherType DataRowToModel(DataRow row) { Maticsoft.Model.MachineFatherType model = new Maticsoft.Model.MachineFatherType(); if (row != null) { if (row["MachineFatherID"] != null) { model.MachineFatherID = row["MachineFatherID"].ToString(); } if (row["MachineFatherName"] != null) { model.MachineFatherName = row["MachineFatherName"].ToString(); } if (row["MachineFatherAddTime"] != null && row["MachineFatherAddTime"].ToString() != "") { model.MachineFatherAddTime = DateTime.Parse(row["MachineFatherAddTime"].ToString()); } if (row["MachineFatherPicture"] != null) { model.MachineFatherPicture = row["MachineFatherPicture"].ToString(); } if (row["MachineFatherIntroduction"] != null) { model.MachineFatherIntroduction = row["MachineFatherIntroduction"].ToString(); } if (row["DDD1"] != null) { model.DDD1 = row["DDD1"].ToString(); } if (row["DDD2"] != null) { model.DDD2 = row["DDD2"].ToString(); } if (row["DDD3"] != null) { model.DDD3 = row["DDD3"].ToString(); } if (row["DDD4"] != null) { model.DDD4 = row["DDD4"].ToString(); } if (row["DDD5"] != null) { model.DDD5 = row["DDD5"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.MachineFatherType GetModel(string MachineFatherID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" MachineFatherID,MachineFatherName,MachineFatherAddTime,MachineFatherPicture,MachineFatherIntroduction,DDD1,DDD2,DDD3,DDD4,DDD5 "); strSql.Append(" from MachineFatherType "); strSql.Append(" where MachineFatherID='" + MachineFatherID + "' "); Maticsoft.Model.MachineFatherType model = new Maticsoft.Model.MachineFatherType(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { Maticsoft.Model.Replacement molr = bllr.GetModel(Request.QueryString["ID"].ToString());//引用id所在行的数据 if (molr == null) { Response.Write("<script>window.location.href='~/BackLogin.aspx'</script>"); } Maticsoft.Model.MachineFatherType molmf = bllmf.GetModel(molr.MachineFatherID); Maticsoft.Model.MachineSonType molms = bllms.GetModel(molr.MachineSonID); Label1.Text = molr.ReplacementID; Label2.Text = molr.ReplacementModel; Label3.Text = molr.ReplacementName; Label4.Text = molmf.MachineFatherName + "-" + molms.MachineSonName; Label5.Text = molr.ReplacementState; Label6.Text = molr.ReplacementAddTime.ToString(); string st = molr.ReplacementPicture; string[] sop = st.Split(';'); ImgList.Clear(); for (int i = 0; i < sop.Length - 1; i++) { ImgModel img = new ImgModel(); img.ID = ImgList.Count + 1; img.imgUrl = sop[i]; ImgList.Add(img); RadListView1.Rebind(); } } } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.MachineFatherType model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.MachineFatherID != null) { strSql1.Append("MachineFatherID,"); strSql2.Append("'" + model.MachineFatherID + "',"); } if (model.MachineFatherName != null) { strSql1.Append("MachineFatherName,"); strSql2.Append("'" + model.MachineFatherName + "',"); } if (model.MachineFatherAddTime != null) { strSql1.Append("MachineFatherAddTime,"); strSql2.Append("'" + model.MachineFatherAddTime + "',"); } if (model.MachineFatherPicture != null) { strSql1.Append("MachineFatherPicture,"); strSql2.Append("'" + model.MachineFatherPicture + "',"); } if (model.MachineFatherIntroduction != null) { strSql1.Append("MachineFatherIntroduction,"); strSql2.Append("'" + model.MachineFatherIntroduction + "',"); } if (model.DDD1 != null) { strSql1.Append("DDD1,"); strSql2.Append("'" + model.DDD1 + "',"); } if (model.DDD2 != null) { strSql1.Append("DDD2,"); strSql2.Append("'" + model.DDD2 + "',"); } if (model.DDD3 != null) { strSql1.Append("DDD3,"); strSql2.Append("'" + model.DDD3 + "',"); } if (model.DDD4 != null) { strSql1.Append("DDD4,"); strSql2.Append("'" + model.DDD4 + "',"); } if (model.DDD5 != null) { strSql1.Append("DDD5,"); strSql2.Append("'" + model.DDD5 + "',"); } strSql.Append("insert into MachineFatherType("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); int rows = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.MachineFatherType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MachineFatherType set "); if (model.MachineFatherName != null) { strSql.Append("MachineFatherName='" + model.MachineFatherName + "',"); } else { strSql.Append("MachineFatherName= null ,"); } if (model.MachineFatherAddTime != null) { strSql.Append("MachineFatherAddTime='" + model.MachineFatherAddTime + "',"); } else { strSql.Append("MachineFatherAddTime= null ,"); } if (model.MachineFatherPicture != null) { strSql.Append("MachineFatherPicture='" + model.MachineFatherPicture + "',"); } else { strSql.Append("MachineFatherPicture= null ,"); } if (model.MachineFatherIntroduction != null) { strSql.Append("MachineFatherIntroduction='" + model.MachineFatherIntroduction + "',"); } else { strSql.Append("MachineFatherIntroduction= null ,"); } if (model.DDD1 != null) { strSql.Append("DDD1='" + model.DDD1 + "',"); } else { strSql.Append("DDD1= null ,"); } if (model.DDD2 != null) { strSql.Append("DDD2='" + model.DDD2 + "',"); } else { strSql.Append("DDD2= null ,"); } if (model.DDD3 != null) { strSql.Append("DDD3='" + model.DDD3 + "',"); } else { strSql.Append("DDD3= null ,"); } if (model.DDD4 != null) { strSql.Append("DDD4='" + model.DDD4 + "',"); } else { strSql.Append("DDD4= null ,"); } if (model.DDD5 != null) { strSql.Append("DDD5='" + model.DDD5 + "',"); } else { strSql.Append("DDD5= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where MachineFatherID='" + model.MachineFatherID + "' "); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { Maticsoft.Model.Replacement molr = bllr.GetModel(Request.QueryString["ID"].ToString());//引用id所在行的数据 if (molr.ReplacementState == "已借出") { Response.Write("<script>alert('已借出,无法修改!');window.location.href='SubstituteMachine.aspx'</script>"); return; } if (molr.ReplacementState == "已报废") { Response.Write("<script>alert('已报废,无法修改!');window.location.href='SubstituteMachine.aspx'</script>"); return; } if (molr == null) { Response.Write("<script>window.location.href='~/BackLogin.aspx'</script>"); } MachineFather.Items.Clear(); MachineSon.Items.Clear(); MachineFather.Items.Add("请选择..."); MachineSon.Items.Add("请选择..."); MachineFather.DataSource = bllmf.GetList(""); MachineFather.DataTextField = "MachineFatherName"; MachineFather.DataValueField = "MachineFatherID"; MachineFather.DataBind(); MachineSon.DataSource = bllms.GetList(" MachineFatherID ='" + MachineFather.SelectedValue + "' "); MachineSon.DataTextField = "MachineSonName"; MachineSon.DataValueField = "MachineSonID"; MachineSon.DataBind(); Maticsoft.Model.MachineFatherType molmf = bllmf.GetModel(molr.MachineFatherID); Maticsoft.Model.MachineSonType molms = bllms.GetModel(molr.MachineSonID); ReplacementName.Text = molr.ReplacementName; ReplacementModel.Text = molr.ReplacementModel; MachineFather.SelectedValue = molmf.MachineFatherID; MachineSon.Items.Clear(); //清子类下拉框项目 MachineSon.Items.Add("请选择..."); //给市下拉框添加请选择 MachineSon.DataSource = bllms.GetList(" MachineFatherID ='" + MachineFather.SelectedValue + "' "); MachineSon.DataTextField = "MachineSonName"; MachineSon.DataValueField = "MachineSonID"; MachineSon.DataBind(); MachineSon.SelectedValue = molms.MachineSonID; //DropDownList1.SelectedValue = molr.ReplacementState; string st = molr.ReplacementPicture; string[] sop = st.Split(';'); ImgList.Clear(); for (int i = 0; i < sop.Length - 1; i++) //修改图片显示 { ImgModel img = new ImgModel(); img.ID = ImgList.Count + 1; img.imgUrl = sop[i]; ImgList.Add(img); RadListView1.Rebind(); } //imgPic.ImageUrl = molr.ReplacementPicture; } } }