public bool ThemOther(SummarydetailDTO s)
{
string sql = "sp_Summary_InsertO";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter idsum = new SqlParameter("@idsum", SqlDbType.Int);
idsum.Value = s.MaSummary;
ds.Add(idsum);
SqlParameter theloai = new SqlParameter("@idtheloaisum", SqlDbType.Int);
theloai.Value = s.MaTheLoai;
ds.Add(theloai);
SqlParameter hangmuc = new SqlParameter("@hangmuc", SqlDbType.NVarChar);
hangmuc.Value = s.TenHangMuc;
ds.Add(hangmuc);
SqlParameter giatrikhieunai = new SqlParameter("@giatrikhieunai", SqlDbType.Float);
giatrikhieunai.Value = s.GiaTriKhieuNai;
ds.Add(giatrikhieunai);
SqlParameter ghichu = new SqlParameter("@ghichu", SqlDbType.NVarChar);
ghichu.Value = s.GhiChu;
ds.Add(ghichu);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
public bool ThemSummaryDettailMoi(SummarydetailDTO sum)
{
string sql = "sp_Summary_Detail_insert";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter idsum = new SqlParameter("@idsummary", SqlDbType.Int);
idsum.Value = sum.MaSummary;
ds.Add(idsum);
SqlParameter idtheloai = new SqlParameter("@idtheloaisum", SqlDbType.Int);
idtheloai.Value = sum.MaTheLoai;
ds.Add(idtheloai);
SqlParameter hangmuc = new SqlParameter("@tenhangmuc", SqlDbType.NVarChar);
hangmuc.Value = sum.TenHangMuc;
ds.Add(hangmuc);
SqlParameter GTkhieunai = new SqlParameter("@giatrikhieunai", SqlDbType.Float);
GTkhieunai.Value = sum.GiaTriKhieuNai;
ds.Add(GTkhieunai);
SqlParameter sl = new SqlParameter("@soluong", SqlDbType.Int);
sl.Value = sum.SoLuong;
ds.Add(sl);
SqlParameter thiethai = new SqlParameter("@thiethaihoply", SqlDbType.Float);;
thiethai.Value = sum.ThietHaiHopLy;
ds.Add(thiethai);
SqlParameter dexuat = new SqlParameter("@dexuattinhtoan", SqlDbType.Float);
dexuat.Value = sum.DeXuatTinhToan;
ds.Add(dexuat);
SqlParameter ghichu = new SqlParameter("@ghichu", SqlDbType.NVarChar);
ghichu.Value = sum.GhiChu;
ds.Add(ghichu);
SqlParameter mamg = new SqlParameter("@mamenhgia", SqlDbType.Int);
mamg.Value = sum.MaMenhGia;
ds.Add(mamg);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
bool CapNhatSum(GridViewRow row, int idsumd)
{
//string id = Request.QueryString["Reference"];
//string id = Session["ThamChieu"].ToString();
string id = lblThamChieu.Text;
TextBox tenhangmuc = row.Cells[1].Controls[0] as TextBox;
TextBox giatrikhieunai = row.Cells[2].Controls[0] as TextBox;
TextBox soluong = row.Cells[3].Controls[0] as TextBox;
TextBox thiethaihoply = row.Cells[4].Controls[0] as TextBox;
TextBox dexuattinhtoan = row.Cells[5].Controls[0] as TextBox;
TextBox ghichu = row.Cells[7].Controls[0] as TextBox;
SummarydetailDTO smddt = new SummarydetailDTO();
int masum = LayMaSummary(id);
smddt.MaSummary = masum;
smddt.MaSummaryDetail = idsumd;
smddt.TenHangMuc = tenhangmuc.Text;
smddt.GiaTriKhieuNai = float.Parse(giatrikhieunai.Text);
smddt.ThietHaiHopLy = float.Parse(thiethaihoply.Text);
smddt.SoLuong = int.Parse(soluong.Text);
smddt.DeXuatTinhToan = float.Parse(dexuattinhtoan.Text);
smddt.GhiChu = ghichu.Text;
return(smddao.CapNhatSummaryDetail(smddt));
}
