// insert loai cong
#region them loai cong
public static bool InsertLoaicong(DMLoaicong loaicong)
{
try
{
DataTable dt = new DataTable("DMLoaiCong");
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cm = new SqlCommand();
cm.Connection = DA.Ketnoi.Cmb();
cm.CommandType = CommandType.Text;
cm.CommandText = @"insert into DMloaicong(maloai,tenloai,heso) values (@maloai,@tenloai,@heso)";
cm.Parameters.Add("@maloai", SqlDbType.NVarChar, 10).Value = loaicong.Maloai;
cm.Parameters.Add("@tenloai", SqlDbType.NVarChar, 100).Value = loaicong.Tenloai;
cm.Parameters.Add("@heso", SqlDbType.Float, 50).Value = loaicong.Heso;
da.SelectCommand = cm;
da.Fill(dt);
return(true);
}
catch
{
return(false);
}
//string s= "Insert into DMloaicong values ('"+loaicong.Maloai+"','"+loaicong.Tenloai+"',"+loaicong.Heso+")";
//string sql = string.Format(s);
//return DA.Ketnoi.ExcuteNonQuery(sql);
}
public static string _sua(DMLoaicong lc, string maloai)
{
string s = "update DMloaicong set maloai='" + lc.Maloai + "', tenloai=N'" + lc.Tenloai + "', heso='" + lc.Heso + "' where maloai='" + maloai + "'";
string sql = string.Format(s);
return(DA.Ketnoi.ExcuteNonQuery(sql));
}
private void sua()
{
DMLoaicong lc = new DMLoaicong();
lc.Maloai = txtMaloaicong.Text;
lc.Tenloai = txtTenloaicong.Text;
lc.Heso = txtHeso.Text;
frmSualoaicong frm = new frmSualoaicong(lc);
frm.reload = new frmSualoaicong.Reload(Loadtoanbothongtin);
frm.Show();
}
// select loai cong
#region select loai cong
public static List <DTO.DMLoaicong> selectLoaicong()
{
List <DTO.DMLoaicong> lc = new List <DMLoaicong>();
DataTable tb = new DataTable();
tb = DA.Ketnoi.ExcecuteQuery("select * from DMLoaicong");
for (int i = 0; i < tb.Rows.Count; i++)
{
DMLoaicong lc1 = new DMLoaicong();
lc1.Maloai = tb.Rows[i]["maloai"].ToString();
lc1.Tenloai = tb.Rows[i]["tenloai"].ToString();
lc1.Heso = tb.Rows[i]["heso"].ToString();
lc.Add(lc1);
}
return(lc);
}
public void Capnhat()
{
if (kiemtraNhap())
{
DMLoaicong loaicong = new DMLoaicong();
loaicong.Maloai = txtMaloaicong.Text;
loaicong.Tenloai = txtTenloaicong.Text;
loaicong.Heso = txtHesoluong.Text;
if (BUS.BUS_Loaicong._sua(loaicong, lc.Maloai) == "true")
{
MessageBox.Show("Sửa thành công loại công có mã " + txtMaloaicong.Text + "", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
reload();
this.Close();
}
}
}
// sua loai cong
public static string _sua(DMLoaicong lc, string maloai)
{
return(DAO.DAO_Loaicong._sua(lc, maloai));
}