protected void btnadd_Click(object sender, EventArgs e) { string name = "^[a-zA-Z0-9\u4e00-\u9fa5-]{1,}$";//字母数字汉字- Regex rxname = new Regex(name); modelPartType = bllPartType.GetModel(Request.QueryString["ID"].ToString()); if (PartTypeName.Text.Trim() == "") { RadAjaxManager1.Alert("配件类别名称不能为空!"); return; } if (!rxname.IsMatch(PartTypeName.Text.Trim()) && PartTypeName.Text.Trim() != "") { RadAjaxManager1.Alert("类别名称不能输入特殊字符!"); return; } if (bllPartType.GetList(" PartTypeName='" + PartTypeName.Text + "' ").Tables[0].Rows.Count != 0 && PartTypeName.Text.Trim() != modelPartType.PartTypeName) { RadAjaxManager1.Alert("该类别名称已存在!"); return; } modelPartType.PartTypeName = PartTypeName.Text; bllPartType.Update(modelPartType); RadAjaxManager1.Alert("修改成功!"); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>CloseAndRebind();</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (UsersInfo.UserID == "" || UsersInfo.UserRole != "维修中心管理员") { UsersInfo.UserID = ""; UsersInfo.UserName = ""; UsersInfo.UserRole = ""; Response.Redirect("~/BackLogin.aspx"); return; } btnback.Attributes["onclick"] = "GetClose();return false;"; if (!IsPostBack) { if (Request.QueryString["ID"] == null) { RadAjaxManager1.Alert("请选择一条数据!"); Response.Write("<script>window.location.href='PartsType.aspx'</script>"); return; } modelparttype = bllPartType.GetModel(Request.QueryString["ID"].ToString()); if (modelparttype == null) { RadAjaxManager1.Alert("请选择一条数据!"); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>CloseAndRebind();</script>"); return; } PartTypeName.Text = modelparttype.PartTypeName; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.PartType DataRowToModel(DataRow row) { Maticsoft.Model.PartType model = new Maticsoft.Model.PartType(); if (row != null) { if (row["PartTypeID"] != null) { model.PartTypeID = row["PartTypeID"].ToString(); } if (row["PartTypeName"] != null) { model.PartTypeName = row["PartTypeName"].ToString(); } if (row["PartTypeAddTime"] != null && row["PartTypeAddTime"].ToString() != "") { model.PartTypeAddTime = DateTime.Parse(row["PartTypeAddTime"].ToString()); } if (row["PartTypePicture"] != null) { model.PartTypePicture = row["PartTypePicture"].ToString(); } if (row["PartTypeIntroduction"] != null) { model.PartTypeIntroduction = row["PartTypeIntroduction"].ToString(); } if (row["HHH1"] != null) { model.HHH1 = row["HHH1"].ToString(); } if (row["HHH2"] != null) { model.HHH2 = row["HHH2"].ToString(); } if (row["HHH3"] != null) { model.HHH3 = row["HHH3"].ToString(); } if (row["HHH4"] != null) { model.HHH4 = row["HHH4"].ToString(); } if (row["HHH5"] != null) { model.HHH5 = row["HHH5"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.PartType GetModel(string PartTypeID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" PartTypeID,PartTypeName,PartTypeAddTime,PartTypePicture,PartTypeIntroduction,HHH1,HHH2,HHH3,HHH4,HHH5 "); strSql.Append(" from PartType "); strSql.Append(" where PartTypeID='" + PartTypeID + "' "); Maticsoft.Model.PartType model = new Maticsoft.Model.PartType(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.PartType model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.PartTypeID != null) { strSql1.Append("PartTypeID,"); strSql2.Append("'" + model.PartTypeID + "',"); } if (model.PartTypeName != null) { strSql1.Append("PartTypeName,"); strSql2.Append("'" + model.PartTypeName + "',"); } if (model.PartTypeAddTime != null) { strSql1.Append("PartTypeAddTime,"); strSql2.Append("'" + model.PartTypeAddTime + "',"); } if (model.PartTypePicture != null) { strSql1.Append("PartTypePicture,"); strSql2.Append("'" + model.PartTypePicture + "',"); } if (model.PartTypeIntroduction != null) { strSql1.Append("PartTypeIntroduction,"); strSql2.Append("'" + model.PartTypeIntroduction + "',"); } if (model.HHH1 != null) { strSql1.Append("HHH1,"); strSql2.Append("'" + model.HHH1 + "',"); } if (model.HHH2 != null) { strSql1.Append("HHH2,"); strSql2.Append("'" + model.HHH2 + "',"); } if (model.HHH3 != null) { strSql1.Append("HHH3,"); strSql2.Append("'" + model.HHH3 + "',"); } if (model.HHH4 != null) { strSql1.Append("HHH4,"); strSql2.Append("'" + model.HHH4 + "',"); } if (model.HHH5 != null) { strSql1.Append("HHH5,"); strSql2.Append("'" + model.HHH5 + "',"); } strSql.Append("insert into PartType("); 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.PartType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PartType set "); if (model.PartTypeName != null) { strSql.Append("PartTypeName='" + model.PartTypeName + "',"); } else { strSql.Append("PartTypeName= null ,"); } if (model.PartTypeAddTime != null) { strSql.Append("PartTypeAddTime='" + model.PartTypeAddTime + "',"); } else { strSql.Append("PartTypeAddTime= null ,"); } if (model.PartTypePicture != null) { strSql.Append("PartTypePicture='" + model.PartTypePicture + "',"); } else { strSql.Append("PartTypePicture= null ,"); } if (model.PartTypeIntroduction != null) { strSql.Append("PartTypeIntroduction='" + model.PartTypeIntroduction + "',"); } else { strSql.Append("PartTypeIntroduction= null ,"); } if (model.HHH1 != null) { strSql.Append("HHH1='" + model.HHH1 + "',"); } else { strSql.Append("HHH1= null ,"); } if (model.HHH2 != null) { strSql.Append("HHH2='" + model.HHH2 + "',"); } else { strSql.Append("HHH2= null ,"); } if (model.HHH3 != null) { strSql.Append("HHH3='" + model.HHH3 + "',"); } else { strSql.Append("HHH3= null ,"); } if (model.HHH4 != null) { strSql.Append("HHH4='" + model.HHH4 + "',"); } else { strSql.Append("HHH4= null ,"); } if (model.HHH5 != null) { strSql.Append("HHH5='" + model.HHH5 + "',"); } else { strSql.Append("HHH5= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where PartTypeID='" + model.PartTypeID + "' "); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }