public static WebUp Get(long ID) { Type type = typeof(WebUp); string sql = @"select * from WebUp where ID=" + ID; DataTable dtTable = Provider.ExecuteToDataTable(sql); if (dtTable.Rows.Count > 0) { WebUp cus = new WebUp(); return((WebUp)Common.GetObjectValue(dtTable.Rows[0], type, cus)); } return(null); }
public static WebUp Get(long ID) { Type type = typeof(WebUp); string sql = @"select * from WebUp where ID=" + ID; DataTable dtTable = Provider.ExecuteToDataTable(sql); if (dtTable.Rows.Count > 0) { WebUp cus = new WebUp(); return (WebUp)Common.GetObjectValue(dtTable.Rows[0], type, cus); } return null; }
public static void Update(WebUp cus) { string sql = @"UPDATE [WebUp] SET [Page] = " + cus.Page + @" ,[UrlPost] = '" + cus.UrlPost + @"' ,[Note] = '" + cus.Note + @"' ,[Topic] = '" + cus.Topic + @"' ,[IDTopic] = '" + cus.IDTopic + @"' ,[Group] = " + cus.Group + @" ,[Type] = '" + cus.Type + @"' WHERE ID=" + cus.ID; Provider.ExecuteNonQuery(sql); }
public static long Insert(WebUp cus) { string sql = @"INSERT INTO WebUp ([Page] ,[UrlPost] ,[Topic] ,[IDTopic] ,[Note] ,[Group] ,[Type]) VALUES (" + cus.Page + @" ,'" + cus.UrlPost + @"' ,'" + cus.Topic + @"' ,'" + cus.IDTopic + @"' ,'" + cus.Note + @"' ," + cus.Group + @" ,'" + cus.Type + @"')"; Provider.ExecuteNonQuery(sql); return(long.Parse(Provider.ExecuteScalar("Select @@IDENTITY").ToString())); }
public static long Insert(WebUp cus) { string sql = @"INSERT INTO WebUp ([Page] ,[UrlPost] ,[Topic] ,[IDTopic] ,[Note] ,[Group] ,[Type]) VALUES (" + cus.Page + @" ,'" + cus.UrlPost + @"' ,'" + cus.Topic+ @"' ,'" + cus.IDTopic + @"' ,'" + cus.Note + @"' ," + cus.Group + @" ,'" + cus.Type + @"')"; Provider.ExecuteNonQuery(sql); return long.Parse(Provider.ExecuteScalar("Select @@IDENTITY").ToString()); }
private WebUp _getFormInfo() { WebUp temp = null ; if (lookUpEditPage.EditValue != null) { if (lookUpEdit_Nhom.EditValue != null) { if (txtUrlPost.Text != "") { temp = new WebUp(); temp.Group = (int) lookUpEdit_Nhom.EditValue; temp.Page = long.Parse( lookUpEditPage.EditValue.ToString()); temp.Type = _Type; temp.UrlPost = txtUrlPost.Text; temp.Note = txtNote.Text; temp.Topic = txtTopic.Text; temp.IDTopic = txtIDTopic.Text; } else { MessageBox.Show("Nhập link topic cần post tin", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); txtUrlPost.Focus(); } } else { MessageBox.Show("Chọn nhóm link", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); lookUpEdit_Nhom.Focus(); } } else { MessageBox.Show("Chọn trang Web", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); lookUpEditPage.Focus(); } return temp; }
private void btnLuu_Click(object sender, EventArgs e) { WebUp temp = _getFormInfo(); if (temp != null) { if (_cus == null) //thêm mới { _cus = temp; txtID.Text=WebUp.Insert( _cus).ToString(); DialogResult = DialogResult.OK; if (chkCloseAlterSave.Checked) { this.Close(); return; } _setFormStatus(-1); } else //cập nhật { temp.ID = _cus.ID; _cus = temp; WebUp.Update(_cus); DialogResult = DialogResult.OK; if (chkCloseAlterSave.Checked) { this.Close(); return; } _setFormStatus(-1); } } }
private void _ClearForm() { txtID.Text = ""; lookUpEdit_Nhom.EditValue = null; lookUpEditPage.EditValue = null; txtUsername.Text = ""; txtUrlPost.Text = ""; txtPassword.Text = ""; txtNote.Text = ""; txtTopic.Text = ""; txtIDTopic.Text = ""; _cus = null; lookUpEditPage.Focus(); }