public static long Insert(CustomersType cus) { string sql = "insert into [CustomersType]([Name],[Note]) values('" + cus.Name + "','" + cus.Note + "')"; Provider.ExecuteNonQuery(sql); return(long.Parse(Provider.ExecuteScalar("Select @@IDENTITY").ToString())); }
public static long Insert(CustomersType cus) { string sql = "insert into [CustomersType]([Name],[Note]) values('" + cus.Name + "','" + cus.Note + "')"; Provider.ExecuteNonQuery(sql); return long.Parse(Provider.ExecuteScalar("Select @@IDENTITY").ToString()); }
private void _ClearForm() { txtMa.Enabled = true; txtMa.Text = ""; txtTen.Text = ""; txtGhiChu.Text = ""; txtMa.Text = ""; _cusType = null; }
public static CustomersType GetObject(DataRow dtRow) { CustomersType cus = new CustomersType(); if (dtRow["Code"] != null && dtRow["Code"].ToString() != "") cus.Code = long.Parse(dtRow["Code"].ToString()); if (dtRow["Name"] != null && dtRow["Name"].ToString() != "") cus.Name = dtRow["Name"].ToString(); if (dtRow["Note"] != null && dtRow["Note"].ToString() != "") cus.Note = (dtRow["Note"].ToString()); return cus; }
public static CustomersType GetObject(DataRow dtRow) { CustomersType cus = new CustomersType(); if (dtRow["Code"] != null && dtRow["Code"].ToString() != "") { cus.Code = long.Parse(dtRow["Code"].ToString()); } if (dtRow["Name"] != null && dtRow["Name"].ToString() != "") { cus.Name = dtRow["Name"].ToString(); } if (dtRow["Note"] != null && dtRow["Note"].ToString() != "") { cus.Note = (dtRow["Note"].ToString()); } return(cus); }
public static void Update(CustomersType cus) { string sql = "Update [CustomersType] set [Name]='" + cus.Name + "',[Note]='" + cus.Note + "' where [Code]=" + cus.Code + ""; Provider.ExecuteNonQuery(sql); }
private CustomersType _getFormInfo() { CustomersType nhom = null; if (txtTen.Text != "") { nhom = new CustomersType(); //nhom.Ma = int.Parse(txtMa.Text); nhom.Name = txtTen.Text; nhom.Note = txtGhiChu.Text; } else { MessageBox.Show("Nhập vào tên loại khách hàng"); txtTen.Focus(); } return nhom; }
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { try { int k = gridView1.SelectedRowsCount; if (k > 0) { int RowHandle = gridView1.FocusedRowHandle; if (RowHandle >= 0) { _cusType = new CustomersType(); _cusType.Code = int.Parse(gridView1.GetRowCellValue(RowHandle, colMa).ToString()); _cusType.Name = gridView1.GetRowCellValue(RowHandle, colTen).ToString(); _cusType.Note = gridView1.GetRowCellValue(RowHandle, colGhiChu).ToString(); _SetFormInfo(); _setFormStatus("NORMAL"); } } } catch{} }
public frmCustomerType() { InitializeComponent(); _cusType = null; }