protected void Update_Click(object sender, EventArgs e) { tbGroupNewInfo obj = new tbGroupNewInfo(); obj.Name = txtName.Text; obj.Tag = txtTag.Text; obj.Level = txtLevel.Text; obj.Title = txtTitle.Text; obj.Description = txtDesciption.Text; obj.Keyword = txtKeyword.Text; obj.Ord = int.Parse(txtOrd.Text); obj.Priority = int.Parse(txtPriority.Text); obj.Index = int.Parse(txtIndex.Text); obj.Active = chkActive.Checked; obj.Lang = txtLang.Text; if (insert) { GroupNewsController.Insert(obj); pnView.Visible = true; pnUpdate.Visible = false; } else { obj.Id = Id; GroupNewsController.Update(obj); pnView.Visible = true; pnUpdate.Visible = false; } _loadGroup(); }
public static void Update(tbGroupNewInfo tbGroupNew) { string q = "update [tbGroupNews] set [Name] = @Name,[Tag] = @Tag,[Level] = @Level,[Title] = @Title,"; q = q + "[Description] = @Description,[Keyword] = @Keyword,[Ord] = @Ord,[Priority] = @Priority,"; q = q + "[Index] = @Index,[Active] = @Active,[Lang] = @Lang where [Id] = @Id "; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; cmd.Connection = GetConnection(); cmd.Parameters.Add(new SqlParameter("@Name", tbGroupNew.Name)); cmd.Parameters.Add(new SqlParameter("@Tag", tbGroupNew.Tag)); cmd.Parameters.Add(new SqlParameter("@Level", tbGroupNew.Level)); cmd.Parameters.Add(new SqlParameter("@Title", tbGroupNew.Title)); cmd.Parameters.Add(new SqlParameter("@Description", tbGroupNew.Description)); cmd.Parameters.Add(new SqlParameter("@Keyword", tbGroupNew.Keyword)); cmd.Parameters.Add(new SqlParameter("@Ord", tbGroupNew.Ord)); cmd.Parameters.Add(new SqlParameter("@Priority", tbGroupNew.Priority)); cmd.Parameters.Add(new SqlParameter("@Index", tbGroupNew.Index)); cmd.Parameters.Add(new SqlParameter("@Active", tbGroupNew.Active)); cmd.Parameters.Add(new SqlParameter("@Lang", tbGroupNew.Lang)); cmd.Parameters.Add(new SqlParameter("@Id", tbGroupNew.Id)); ExecuteNonQuery(cmd); }
// dbCmd.Parameters.Add(new SqlParameter("@CusName", data.CusName)); public static void Insert(tbGroupNewInfo tbGroupNew) { string q = "insert into [tbGroupNews]([Name],[Tag],[Level],[Title],[Description],[Keyword],[Ord],"; q = q + "[Priority],[Index],[Active],[Lang]) values "; q = q + "(@Name,@Tag,@Level,@Title,@Description,@Keyword,@Ord,@Priority,"; q = q + "@Index,@Active,@Lang)"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = q; cmd.Connection = GetConnection(); cmd.Parameters.Add(new SqlParameter("@Name", tbGroupNew.Name)); cmd.Parameters.Add(new SqlParameter("@Tag", tbGroupNew.Tag)); cmd.Parameters.Add(new SqlParameter("@Level", tbGroupNew.Level)); cmd.Parameters.Add(new SqlParameter("@Title", tbGroupNew.Title)); cmd.Parameters.Add(new SqlParameter("@Description", tbGroupNew.Description)); cmd.Parameters.Add(new SqlParameter("@Keyword", tbGroupNew.Keyword)); cmd.Parameters.Add(new SqlParameter("@Ord", tbGroupNew.Ord)); cmd.Parameters.Add(new SqlParameter("@Priority", tbGroupNew.Priority)); cmd.Parameters.Add(new SqlParameter("@Index", tbGroupNew.Index)); cmd.Parameters.Add(new SqlParameter("@Active", tbGroupNew.Active)); cmd.Parameters.Add(new SqlParameter("@Lang", tbGroupNew.Lang)); ExecuteNonQuery(cmd); }
protected void grvUser_ItemCommand(object source, DataGridCommandEventArgs e) { Id = int.Parse(e.CommandArgument.ToString()); switch (e.CommandName) { case "Edit": insert = false; pnView.Visible = false; pnUpdate.Visible = true; lblAction.Text = "Update"; tbGroupNewInfo groupNewInfo = new tbGroupNewInfo(); groupNewInfo.Id = Id; DataTable dt = GroupNewsController.GetByColumn("Id", Id.ToString()); txtName.Text = dt.Rows[0]["Name"].ToString(); txtTag.Text = dt.Rows[0]["Tag"].ToString(); txtLevel.Text = dt.Rows[0]["Level"].ToString(); txtTitle.Text = dt.Rows[0]["Title"].ToString(); txtDesciption.Text = dt.Rows[0]["Description"].ToString(); txtKeyword.Text = dt.Rows[0]["Keyword"].ToString(); txtOrd.Text = dt.Rows[0]["Ord"].ToString(); txtPriority.Text = dt.Rows[0]["Priority"].ToString(); txtIndex.Text = dt.Rows[0]["Index"].ToString(); // chkActive.Checked =Convert.ToBoolean(dt.Rows[0]["Active"].ToString()); txtLang.Text = dt.Rows[0]["Lang"].ToString(); break; case "Delete": tbGroupNewInfo obj = new tbGroupNewInfo(); obj.Id = Id; GroupNewsController.Delete(obj); pnUpdate.Visible = false; pnView.Visible = true; _loadGroup(); break; } }
public static void Delete(tbGroupNewInfo obj) { string q = "Delete from tbGroupNews where Id=" + obj.Id; ExecuteNonQuery(q); }