public bool themBCTT(BCTinhTrangDTO baocao) { string query = string.Empty; query += "INSERT INTO [CTCHIPHICHAMSOCTHANG] ([macttinhtrangcay],[matinhtrangthang],[macay],[maloaicay],[matinhtrang]) "; query += "VALUES (@macttinhtrangcay,@matinhtrangthang,@macay,@maloaicay,@matinhtrang)"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@macttinhtrangcay", baocao.MaCTTinhTrangCayPT); cmd.Parameters.AddWithValue("@matinhtrangthang", baocao.MaTinhTrangThangPT); cmd.Parameters.AddWithValue("@macay", baocao.MaCayPT); cmd.Parameters.AddWithValue("@maloaicay", baocao.MaLoaiCayPT); cmd.Parameters.AddWithValue("@matinhtrang", baocao.MaTinhTrangPT); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public List <BCTinhTrangDTO> selectBCTT() { string query = string.Empty; query += "SELECT[mactchiphithang],[machiphithang],[mavattu],[sophieumua],[tongtrigia],[tyle]"; query += "FROM [CTCHIPHICHAMSOCTHANG]"; List <BCTinhTrangDTO> lsBaoCao = new List <BCTinhTrangDTO>(); using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; try { con.Open(); SqlDataReader reader = null; reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { BCTinhTrangDTO BaoCao = new BCTinhTrangDTO(); BaoCao.MaCTTinhTrangCayPT = reader["macttinhtrangcay"].ToString(); BaoCao.MaTinhTrangThangPT = reader["matinhtrangthang"].ToString(); BaoCao.MaCayPT = reader["macay"].ToString(); BaoCao.MaLoaiCayPT = int.Parse(reader["maloaicay"].ToString()); BaoCao.MaTinhTrangPT = int.Parse(reader["matinhtrang"].ToString()); lsBaoCao.Add(BaoCao); } } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(null); } } } return(lsBaoCao); }
private bool XuLySoLieu() { Result = new List <BCTinhTrangDTO>(); BCTinhTrangDTO Temp; if (yearBT.Text == "" || monthBT.Text == "") { return(false); } else if (int.Parse(yearBT.Text) < 0) { return(false); } else if (int.Parse(monthBT.Text) < 0 || int.Parse(monthBT.Text) >= 12) { return(false); } DateTime ngayTim = new DateTime(int.Parse(yearBT.Text), int.Parse(monthBT.Text), 1); int i = 0; if (listCay == null || listCay.Count == 0) { return(false); } for (i = 0; i < listCay.Count(); i++) { Temp = new BCTinhTrangDTO(); Temp.MaCTTinhTrangCayPT = yearBT.Text + monthBT.Text + listCay[i].MaCayCanhPT; Temp.MaTinhTrangThangPT = yearBT.Text + monthBT.Text + i.ToString(); Temp.MaCayPT = listCay[i].MaCayCanhPT; Temp.MaLoaiCayPT = listCay[i].MaLoaiCayCanhPT; Temp.MaTinhTrangPT = listCay[i].TinhTrangPT; Temp.TenCayPT = listCay[i].TenCayPT; Temp.TenLoaiCayPT = listloaiCay[listCay[i].MaLoaiCayCanhPT - 1].TenLoaiCayPT; Temp.TenTinhTrangPT = listTinhTrang[listCay[i].MaLoaiCayCanhPT - 1].TenTinhTrangPT; Temp.NgaytrongPT = listCay[i].NgayTrongPT; Result.Add(Temp); } return(true); }
public bool them(BCTinhTrangDTO thang) { bool result = tinhTrangDAL.themBCTT(thang); return(result); }