コード例 #1
0
        /// <summary>
        /// 更新一条记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static bool Update(AusMoney model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update DepartMoney set ");
            strSql.Append(" username=@username,amount=@amount");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@username", SqlDbType.VarChar, 20),
                new SqlParameter("@amount",   SqlDbType.Money,    8),
                new SqlParameter("@id",       SqlDbType.Int, 4)
            };
            parameters[0].Value = model.username;
            parameters[1].Value = model.amount;
            parameters[2].Value = model.id;

            int result = DBHelper.ExecuteCommand(strSql.ToString(), parameters);

            if (result >= 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
コード例 #2
0
        /// <summary>
        /// 根据项目名称,年份和人员得到实体
        /// </summary>
        /// <param name="itemname">项目名称</param>
        /// <param name="username">人员</param>
        /// <returns></returns>
        public static AusMoney GetModelbyname(string itemname, string username, int years)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select * from DepartMoney");
            strSql.Append(" where itemname=@itemname");
            strSql.Append(" and username=@username");
            strSql.Append(" and years=@years");
            SqlParameter[] parameters =
            {
                new SqlParameter("@itemname", SqlDbType.VarChar, 20),
                new SqlParameter("@username", SqlDbType.VarChar, 20),
                new SqlParameter("@years",    SqlDbType.Int, 4)
            };
            parameters[0].Value = itemname;
            parameters[1].Value = username;
            parameters[2].Value = years;

            AusMoney  model = new AusMoney();
            DataTable dt    = DBHelper.GetDataSet(strSql.ToString(), parameters);

            if (dt.Rows.Count > 0)
            {
                model.id       = Convert.ToInt32(dt.Rows[0]["ID"]);
                model.itemname = Convert.ToString(dt.Rows[0]["itemname"]);
                model.username = Convert.ToString(dt.Rows[0]["username"]);
                model.amount   = Convert.IsDBNull(dt.Rows[0]["amount"]) ? 0.0 : Convert.ToDouble(dt.Rows[0]["amount"]);
                model.haspay   = Convert.IsDBNull(dt.Rows[0]["haspay"]) ? 0.0 : Convert.ToDouble(dt.Rows[0]["haspay"]);
                model.year     = Convert.ToInt32(dt.Rows[0]["years"]);
            }
            return(model);
        }
コード例 #3
0
        /// <summary>
        /// 增加一条记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static bool Add(AusMoney model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into DepartMoney(");
            strSql.Append("itemname,username,amount,years)");
            strSql.Append(" values (");
            strSql.Append("@itemname,@username,@amount,@years)");

            SqlParameter[] parameters =
            {
                new SqlParameter("@itemname", SqlDbType.VarChar, 20),
                new SqlParameter("@username", SqlDbType.VarChar, 20),
                new SqlParameter("@amount",   SqlDbType.Money,    8),
                new SqlParameter("@years",    SqlDbType.Int, 4)
            };
            parameters[0].Value = model.itemname;
            parameters[1].Value = model.username;
            parameters[2].Value = model.amount;
            parameters[3].Value = model.year;
            int result = DBHelper.ExecuteCommand(strSql.ToString(), parameters);

            if (result >= 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
コード例 #4
0
        /// <summary>
        /// 得到一个对象的实体
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static AusMoney GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select * from DepartMoney ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@id", SqlDbType.Int, 4)
            };
            parameters[0].Value = id;
            AusMoney model = new AusMoney();

            DataTable ds = DBHelper.GetDataSet(strSql.ToString(), parameters);

            if (ds.Rows.Count > 0)
            {
                model.id       = Convert.ToInt32(ds.Rows[0]["ID"]);
                model.itemname = Convert.ToString(ds.Rows[0]["itemname"]);
                model.username = Convert.ToString(ds.Rows[0]["username"]);
                model.amount   = Convert.IsDBNull(ds.Rows[0]["amount"]) ? 0.0 : Convert.ToDouble(ds.Rows[0]["amount"]);
                model.haspay   = Convert.IsDBNull(ds.Rows[0]["haspay"]) ? 0.0 : Convert.ToDouble(ds.Rows[0]["haspay"]);
                model.year     = Convert.ToInt32(ds.Rows[0]["years"]);
            }
            return(model);
        }
