private void txtIDPSC_TextChanged(object sender, EventArgs e)
{
try
{
if (dgvPSC.SelectedCells.Count > 0)
{
int iditem = (int)dgvPSC.SelectedCells[0].OwningRow.Cells["iditem"].Value;
VatLieuDTO kho = VatLieuDAL.Instance.GetListKhoById(iditem);
cbVatLieu.SelectedItem = kho;
int indexkho = -1;
int i2 = 0;
foreach (VatLieuDTO item in cbVatLieu.Items)
{
if (item.Iditem == kho.Iditem)
{
indexkho = i2;
break;
}
i2++;
}
cbVatLieu.SelectedIndex = indexkho;
}
}
catch { }
}
public VatLieuDTO GetSLVatLieuById(int iditem)
{
VatLieuDTO kho = null;
DataTable data = DataProvider.Instance.ExecuteQuery("select slitem from dbo.vatlieu where iditem = " + iditem);
foreach (DataRow item in data.Rows)
{
kho = new VatLieuDTO(item);
return(kho);
}
return(kho);
}
public List <VatLieuDTO> GetListKho()
{
List <VatLieuDTO> khoList = new List <VatLieuDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from dbo.vatlieu");
foreach (DataRow item in data.Rows)
{
VatLieuDTO kho = new VatLieuDTO(item);
khoList.Add(kho);
}
return(khoList);
}
public List <VatLieuDTO> GetTonKhoByMonth(DateTime?createdDate)
{
List <VatLieuDTO> phieuthutienList = new List <VatLieuDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT IDITEM, ITEM, DONGIA, SLITEM, IMPORTEDDATE FROM VATLIEU WHERE MONTH(IMPORTEDDATE) = MONTH('" + createdDate + "') AND YEAR(IMPORTEDDATE) = YEAR('" + createdDate + "')");
foreach (DataRow item in data.Rows)
{
VatLieuDTO phieuthutien = new VatLieuDTO(item);
phieuthutienList.Add(phieuthutien);
}
return(phieuthutienList);
}
public List <VatLieuDTO> SearchVatLieuByNameAndID(string text)
{
List <VatLieuDTO> khoList = new List <VatLieuDTO>();
string query = string.Format("select * from dbo.vatlieu where dbo.GetUnsignString(item) like N'%' + dbo.GetUnsignString(N'{0}') + '%'", text);
query += string.Format(" or iditem like N'%' + N'{0}' + '%'", text);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
VatLieuDTO kho = new VatLieuDTO(item);
khoList.Add(kho);
}
return(khoList);
}
private void txtIDPSC_TextChanged(object sender, EventArgs e)
{
try
{
if (dgvPSC.SelectedCells.Count > 0)
{
int carnumber = (int)dgvPSC.SelectedCells[0].OwningRow.Cells["Carnumber"].Value;
int iditem = (int)dgvPSC.SelectedCells[0].OwningRow.Cells["iditem"].Value;
XeDTO xe = XeDAL.Instance.GetListXeById(carnumber);
VatLieuDTO kho = VatLieuDAL.Instance.GetListKhoById(iditem);
//cbHieuXe.SelectedItem = xe;
cbVatLieu.SelectedItem = kho;
int indexcar = -1;
int indexkho = -1;
int i1 = 0;
int i2 = 0;
//foreach (XeDTO item in cbHieuXe.Items)
//{
// if (item.Carnumber == xe.Carnumber)
// {
// indexcar = i1;
// break;
// }
// i1++;
//}
foreach (VatLieuDTO item in cbVatLieu.Items)
{
if (item.Iditem == kho.Iditem)
{
indexkho = i2;
break;
}
i2++;
}
//cbHieuXe.SelectedIndex = indexcar;
cbVatLieu.SelectedIndex = indexkho;
}
}
catch { }
}
