예제 #1
0
        /// <summary>
        /// 修改计量单位
        /// </summary>
        /// <param name="units"></param>
        /// <returns></returns>
        public bool UpdateUnits(UnitsItems units)
        {
            string sql = "Update table_units  set  UnitName=@UnitName,IsEnable=@IsEnable where ObjectID=@ObjectID";

            SQLiteParameter[] sqlparamter = new SQLiteParameter[]
            {
                new SQLiteParameter("@ObjectID", units.ObjectID),
                new SQLiteParameter("@UnitName", units.UnitsName),
                new SQLiteParameter("@IsEnable", units.IsEnable),
            };

            return(SqlHelper.ExecuteNonQuery(sql, sqlparamter) == 1);
        }
예제 #2
0
        /// <summary>
        /// 新增计量单位
        /// </summary>
        /// <param name="units"></param>
        /// <returns></returns>
        public bool InsertUnits(UnitsItems units)
        {
            string sql = "INSERT into table_units (ObjectID,UnitName,IsEnable,IsDelete) VALUES(@ObjectID,@UnitName,@IsEnable,@IsDelete)";

            SQLiteParameter[] sqlparamter = new SQLiteParameter[]
            {
                new SQLiteParameter("@ObjectID", units.ObjectID),
                new SQLiteParameter("@UnitName", units.UnitsName),
                new SQLiteParameter("@IsEnable", units.IsEnable),
                new SQLiteParameter("@IsDelete", "N")
            };

            return(SqlHelper.ExecuteNonQuery(sql, sqlparamter) == 1);
        }
예제 #3
0
        private void Btn_Save_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrEmpty(Txt_UnitName.Text))
            {
                MessageBox.Show("请输入计量单位名称");
                return;
            }
            try
            {
                var item = new UnitsItems()
                {
                    ObjectID  = Txt_UnitID.Text,
                    UnitsName = Txt_UnitName.Text,
                    IsEnable  = Rbtn_Yes.Checked ? "Y" : "N"
                };

                var result = IsEdit ? new UnitsQuery().UpdateUnits(item) : new UnitsQuery().InsertUnits(item);

                if (result)
                {
                    MessageBox.Show("保存成功");

                    if (IsEdit)
                    {
                        this.Close();
                    }
                    else
                    {
                        var unitId = Guid.NewGuid().ToString();

                        while (new UnitsQuery().GetUnit(unitId) != null)
                        {
                            unitId = Guid.NewGuid().ToString();
                        }

                        Txt_UnitID.Text   = unitId;
                        Txt_UnitName.Text = String.Empty;
                    }
                }
            }
            catch (Exception exp)
            {
                MessageBox.Show("保存失败," + exp.Message);
            }
        }