// Method ListForExcel
public void ListForExcel(MetroGrid grid, string keyword, string sortColumn, string sortBy, string columnFilter, object filterValue)
{
grid.Rows.Clear();
grid.Columns.Clear();
List <StuffsModel> stuffs = StuffsDao.Instance.ListForExcel(keyword, !string.IsNullOrEmpty(sortColumn) ? HelperBll.GetColumnNameInSQLByPropertyName <StuffsModel>(sortColumn) : "", sortBy, !string.IsNullOrEmpty(columnFilter) ? HelperBll.GetColumnNameInSQLByPropertyName <StuffsModel>(columnFilter) : "", filterValue);
StuffsModel nameOf = new StuffsModel();
grid.Columns.Add(nameof(nameOf.BQCode), nameof(nameOf.BQCode));
grid.Columns.Add(nameof(nameOf.Name), nameof(nameOf.Name));
grid.Columns.Add(nameof(nameOf.Category), nameof(nameOf.Category));
grid.Columns.Add(nameof(nameOf.PlaceStuff), nameof(nameOf.PlaceStuff));
grid.Columns.Add(nameof(nameOf.DateBuy), nameof(nameOf.DateBuy));
grid.Columns.Add(nameof(nameOf.DateUse), nameof(nameOf.DateUse));
grid.Columns.Add(nameof(nameOf.YearRelease), nameof(nameOf.YearRelease));
grid.Columns.Add(nameof(nameOf.ColorStuffs), nameof(nameOf.ColorStuffs));
grid.Columns.Add(nameof(nameOf.State), nameof(nameOf.State));
grid.Columns.Add(nameof(nameOf.PriceBuy), nameof(nameOf.PriceBuy));
grid.Columns.Add(nameof(nameOf.Warranty), nameof(nameOf.Warranty));
grid.Columns.Add(nameof(nameOf.CreatedDate), nameof(nameOf.CreatedDate));
grid.Columns.Add(nameof(nameOf.CreatedBy), nameof(nameOf.CreatedBy));
grid.Columns.Add(nameof(nameOf.ModifiedDate), nameof(nameOf.ModifiedDate));
grid.Columns.Add(nameof(nameOf.ModifiedBy), nameof(nameOf.ModifiedBy));
for (int i = 0; i < stuffs.Count; i++)
{
grid.Rows.Add();
grid[nameof(nameOf.BQCode), i].Value = stuffs[i].BQCode;
grid[nameof(nameOf.Name), i].Value = stuffs[i].Name;
grid[nameof(nameOf.Category), i].Value = stuffs[i].Category;
grid[nameof(nameOf.PlaceStuff), i].Value = stuffs[i].PlaceStuff;
grid[nameof(nameOf.DateBuy), i].Value = stuffs[i].DateBuy;
grid[nameof(nameOf.DateUse), i].Value = stuffs[i].DateUse;
grid[nameof(nameOf.YearRelease), i].Value = stuffs[i].YearRelease;
grid[nameof(nameOf.ColorStuffs), i].Value = stuffs[i].ColorStuffs;
grid[nameof(nameOf.State), i].Value = stuffs[i].State;
grid[nameof(nameOf.PriceBuy), i].Value = stuffs[i].PriceBuy;
grid[nameof(nameOf.Warranty), i].Value = stuffs[i].Warranty;
grid[nameof(nameOf.CreatedDate), i].Value = stuffs[i].CreatedDate;
grid[nameof(nameOf.CreatedBy), i].Value = stuffs[i].CreatedBy;
grid[nameof(nameOf.ModifiedDate), i].Value = stuffs[i].ModifiedDate.ToString() == "01-Jan-01 12:00:00 AM" ? "" : stuffs[i].ModifiedDate.ToString();
grid[nameof(nameOf.ModifiedBy), i].Value = stuffs[i].ModifiedBy;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (grvVL.RowCount == 0)
{
return;
}
grvVL.FocusedRowHandle = -1;
for (int i = 0; i < grvVL.RowCount; i++)
{
int id = TextUtils.ToInt(grvVL.GetRowCellValue(i, colID));
StuffsModel stuff = new StuffsModel();
if (id > 0)
{
stuff = (StuffsModel)StuffsBO.Instance.FindByPK(id);
}
stuff.Code = TextUtils.ToString(grvVL.GetRowCellValue(i, colCode));
stuff.Description = TextUtils.ToString(grvVL.GetRowCellValue(i, colDes));
stuff.Price = TextUtils.ToDecimal(grvVL.GetRowCellValue(i, colPrice));
stuff.Hang = TextUtils.ToString(grvVL.GetRowCellValue(i, colHang));
stuff.TypeWeight = TextUtils.ToBoolean(grvVL.GetRowCellValue(i, colWeight));
if (stuff.Code == "" && stuff.Hang == "")
{
continue;
}
if (id > 0)
{
StuffsBO.Instance.Update(stuff);
}
else
{
StuffsBO.Instance.Insert(stuff);
}
}
loadStuffs();
MessageBox.Show("Lưu trữ thành công!", TextUtils.Caption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
protected StuffsFacade(StuffsModel model) : base(model)
{
}
// Method Insert
public int Edit(StuffsModel stuff, string[] paramters)
{
Dictionary <string, object> dicParamters = HelperDao.GenerateParameter <StuffsModel>(stuff, paramters);
return(DataProvider.Instance.Execute(StuffsQuerys.Edit(paramters, stuff.Id), dicParamters));
}
// Method CheckExist
public int CheckExist(StuffsModel stuff, string[] parameters)
{
Dictionary <string, object> dicParameters = HelperDao.GenerateParameter <StuffsModel>(stuff, parameters);
return(DataProvider.Instance.Count(StuffsQuerys.CheckExsist(parameters, stuff.Id), dicParameters));
}
