Exemple #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)));
 }
Exemple #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)
                                     ));
        }
Exemple #3
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;
            }
        }