Пример #1
0
 /// <summary>
 /// 新增一条数据字典记录
 /// </summary>
 /// <param name="dictronary">System.String[]<param>
 /// <returns>返回数据字典受影响的行数</returns>
 public virtual int Add(Dictronary dictronary)
 {
     return db.ExecuteNoQuery("INSERT INTO T_BASE_DICTRONARY (DICT_TYPE, DICT_CODE, DICT_NAME, DICT_VALUE, DICT_DESC) VALUES (@DICT_TYPE, @DICT_CODE, @DICT_NAME, @DICT_VALUE, @DICT_DESC)",
         db.GetDataParameter("@DICT_TYPE", dictronary.DictType),
         db.GetDataParameter("@DICT_CODE", dictronary.DictCode),
         db.GetDataParameter("@DICT_NAME", dictronary.DictName),
         db.GetDataParameter("@DICT_VALUE", dictronary.DictValue),
         db.GetDataParameter("@DICT_DESC", dictronary.DictDesc));
 }
Пример #2
0
        /// <summary>
        /// 根据 DictCode 更新数据字典表记录
        /// </summary>
        /// <returns>返回数据字典受影响的行数</returns>
        public virtual int Update(Dictronary dictronary,string oldCode)
        {
            return db.ExecuteNoQuery("UPDATE T_BASE_DICTRONARY SET DICT_CODE = @DICT_CODE, DICT_NAME = @DICT_NAME, DICT_VALUE = @DICT_VALUE, DICT_DESC = @DICT_DESC WHERE DICT_CODE = @oldCode",

                //db.GetDataParameter("@DICT_CODE", oldCode),
                db.GetDataParameter("@DICT_CODE", dictronary.DictCode),
                db.GetDataParameter("@DICT_NAME", dictronary.DictName),
                db.GetDataParameter("@DICT_VALUE", dictronary.DictValue),
                db.GetDataParameter("@DICT_DESC", dictronary.DictDesc),
                db.GetDataParameter("@oldCode", oldCode)
                );
        }
Пример #3
0
        protected void btnAddSub_Click(object sender, EventArgs e)
        {
            Dictronary subupdating = new Dictronary();
            subupdating.DictCode = txtDictCode.Text;
            subupdating.DictType = Request.QueryString["val"];
            subupdating.DictName = txtDictName.Text;
            subupdating.DictDesc = txtDictDesc.Text;
            ObservableCollection<Dictronary> List = new DictronaryDAL().QueryByType(Request["val"]);
            foreach (Dictronary obj in List)
            {
                if (obj.DictCode == subupdating.DictCode)
                {
                    Alert("您已提交过该编号了!");
                    return;
                }
            }

            new DictronaryDAL().Add(subupdating);
            txtDictCode.Text = "";
            txtDictName.Text = "";
            txtDictDesc.Text = "";
            InitPage();
        }
Пример #4
0
        protected void gridSubName_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            string strCode=((TextBox)gridSubName.Rows[e.RowIndex].FindControl("txtDictCode")).Text.Trim();
            if (strCode.Length > 0)
            {
                try
                {
                    if (!CheckString(strCode))
                    {
                        Alert("请勿输入特殊字符!");
                        return;
                    }
                    string oldSub = ((TextBox)gridSubName.Rows[e.RowIndex].FindControl("txtOldSubName")).Text;
                    if (Request["val"].ToString() != "")
                    {
                        ObservableCollection<Dictronary> List = new DictronaryDAL().SelectSubWithoutSelf(Request["val"], oldSub);
                        foreach (Dictronary obj in List)
                        {
                            if (obj.DictCode == strCode)
                            {
                                Alert("您已提交过该名称了!");
                                return;
                            }
                        }
                    }
                    Dictronary subupdating = new Dictronary();

                    subupdating.DictCode = strCode;
                    subupdating.DictType = Request.QueryString["val"];
                    subupdating.DictName = ((TextBox)gridSubName.Rows[e.RowIndex].FindControl("txtDictName")).Text;
                    subupdating.DictDesc = ((TextBox)gridSubName.Rows[e.RowIndex].FindControl("txtDictDesc")).Text;

                    new DictronaryDAL().Update(subupdating,oldSub);

                    gridSubName.EditIndex = -1;
                    InitPage();
                }
                catch (Exception ex)
                {
                    Alert(ex);
                }
            }
            else
            {
                Alert("子类名称不能为空!"); return;
            }
        }