コード例 #5
0
        /// <summary>
        /// 加载当前数据
        /// </summary>
        private void LoadNowMoney()
        {
            int    id       = Convert.ToInt32(Request.QueryString["id"]);
            string itemname = Request.QueryString["itemname"];

            AusMoney ausmoney = AusMoneyManager.GetModel(id);

            this.person.SelectedValue = ausmoney.username;
            this.txtmoney.Text        = ausmoney.amount.ToString();
            this.person.Enabled       = false;
        }
コード例 #6
0
        /// <summary>
        /// 更新数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void ibtnUpdate_Click(object sender, ImageClickEventArgs e)
        {
            int    id       = Convert.ToInt32(Request.QueryString["id"]);
            string itemname = Request.QueryString["itemname"];

            AusMoney ausmoney = AusMoneyManager.GetModel(id);
            double   haspay   = ausmoney.haspay;

            if (Convert.ToDouble(this.txtmoney.Text.Trim()) < haspay)
            {
                Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "error", "<script>alert('更新失败,该人员在该项目下的总预算不能小于已支付的预算')</script>", false);
            }
            if (this.txtmoney.Text != "")
            {
                //bool has = AusMoneyManager.Exists(itemname, this.person.SelectedValue);
                //if (has)
                //{
                //    Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "error", "<script>alert('更新失败,该人员在该项目下已存在预算')</script>", false);
                //}
                //else
                //{
                //ausmoney.username = this.person.SelectedValue;
                ausmoney.amount = Convert.ToDouble(this.txtmoney.Text.Trim());
                bool count = AusMoneyManager.Update(ausmoney);
                if (count)
                {
                    Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "success", "<script>alert('更新成功');window.location='DepartMoneyList.aspx?itemname=" + itemname + "';</script>", false);
                }
                else
                {
                    Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('更新失败')</script>", false);
                }
                //}
            }
            else
            {
                Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "alert('请检查人员和金额是否已经填写');", true);
            }
        }
コード例 #7
0
        /// <summary>
        /// 更新以支付的金额
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static bool UpdateMoney(AusMoney model)
        {
            string str = "update DepartMoney set haspay=@haspay where id=@id";

            SqlParameter[] parameters =
            {
                new SqlParameter("@haspay", SqlDbType.Money, 8),
                new SqlParameter("@id",     SqlDbType.Int, 4)
            };
            parameters[0].Value = model.haspay;
            parameters[1].Value = model.id;

            int result = DBHelper.ExecuteCommand(str, parameters);

            if (result >= 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
コード例 #8
0
        /// <summary>
        /// 添加数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void ibtnAdd_Click(object sender, ImageClickEventArgs e)
        {
            string itemname = Request.QueryString["itemname"];
            string username = this.person.SelectedValue;
            int    year     = DateTime.Now.Year;

            if (this.person.SelectedIndex != 0 && this.txtmoney.Text != "")
            {
                if (AusMoneyManager.Exists(itemname, username, year))
                {
                    Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "error", "<script>alert('添加失败,该人员在该项目下已存在预算')</script>", false);
                }
                else
                {
                    AusMoney ausmoney = new AusMoney();
                    ausmoney.itemname = itemname;
                    ausmoney.username = username;
                    ausmoney.amount   = double.Parse(this.txtmoney.Text.Trim());
                    ausmoney.year     = year;

                    bool count = AusMoneyManager.Add(ausmoney);
                    if (count)
                    {
                        Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "success", "<script>alert('添加成功');window.location='DepartMoneyList.aspx?itemname=" + itemname + "';</script>", false);
                    }
                    else
                    {
                        Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('添加失败')</script>", false);
                    }
                }
            }
            else
            {
                Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "alert('请检查人员和金额是否已经填写');", true);
            }
        }
コード例 #9
0
 /// <summary>
 /// 更新已支付金额
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public static bool UpdateMoney(AusMoney model)
 {
     return(AusMoneyService.UpdateMoney(model));
 }
コード例 #10
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public static bool Add(AusMoney model)
 {
     return(AusMoneyService.Add(model));
 }