public int InsertUpdate(Entities.PhongBan pb1)
{
try
{
pb = new Constants.PhongBan();
Sql = new Constants.Sql();
string sql = Sql.InsertUpdatePhongBan;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(pb.HanhDong, SqlDbType.NVarChar, 20).Value = pb1.HanhDong;
cmd.Parameters.Add(pb.PhongBanID, SqlDbType.Int).Value = pb1.PhongBanID;
cmd.Parameters.Add(pb.MaPhongBan, SqlDbType.NVarChar, 20).Value = pb1.MaPhongBan;
cmd.Parameters.Add(pb.TenPhongBan, SqlDbType.NVarChar, 200).Value = pb1.TenPhongBan;
cmd.Parameters.Add(pb.GhiChu, SqlDbType.NVarChar, 100).Value = pb1.GhiChu;
cmd.Parameters.Add(pb.Deleted, SqlDbType.Bit).Value = pb1.Deleted;
int i = cmd.ExecuteNonQuery();
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return(i);
}
catch (Exception ex)
{
string s = ex.Message;
return(0);
}
}
public Entities.PhongBan[] Select()
{
Entities.PhongBan[] arrC = null;
try
{
pb = new Constants.PhongBan();
Sql = new Constants.Sql();
string sql = Sql.SelectAllPhongBan;
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
arr = new ArrayList();
while (dr.Read())
{
Entities.PhongBan phongban = new Entities.PhongBan();
phongban.PhongBanID = Convert.ToInt32(dr[pb.PhongBanID].ToString());
phongban.MaPhongBan = dr[pb.MaPhongBan].ToString();
phongban.TenPhongBan = dr[pb.TenPhongBan].ToString();
phongban.GhiChu = dr[pb.GhiChu].ToString();
phongban.Deleted = (Boolean)dr[pb.Deleted];
arr.Add(phongban);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
arrC = new Entities.PhongBan[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.PhongBan)arr[i];
}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); }
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(arrC);
}
public void Delete(Entities.PhongBan pb1)
{
pb = new Constants.PhongBan();
Sql = new Constants.Sql();
string sql = Sql.DeletePhongBan;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(pb.HanhDong, SqlDbType.NVarChar, 20).Value = pb1.HanhDong;
cmd.Parameters.Add(pb.PhongBanID, SqlDbType.Int).Value = pb1.PhongBanID;
cmd.ExecuteNonQuery();
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
}
public void showCombobox_PhongBan()
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
pb = new PhongBan("Select");
clientstream = cl.SerializeObj(this.client1, "PhongBan", pb);
PhongBan[] pb1 = new PhongBan[1];
pb1[0] = new PhongBan(1, "a", "a", "a", false);
pb1 = (PhongBan[])cl.DeserializeHepper1(clientstream, pb1);
cbbmapb.DataSource = pb1;
cbbmapb.DisplayMember = "TenPhongBan";
}
public Entities.PhongBan[] Select()
{
Entities.PhongBan[] arrC = null;
try
{
pb = new Constants.PhongBan();
Sql = new Constants.Sql();
string sql = Sql.SelectAllPhongBan;
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
arr = new ArrayList();
while (dr.Read())
{
Entities.PhongBan phongban = new Entities.PhongBan();
phongban.PhongBanID = Convert.ToInt32(dr[pb.PhongBanID].ToString());
phongban.MaPhongBan = dr[pb.MaPhongBan].ToString();
phongban.TenPhongBan = dr[pb.TenPhongBan].ToString();
phongban.GhiChu = dr[pb.GhiChu].ToString();
phongban.Deleted = (Boolean)dr[pb.Deleted];
arr.Add(phongban);
}
int n = arr.Count;
if (n == 0) { return null; }
arrC = new Entities.PhongBan[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.PhongBan)arr[i];
}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); }
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return arrC;
}
public void hienthi()
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
pb = new PhongBan("Select");
clientstrem = cl.SerializeObj(this.client1, "PhongBan", pb);
PhongBan[] pb1 = new PhongBan[1];
pb1[0] = new PhongBan(1, "a", "a", "a", false);
pb1 = (PhongBan[])cl.DeserializeHepper1(clientstrem, pb1);
if (pb1 == null)
{
Entities.PhongBan [] pb2=new PhongBan[0];
dataGridView1.DataSource = pb2;
PhongBan_Search = pb2;
FixDataGridView();
toolStripStatus_Sua.Enabled = false;
toolStripStatus_Xoa.Enabled = false;
}
else
{
dataGridView1.DataSource = pb1;
PhongBan_Search = pb1;
FixDataGridView();
toolStripStatus_Sua.Enabled = true;
toolStripStatus_Xoa.Enabled = true;
}
}
private void txtTimKiem_TextChanged(object sender, EventArgs e)
{
if (rdbTen.Checked == true)
{
if (PhongBan_Search == null)
{
PhongBan[] pb = new PhongBan[0];
dataGridView1.DataSource = pb;
FixDataGridView();
toolStripStatus_Xoa.Enabled = false;
toolStripStatus_Sua.Enabled = false;
}
else
if (PhongBan_Search != null)
{
if (txtTimKiem.Text.Length == 0)
{
PhongBan[] pb = new PhongBan[0];
dataGridView1.DataSource = pb;
FixDataGridView();
toolStripStatus_Xoa.Enabled = false;
toolStripStatus_Sua.Enabled = false;
}
else
{
int TKKT1_search_count = 0;
for (int i = 0; i < PhongBan_Search.Length; i++)
{
int index = -1;
index = PhongBan_Search[i].TenPhongBan.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower());
if (index >= 0)
{
TKKT1_search_count++;
}
}
PhongBan[] TKKT1_search = new PhongBan[TKKT1_search_count];
TKKT1_search_count = 0;
for (int i = 0; i < PhongBan_Search.Length; i++)
{
int index = -1;
index = PhongBan_Search[i].TenPhongBan.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower());
if (index >= 0)
{
TKKT1_search[TKKT1_search_count] = PhongBan_Search[i];
TKKT1_search_count++;
}
}
if (TKKT1_search_count == 0)
{
toolStripStatus_Sua.Enabled = false;
toolStripStatus_Xoa.Enabled = false;
}
else
{
toolStripStatus_Sua.Enabled = true;
toolStripStatus_Xoa.Enabled = true;
}
dataGridView1.DataSource = TKKT1_search;
FixDataGridView();
}
}
}
else
if (rdbMa.Checked == true)
{
if (PhongBan_Search == null)
{
PhongBan[] pb = new PhongBan[0];
dataGridView1.DataSource = pb;
FixDataGridView();
toolStripStatus_Xoa.Enabled = false;
toolStripStatus_Sua.Enabled = false;
}
else
if (PhongBan_Search != null)
{
if (txtTimKiem.Text.Length == 0)
{
PhongBan[] pb = new PhongBan[0];
dataGridView1.DataSource = pb;
FixDataGridView();
toolStripStatus_Xoa.Enabled = false;
toolStripStatus_Sua.Enabled = false;
}
else
{
int NV1_Search_count = 0;
for (int i = 0; i < PhongBan_Search.Length; i++)
{
int index = -1;
index = PhongBan_Search[i].MaPhongBan.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower());
if (index >= 0)
{
NV1_Search_count++;
}
}
PhongBan[] NV1_search = new PhongBan[NV1_Search_count];
NV1_Search_count = 0;
for (int i = 0; i < PhongBan_Search.Length; i++)
{
int index = -1;
index = PhongBan_Search[i].MaPhongBan.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower());
if (index >= 0)
{
NV1_search[NV1_Search_count] = PhongBan_Search[i];
NV1_Search_count++;
}
}
if (NV1_Search_count == 0)
{
toolStripStatus_Sua.Enabled = false;
toolStripStatus_Xoa.Enabled = false;
}
else
{
toolStripStatus_Sua.Enabled = true;
toolStripStatus_Xoa.Enabled = true;
}
dataGridView1.DataSource = NV1_search;
FixDataGridView();
}
}
}
}
private void toolStripStatus_Xoa_Click(object sender, EventArgs e)
{
if (!frmDangNhap.User.Administrator && !CheckQuyen(this.Name, 3))
{
MessageBox.Show("Bạn Không có quyền vào chức năng này.");
return;
}
DialogResult dlgResult = MessageBox.Show("Bạn Có Chắc Chắn muốn Xóa không?", "Đồng ý?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlgResult == DialogResult.Yes)
{
try
{
bool ktdelete = false;
int idcurent = int.Parse(dataGridView1.CurrentRow.Cells["PhongBanID"].Value.ToString());
string maCurrent = dataGridView1.CurrentRow.Cells["MaPhongBan"].Value.ToString();
hienthi();
for (int j = 0; j < PhongBan_Search.Length; j++)
{
if (PhongBan_Search[j].Deleted == false)
if (PhongBan_Search[j].PhongBanID == idcurent)
{
ktdelete = true;
break;
}
}
if (ktdelete == true)
{
try
{
if (new Check().CheckReference("PhongBan", maCurrent))
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
pb = new PhongBan("Delete", idcurent, maCurrent, "", "", false,Common.Utilities.User.NhanVienID,Common.Utilities.User.TenDangNhap);
clientstrem = cl.SerializeObj(this.client1, "PhongBan", pb);
// MessageBox.Show("Xoa Thanh Cong...");
}
else
{
MessageBox.Show("Phòng ban nayg hiện đang có giao dịch - Không thể xóa","Hệ thống cảnh báo");
}
}
catch { }
}
hienthi();
}
catch (Exception ex)
{
MessageBox.Show("Lỗi Hệ Thống- Liên Hệ nhà Quản Trị");
}
}
}
