Exemple #1
0
        public bool Save(tbOtherConfig OtherConfig)
        {
            bool IsOk = false;

            IDbDataParameter[] parm = GetUpdateParam();
            parm[0].Value = OtherConfig.UserId;
            parm[1].Value = OtherConfig.Invoice;
            parm[2].Value = OtherConfig.AutoHeight;

            try {
                IsOk = DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_UPDATE, parm) > 0;
            }
            catch { }

            return(IsOk);
        }
Exemple #2
0
        private const string PARM_AUTO = "@AutoHeight";                                                         //是否自动计算发货单高度

        public tbOtherConfig Select(int UserId)
        {
            tbOtherConfig config = null;

            IDbDataParameter[] parm = GetSelectParam();
            parm[0].Value = UserId;

            using (IDataReader MyReader = DBHelper.ExecuteReader(CommandType.StoredProcedure, SQL_SELECT, parm)) {
                if (MyReader.Read())
                {
                    config = new tbOtherConfig()
                    {
                        UserId     = MyReader.GetInt32(0),
                        Invoice    = MyReader.GetBoolean(1),
                        AutoHeight = MyReader.GetBoolean(2)
                    };
                }
            }

            return(config == null ? new tbOtherConfig() : config);
        }
Exemple #3
0
 /// <summary>
 /// 保存系统其他设置信息
 /// </summary>
 /// <param name="OtherConfig">系统其他设置信息</param>
 /// <returns></returns>
 public static bool Save(tbOtherConfig OtherConfig)
 {
     return(OtherConfigDal.Save(OtherConfig));
 }