public bool Insert(LossListDTO l)
{
string sql = "sp_LostList_Insert";
List<SqlParameter> ds = new List<SqlParameter>();
SqlParameter diengiai = new SqlParameter("@diengiai", SqlDbType.NVarChar);
diengiai.Value=l.TenHangMuc;
ds.Add(diengiai);
SqlParameter soluong= new SqlParameter("@soluong", SqlDbType.Float);
soluong.Value=l.SoLuong;
ds.Add(soluong);
SqlParameter donvi= new SqlParameter("@donvi", SqlDbType.Int);
donvi.Value=l.MaDonViTinh;
ds.Add(donvi);
SqlParameter ghichu= new SqlParameter("@ghichu", SqlDbType.NVarChar);
ghichu.Value=l.GhiChu;
ds.Add(ghichu);
SqlParameter loai= new SqlParameter("@loai", SqlDbType.Int);
loai.Value=l.LoaiHangMuc;
ds.Add(loai);
SqlParameter idclaim= new SqlParameter("@idclaim", SqlDbType.VarChar);
idclaim.Value=l.MaClaim;
ds.Add(idclaim);
bool kq = false;
kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return kq;
}
protected void btnInsertItem_Click(object sender, EventArgs e)
{
if (this.IsPostBack)
{
LossListDTO l = new LossListDTO();
LossListDAO ldao = new LossListDAO();
string tenhangmuc = txtDescription.Text;
if (tenhangmuc != "")
{
l.TenHangMuc = tenhangmuc;
float sl = 0;
if (txtSoLuong.Text != "" && float.TryParse(txtSoLuong.Text, out sl))
{
l.SoLuong = sl;
l.MaDonViTinh = int.Parse(drUnit.SelectedItem.Value.ToString());
string ghichu = txtGhiChu.Text;
if (ghichu != "")
l.GhiChu = ghichu;
else
l.GhiChu = "";
l.LoaiHangMuc = int.Parse(drTypeItem.SelectedItem.Value.ToString());
l.MaClaim = lblIDClaim.Text;
bool kq = ldao.Insert(l);
if (kq == true)
{
int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
string noidung = gdv.LayTenTheoMa(maGDV) + " created item loss worksheet of case " + lblIDClaim.Text + ".";
SaveLogTracking(maGDV, noidung, lblIDClaim.Text);
LoadItem(lblIDClaim.Text);
ClearInputs(Page.Controls);
}
else
Response.Write("<script>alert('Nhập đủ các vị trí có (*)!');</script>");
}
else
Response.Write("<script>alert('Nhập sai định dạng sô!');</script>");
}
else
Response.Write("<script>alert('Không bỏ trống tên hạng mục tổn thất!');</script>");
}
}
public bool Update(LossListDTO l)
{
string sql = "sp_LostList_Update";
List<SqlParameter> ds = new List<SqlParameter>();
SqlParameter diengiai = new SqlParameter("@diengiai", SqlDbType.NVarChar);
diengiai.Value = l.TenHangMuc;
ds.Add(diengiai);
SqlParameter soluong = new SqlParameter("@soluong", SqlDbType.Float);
soluong.Value = l.SoLuong;
ds.Add(soluong);
SqlParameter ghichu = new SqlParameter("@ghichu", SqlDbType.NVarChar);
ghichu.Value = l.GhiChu;
ds.Add(ghichu);
SqlParameter id = new SqlParameter("@malostlist", SqlDbType.Int);
id.Value = l.MaLossList;
ds.Add(id);
bool kq = false;
kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return kq;
}
protected void grDSItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (this.IsPostBack)
{
GridViewRow row = grDSItem.Rows[e.RowIndex];
TextBox txtTenHangMuc2 = row.Cells[1].Controls[0] as TextBox;
TextBox txtsoluong2 = row.Cells[2].Controls[0] as TextBox;
TextBox txtghichu2 = row.Cells[5].Controls[0] as TextBox;
int ma = int.Parse(grDSItem.DataKeys[e.RowIndex].Value.ToString());
LossListDTO l = new LossListDTO();
l.MaLossList = ma;
l.TenHangMuc = txtTenHangMuc2.Text;
l.SoLuong = float.Parse(txtsoluong2.Text);
l.GhiChu = txtghichu2.Text;
bool kq = ld.Update(l);
if (kq == true)
{
e.Cancel = true;
grDSItem.EditIndex = -1;
LoadItem(lblIDClaim.Text);
int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
string noidung = gdv.LayTenTheoMa(maGDV) + " edited item loss worksheet of case " + lblIDClaim.Text + ".";
SaveLogTracking(maGDV, noidung, lblIDClaim.Text);
}
}
}