예제 #1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Maticsoft.Model.FuWuTypeInfo model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update FuWuTypeInfo set ");
            strSql.Append("FuwuTypeName=@FuwuTypeName");
            strSql.Append(" where FuwuTypeID=@FuwuTypeID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@FuwuTypeID",   SqlDbType.Int,     4),
                new SqlParameter("@FuwuTypeName", SqlDbType.VarChar, 200)
            };
            parameters[0].Value = model.FuwuTypeID;
            parameters[1].Value = model.FuwuTypeName;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #2
0
 private void ShowInfo(int FuwuTypeID)
 {
     Maticsoft.BLL.FuWuTypeInfo   bll   = new Maticsoft.BLL.FuWuTypeInfo();
     Maticsoft.Model.FuWuTypeInfo model = bll.GetModel(FuwuTypeID);
     this.lblFuwuTypeID.Text   = model.FuwuTypeID.ToString();
     this.lblFuwuTypeName.Text = model.FuwuTypeName;
 }
예제 #3
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            string strErr = "";

            if (this.txtFuwuTypeName.Text.Trim().Length == 0)
            {
                strErr += "FuwuTypeName不能为空!\\n";
            }

            if (strErr != "")
            {
                MessageBox.Show(this, strErr);
                return;
            }
            int    FuwuTypeID   = int.Parse(this.lblFuwuTypeID.Text);
            string FuwuTypeName = this.txtFuwuTypeName.Text;


            Maticsoft.Model.FuWuTypeInfo model = new Maticsoft.Model.FuWuTypeInfo();
            model.FuwuTypeID   = FuwuTypeID;
            model.FuwuTypeName = FuwuTypeName;

            Maticsoft.BLL.FuWuTypeInfo bll = new Maticsoft.BLL.FuWuTypeInfo();
            bll.Update(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx");
        }
예제 #4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.FuWuTypeInfo model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into FuWuTypeInfo(");
            strSql.Append("FuwuTypeName)");
            strSql.Append(" values (");
            strSql.Append("@FuwuTypeName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@FuwuTypeName", SqlDbType.VarChar, 200)
            };
            parameters[0].Value = model.FuwuTypeName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
예제 #5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Maticsoft.Model.FuWuTypeInfo GetModel(int FuwuTypeID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 FuwuTypeID,FuwuTypeName from FuWuTypeInfo ");
            strSql.Append(" where FuwuTypeID=@FuwuTypeID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@FuwuTypeID", SqlDbType.Int, 4)
            };
            parameters[0].Value = FuwuTypeID;

            Maticsoft.Model.FuWuTypeInfo model = new Maticsoft.Model.FuWuTypeInfo();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["FuwuTypeID"].ToString() != "")
                {
                    model.FuwuTypeID = int.Parse(ds.Tables[0].Rows[0]["FuwuTypeID"].ToString());
                }
                model.FuwuTypeName = ds.Tables[0].Rows[0]["FuwuTypeName"].ToString();
                return(model);
            }
            else
            {
                return(null);
            }
        }
예제 #6
0
        protected void datading_ItemDataBound(object sender, DataListItemEventArgs e)
        {
            int index = int.Parse(datafuwu.DataKeys[e.Item.ItemIndex].ToString());

            Maticsoft.BLL.FuWuInfo       fuwubll   = new Maticsoft.BLL.FuWuInfo();
            Maticsoft.Model.FuWuInfo     fuwumodel = fuwubll.GetModel(index);
            Maticsoft.BLL.FuWuTypeInfo   typebll   = new Maticsoft.BLL.FuWuTypeInfo();
            Maticsoft.Model.FuWuTypeInfo typemodel = typebll.GetModel(int.Parse(fuwumodel.FuwuTypeID.ToString()));
            ((Label)e.Item.FindControl("lnltype")).Text = typemodel.FuwuTypeName;
        }
예제 #7
0
 private void bind(int fuwuID)
 {
     Maticsoft.BLL.FuWuInfo       fuwubll   = new Maticsoft.BLL.FuWuInfo();
     Maticsoft.Model.FuWuInfo     fuwumodel = fuwubll.GetModel(fuwuID);
     Maticsoft.BLL.FuWuTypeInfo   typebll   = new Maticsoft.BLL.FuWuTypeInfo();
     Maticsoft.Model.FuWuTypeInfo typemodel = typebll.GetModel(int.Parse(fuwumodel.FuwuTypeID.ToString()));
     lblFatime.Text       = Convert.ToDateTime(fuwumodel.Fatime.ToString()).ToString("yyyy-MM-dd");
     lblFuwucontent.Text  = fuwumodel.Fuwucontent;
     lblWrite.Text        = fuwumodel.Write;
     lblFuwuTypeName.Text = typemodel.FuwuTypeName;
     lbltitle.Text        = fuwumodel.fuwuTitle;
 }
예제 #8
0
 protected void btntype_Click(object sender, EventArgs e)
 {
     if (txtaddtype.Text.Trim() == "")
     {
         lbladdtype.Text = "请填写服务类型";
         return;
     }
     Maticsoft.BLL.FuWuTypeInfo   typebll   = new Maticsoft.BLL.FuWuTypeInfo();
     Maticsoft.Model.FuWuTypeInfo typemodel = new Maticsoft.Model.FuWuTypeInfo();
     typemodel.FuwuTypeName = txtaddtype.Text.Trim();
     typebll.Add(typemodel);
     Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<SCRIPT>alert('信息提交成功)</SCRIPT>");
 }
예제 #9
0
 protected void btnfuwu_Click(object sender, EventArgs e)
 {
     Maticsoft.BLL.FuWuTypeInfo   bll   = new Maticsoft.BLL.FuWuTypeInfo();
     Maticsoft.Model.FuWuTypeInfo model = new Maticsoft.Model.FuWuTypeInfo();
     if (TextBox1.Text.Trim() == "")
     {
         Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请将填写完整!')</script>");
         return;
     }
     model.FuwuTypeName = TextBox1.Text.Trim();
     bll.Add(model);
     Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('信息添加成功!')</script>");
     TextBox1.Text = string.Empty;
 }
예제 #10
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            string strErr = "";

            if (this.txtFuwuTypeName.Text.Trim().Length == 0)
            {
                strErr += "FuwuTypeName不能为空!\\n";
            }

            if (strErr != "")
            {
                MessageBox.Show(this, strErr);
                return;
            }
            string FuwuTypeName = this.txtFuwuTypeName.Text;

            Maticsoft.Model.FuWuTypeInfo model = new Maticsoft.Model.FuWuTypeInfo();
            model.FuwuTypeName = FuwuTypeName;

            Maticsoft.BLL.FuWuTypeInfo bll = new Maticsoft.BLL.FuWuTypeInfo();
            bll.Add(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx");
        }