/// <summary>
/// Xóa tbleAliasMapping
/// </summary>
/// <param name="pId"></param>
public static void DeleteAliasMapping(int pId)
{
if (TblAliasMapping.FetchByID(pId) != null)
{
TblAliasMapping.Delete(pId);
}
}
/// <summary>
/// Insert vào tblAliasMapping in db
/// </summary>
/// <param name="pitems"></param>
/// <returns></returns>
public static string InsertAliasMapping(TblAliasMapping pitems)
{
int i = 0;
Query _QueryRS = TblAliasMapping.CreateQuery();
try
{
if (
!TblAliasMapping.FetchByParameter(TblAliasMapping.Columns.LocalAlias, Comparison.Equals,
pitems.LocalAlias).Read())
{
pitems.IsNew = true;
pitems.Save(i);
return(_QueryRS.GetMax(TblAliasMapping.Columns.Id).ToString());
}
else
{
return("-1");
//throw new Exception(string.Format("Name:{0} Đã tồn tại", pitems.IPAddress));
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateAliasMaping()
{
TblAliasMapping pitems;
string localali = "", TestId = "";
int id_xn = 0;
var dataTable = GrdAliasPara.DataSource as DataTable;
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dr = dataTable.Rows[i];
object c = dr[TblAliasMapping.Columns.Id];
//Kiểm tra trạng thái của dòng:
if ((dr.RowState == DataRowState.Modified) || (dr.RowState == DataRowState.Added))
{
localali = dr[TblAliasMapping.Columns.LocalAlias].ToString();
TestId = dr[TblAliasMapping.Columns.TestTypeId].ToString();
id_xn = Convert.ToInt32(dr[TblAliasMapping.Columns.IdHisXn].ToString());
if ((localali == ""))
{
SetTextForWarning(MsgEror);
continue;
}
}
if (dr.RowState == DataRowState.Modified)
{
pitems = new TblAliasMapping(dr[TblAliasMapping.Columns.Id]);
pitems.LocalAlias = localali;
pitems.TestTypeId = Convert.ToInt32(TestId);
pitems.IdHisXn = Convert.ToInt32(id_xn);
AliasMappingBusiness.UpdateAliasMapping(pitems);
SetTextForWarning(MsgUpdate);
}
else if (dr.RowState == DataRowState.Added)
{
pitems = new TblAliasMapping();
pitems.LocalAlias = localali;
pitems.TestTypeId = Convert.ToInt32(TestId);
pitems.IdHisXn = Convert.ToInt32(id_xn);
string id = AliasMappingBusiness.InsertAliasMapping(pitems);
if (id == "-1")
{
//MessageBox.Show("Tên thông số " + pitems.LocalAlias + " đã tồn tại", "Thông báo:",
// MessageBoxButtons.OK,
// MessageBoxIcon.Error);
SetTextForWarning(MsgExits);
dr.Delete();
}
else
{
dr[TblAliasMapping.Columns.Id] = AliasMappingBusiness.InsertAliasMapping(pitems);
SetTextForWarning(MsgNew);
}
}
}
dataTable.AcceptChanges();
}
/// <summary>
/// Update tblAliasMaping
/// </summary>
/// <param name="pitems"></param>
public static void UpdateAliasMapping(TblAliasMapping pitems)
{
try
{
if (TblAliasMapping.FetchByID(pitems.Id) != null)
{
pitems.IsNew = false;
pitems.Save();
}
}
catch (Exception ex)
{
throw ex;
}
}