public List <SalaryBoardConfigInfo> GetSalaryBoardConfig(int menuID)
{
List <SalaryBoardConfigInfo> lists = new List <SalaryBoardConfigInfo>();
foreach (var item in GetSalaryConfigByMenuID(menuID))
{
SalaryBoardConfigInfo info = new SalaryBoardConfigInfo()
{
AllowSum = item.AllowSum,
ColumnDescription = item.ColumnDescription,
ColumnName = item.ColumnName,
RenderJS = item.RenderJS,
Width = item.Width,
EditOnGrid = item.EditOnGrid
};
lists.Add(info);
}
return(lists);
}
/// <summary>
/// Lấy các cấu hình bảng lương dựa vào menuID
/// @Lê Anh
/// </summary>
/// <param name="menuID"></param>
/// <returns></returns>
public List <SalaryBoardConfigInfo> GetSalaryConfigByMenuID(int menuID)
{
DataTable table = DataHandler.GetInstance().ExecuteDataTable("TienLuong_GetSalaryConfig", "@menuID", menuID);
List <SalaryBoardConfigInfo> result = new List <SalaryBoardConfigInfo>();
foreach (DataRow item in table.Rows)
{
SalaryBoardConfigInfo itemConfig = new SalaryBoardConfigInfo()
{
AllowSum = bool.Parse(item["AllowSum"].ToString()),
ColumnDescription = item["ColumnDescription"].ToString(),
ColumnName = item["ColumnName"].ToString(),
Width = int.Parse("0" + item["Width"].ToString()),
RenderJS = item["RenderJS"].ToString(),
EditOnGrid = bool.Parse(item["AllowEditOnGrid"].ToString())
};
result.Add(itemConfig);
}
return(result);
}
public void AfterEdit(int id, int prkey, string field, string oldValue, string newValue, SalaryBoardConfigInfo oj)
{
try
{
if (newValue == "" && oj.DataSourceFunction == "")
{
if (oj.ColumnName == "Formula" || oj.ColumnName == "DataSourceFunction")
{
newValue = "";
}
else
{
newValue = "0";
}
}
SalaryBoardConfigController sdc = new SalaryBoardConfigController();
sdc.Update(id, prkey, field, newValue);
this.grpSalaryConfig.Store.Primary.CommitChanges();
if (field == "IsInUsed")
{
string colName = oj.ColumnName;
int menuID = int.Parse(hdfSalaryTable.Text);
int v = bool.Parse(newValue) == true ? 1 : 0;
if (v == 0)
{
try
{
string sql = "UPDATE TienLuong.BangLuongDong SET " + colName + " = " + v +
" WHERE IdBangLuong IN (SELECT dsbl.ID FROM TienLuong.DanhSachBangLuong dsbl WHERE dsbl.MenuID = " + menuID + ")";
DataController.DataHandler.GetInstance().ExecuteNonQuery(sql);
}
catch (Exception)
{
}
}
}
}
catch (Exception ex) { Dialog.ShowError(ex.Message); }
}
