public bool Action(string DID, string HID, string No, string SourceFileRefName, string KeyWord,
string Type, string ExtFile, string StartRow, string EndRow, string StartColumn,
bool rowState, string UserLogin, PAction action)
{
dt = SourceFile_MappingDetailDto.Data();
dr = dt.NewRow();
dr["DID"] = DID;
dr["HID"] = HID;
dr["No"] = No;
dr["SourceFileRefName"] = SourceFileRefName;
dr["KeyWord"] = KeyWord;
dr["Type"] = Type;
dr["ExtFile"] = ExtFile;
dr["StartRow"] = StartRow;
dr["EndRow"] = EndRow;
dr["StartColumn"] = StartColumn;
dr["ROW_STATE"] = rowState ? "1" : "0";
dr["CREATE_BY"] = UserLogin;
dr["UPDATE_BY"] = UserLogin;
dt.Rows.Add(dr);
switch (action)
{
case PAction.Add: isCan = Add(); break;
case PAction.Update: isCan = Update(); break;
case PAction.Delete: isCan = Delete(); break;
}
return(isCan);
}
public override DataTable FindByColumn(object obj)
{
dt = SourceFile_MappingDetailDto.Data();
dr = dt.NewRow();
dr["HID"] = "";
return(dao.FindByColumn(dt));
}
public DataTable FindByColumn(string HID, string active)
{
dt = SourceFile_MappingDetailDto.Data();
dr = dt.NewRow();
dr["HID"] = HID;
dr["ROW_STATE"] = active;
dt.Rows.Add(dr);
return(dao.FindByColumn(dt));
}
public override DataTable FindByAll()
{
isCan = false;
DataTable dtObj = null;
try
{
DataTable dt = SourceFile_MappingDetailDto.Data();
DataRow dr = dt.NewRow();
dr["ROW_STATE"] = "1";
dt.Rows.Add(dr);
OpenConection();
dtObj = ExcecuteToDataTable("sp_SourceFile_MappingDetail_FindAll", dt);
}
catch (Exception ex)
{ throw ex; }
finally
{ CloseConnection(); }
return(dtObj);
}
