コード例 #1
0
ファイル: DAL_HelpCenter.cs プロジェクト: a157591984/jiguang
        public Model_HelpCenter DataRowToModel(DataRow row)
        {
            Model_HelpCenter center = new Model_HelpCenter();

            if (row != null)
            {
                if (row["help_id"] != null)
                {
                    center.help_id = row["help_id"].ToString();
                }
                if (row["help_title"] != null)
                {
                    center.help_title = row["help_title"].ToString();
                }
                if (row["help_content"] != null)
                {
                    center.help_content = row["help_content"].ToString();
                }
                if ((row["create_time"] != null) && (row["create_time"].ToString() != ""))
                {
                    center.create_time = new DateTime?(DateTime.Parse(row["create_time"].ToString()));
                }
                if (row["create_userid"] != null)
                {
                    center.create_userid = row["create_userid"].ToString();
                }
            }
            return(center);
        }
コード例 #2
0
ファイル: DAL_HelpCenter.cs プロジェクト: a157591984/jiguang
        public bool Add(Model_HelpCenter model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("insert into HelpCenter(");
            builder.Append("help_id,help_title,help_content,create_time,create_userid)");
            builder.Append(" values (");
            builder.Append("@help_id,@help_title,@help_content,@create_time,@create_userid)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@help_id", SqlDbType.NChar, 0x24), new SqlParameter("@help_title", SqlDbType.NVarChar, 200), new SqlParameter("@help_content", SqlDbType.Text), new SqlParameter("@create_time", SqlDbType.DateTime), new SqlParameter("@create_userid", SqlDbType.NChar, 0x24) };
            cmdParms[0].Value = model.help_id;
            cmdParms[1].Value = model.help_title;
            cmdParms[2].Value = model.help_content;
            cmdParms[3].Value = model.create_time;
            cmdParms[4].Value = model.create_userid;
            return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
コード例 #3
0
ファイル: FAQEdit.aspx.cs プロジェクト: a157591984/jiguang
 protected void btnSave_Click(object sender, EventArgs e)
 {
     try
     {
         if (!string.IsNullOrEmpty(help_id))
         {
             BLL_HelpCenter   bll   = new BLL_HelpCenter();
             Model_HelpCenter model = new Model_HelpCenter();
             model              = bll.GetModel(help_id);
             model.help_title   = this.txt_title.Text.TrimEnd();
             model.help_content = this.txt_content.Value;
             model.create_time  = DateTime.Now;
             if (bll.Update(model))
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>$(function(){layer.ready(function(){layer.msg('修改成功', { time: 2000, icon: 1},function(){parent.loadData();parent.layer.close(index)})})})</script>");
             }
             else
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>$(function(){layer.ready(function(){layer.msg('修改失败', { time: 2000, icon: 2})})})</script>");
                 return;
             }
         }
         else
         {
             BLL_HelpCenter   bll   = new BLL_HelpCenter();
             Model_HelpCenter model = new Model_HelpCenter();
             model.help_title    = this.txt_title.Text.TrimEnd();
             model.help_content  = this.txt_content.Value;
             model.help_id       = Guid.NewGuid().ToString();
             model.create_time   = DateTime.Now;
             model.create_userid = loginUser.SysUser_ID;
             if (bll.Add(model))
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>$(function(){layer.ready(function(){layer.msg('添加成功', { time: 2000, icon: 1},function(){parent.loadData();parent.layer.close(index)})})})</script>");
             }
             else
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>$(function(){layer.ready(function(){layer.msg('添加失败', { time: 2000, icon: 2})})})</script>");
                 return;
             }
         }
     }
     catch (Exception ex)
     {
         throw;
     }
 }
コード例 #4
0
ファイル: DAL_HelpCenter.cs プロジェクト: a157591984/jiguang
        public bool Update(Model_HelpCenter model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("update HelpCenter set ");
            builder.Append("help_title=@help_title,");
            builder.Append("help_content=@help_content,");
            builder.Append("create_time=@create_time,");
            builder.Append("create_userid=@create_userid");
            builder.Append(" where help_id=@help_id ");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@help_title", SqlDbType.NVarChar, 200), new SqlParameter("@help_content", SqlDbType.Text), new SqlParameter("@create_time", SqlDbType.DateTime), new SqlParameter("@create_userid", SqlDbType.NChar, 0x24), new SqlParameter("@help_id", SqlDbType.NChar, 0x24) };
            cmdParms[0].Value = model.help_title;
            cmdParms[1].Value = model.help_content;
            cmdParms[2].Value = model.create_time;
            cmdParms[3].Value = model.create_userid;
            cmdParms[4].Value = model.help_id;
            return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
コード例 #5
0
ファイル: FAQEdit.aspx.cs プロジェクト: a157591984/jiguang
 private void LoadData()
 {
     try
     {
         BLL_HelpCenter   bll   = new BLL_HelpCenter();
         Model_HelpCenter model = new Model_HelpCenter();
         model = bll.GetModel(help_id);
         if (model != null)
         {
             this.txt_title.Text    = model.help_title;
             this.txt_content.Value = model.help_content;
         }
     }
     catch (Exception ex)
     {
         throw;
     }
 }
コード例 #6
0
        public List <Model_HelpCenter> DataTableToList(DataTable dt)
        {
            List <Model_HelpCenter> list = new List <Model_HelpCenter>();
            int count = dt.Rows.Count;

            if (count > 0)
            {
                for (int i = 0; i < count; i++)
                {
                    Model_HelpCenter item = this.dal.DataRowToModel(dt.Rows[i]);
                    if (item != null)
                    {
                        list.Add(item);
                    }
                }
            }
            return(list);
        }
コード例 #7
0
ファイル: FAQShow.aspx.cs プロジェクト: a157591984/jiguang
 protected void LoadData()
 {
     try
     {
         BLL_HelpCenter   bll   = new BLL_HelpCenter();
         Model_HelpCenter model = new Model_HelpCenter();
         model = bll.GetModel(help_id);
         if (model != null)
         {
             this.ltl_content.Text = model.help_content;
             this.ltl_title.Text   = model.help_title;
             this.ltl_titles.Text  = model.help_title;
             ltlHtltel.Text        = model.help_title;
         }
     }
     catch (Exception)
     {
     }
 }
コード例 #8
0
 public bool Add(Model_HelpCenter model)
 {
     return(this.dal.Add(model));
 }
コード例 #9
0
 public bool Update(Model_HelpCenter model)
 {
     return(this.dal.Update(model));
 }