public DataTableCollection Get_Page(LIST_TASKInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr)
{
string whereClause = CreateWhereClause(obj);
DataTableCollection dtList = null;
connect();
InitSPCommand(_strSPGetPages);
AddParameter("WhereClause", whereClause);
AddParameter("OrderBy", orderBy);
AddParameter("PageIndex", pageIndex);
AddParameter("PageSize", pageSize);
try
{
dtList = executeCollectSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(dtList);
}
public LIST_TASKInfo Get(
String DTB,
String Code,
ref string sErr)
{
LIST_TASKInfo objEntr = new LIST_TASKInfo();
connect();
InitSPCommand(_strSPGetName);
AddParameter(LIST_TASKInfo.Field.DTB.ToString(), DTB);
AddParameter(LIST_TASKInfo.Field.Code.ToString(), Code);
DataTable list = new DataTable();
try
{
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (list.Rows.Count > 0)
{
objEntr = (LIST_TASKInfo)GetDataFromDataRow(list, 0);
}
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(objEntr);
}
/// <summary>
/// Return 1: Table is exist Identity Field
/// Return 0: Table is not exist Identity Field
/// Return -1: Erro
/// </summary>
/// <param name="tableName"></param>
public Int32 Add(LIST_TASKInfo objEntr, ref string sErr)
{
int ret = -1;
connect();
InitSPCommand(_strSPInsertName);
AddParameter(LIST_TASKInfo.Field.DTB.ToString(), objEntr.DTB);
AddParameter(LIST_TASKInfo.Field.Code.ToString(), objEntr.Code);
AddParameter(LIST_TASKInfo.Field.Description.ToString(), objEntr.Description);
AddParameter(LIST_TASKInfo.Field.Lookup.ToString(), objEntr.Lookup);
AddParameter(LIST_TASKInfo.Field.AttQD_ID.ToString(), objEntr.AttQD_ID);
AddParameter(LIST_TASKInfo.Field.AttTmp.ToString(), objEntr.AttTmp);
AddParameter(LIST_TASKInfo.Field.ValidRange.ToString(), objEntr.ValidRange);
AddParameter(LIST_TASKInfo.Field.CntQD_ID.ToString(), objEntr.CntQD_ID);
AddParameter(LIST_TASKInfo.Field.CntTmp.ToString(), objEntr.CntTmp);
AddParameter(LIST_TASKInfo.Field.Emails.ToString(), objEntr.Emails);
AddParameter(LIST_TASKInfo.Field.Server.ToString(), objEntr.Server);
AddParameter(LIST_TASKInfo.Field.Protocol.ToString(), objEntr.Protocol);
AddParameter(LIST_TASKInfo.Field.Port.ToString(), objEntr.Port);
AddParameter(LIST_TASKInfo.Field.UserID.ToString(), objEntr.UserID);
AddParameter(LIST_TASKInfo.Field.Password.ToString(), objEntr.Password);
AddParameter(LIST_TASKInfo.Field.Type.ToString(), objEntr.Type);
AddParameter(LIST_TASKInfo.Field.IsUse.ToString(), objEntr.IsUse);
try
{
//command.ExecuteNonQuery();
object tmp = executeSPScalar();
if (tmp != null && tmp != DBNull.Value)
{
ret = Convert.ToInt32(tmp);
}
else
{
ret = 0;
}
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(ret);
}
public string InsertUpdate(LIST_TASKInfo obj)
{
string sErr = "";
if (IsExist(
obj.DTB,
obj.Code
))
{
sErr = Update(obj);
}
else
{
Add(obj, ref sErr);
}
return(sErr);
}
public string Update(LIST_TASKInfo objEntr)
{
connect();
InitSPCommand(_strSPUpdateName);
AddParameter(LIST_TASKInfo.Field.DTB.ToString(), objEntr.DTB);
AddParameter(LIST_TASKInfo.Field.Code.ToString(), objEntr.Code);
AddParameter(LIST_TASKInfo.Field.Description.ToString(), objEntr.Description);
AddParameter(LIST_TASKInfo.Field.Lookup.ToString(), objEntr.Lookup);
AddParameter(LIST_TASKInfo.Field.AttQD_ID.ToString(), objEntr.AttQD_ID);
AddParameter(LIST_TASKInfo.Field.AttTmp.ToString(), objEntr.AttTmp);
AddParameter(LIST_TASKInfo.Field.ValidRange.ToString(), objEntr.ValidRange);
AddParameter(LIST_TASKInfo.Field.CntQD_ID.ToString(), objEntr.CntQD_ID);
AddParameter(LIST_TASKInfo.Field.CntTmp.ToString(), objEntr.CntTmp);
AddParameter(LIST_TASKInfo.Field.Emails.ToString(), objEntr.Emails);
AddParameter(LIST_TASKInfo.Field.Server.ToString(), objEntr.Server);
AddParameter(LIST_TASKInfo.Field.Protocol.ToString(), objEntr.Protocol);
AddParameter(LIST_TASKInfo.Field.Port.ToString(), objEntr.Port);
AddParameter(LIST_TASKInfo.Field.UserID.ToString(), objEntr.UserID);
AddParameter(LIST_TASKInfo.Field.Password.ToString(), objEntr.Password);
AddParameter(LIST_TASKInfo.Field.Type.ToString(), objEntr.Type);
AddParameter(LIST_TASKInfo.Field.IsUse.ToString(), objEntr.IsUse);
string sErr = "";
try
{
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(sErr);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
LIST_TASKInfo result = new LIST_TASKInfo();
result.DTB = (dt.Rows[i][LIST_TASKInfo.Field.DTB.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.DTB.ToString()]));
result.Code = (dt.Rows[i][LIST_TASKInfo.Field.Code.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Code.ToString()]));
result.Description = (dt.Rows[i][LIST_TASKInfo.Field.Description.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Description.ToString()]));
result.Lookup = (dt.Rows[i][LIST_TASKInfo.Field.Lookup.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Lookup.ToString()]));
result.AttQD_ID = (dt.Rows[i][LIST_TASKInfo.Field.AttQD_ID.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.AttQD_ID.ToString()]));
result.AttTmp = (dt.Rows[i][LIST_TASKInfo.Field.AttTmp.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.AttTmp.ToString()]));
result.ValidRange = (dt.Rows[i][LIST_TASKInfo.Field.ValidRange.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.ValidRange.ToString()]));
result.CntQD_ID = (dt.Rows[i][LIST_TASKInfo.Field.CntQD_ID.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.CntQD_ID.ToString()]));
result.CntTmp = (dt.Rows[i][LIST_TASKInfo.Field.CntTmp.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.CntTmp.ToString()]));
result.Emails = (dt.Rows[i][LIST_TASKInfo.Field.Emails.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Emails.ToString()]));
result.Server = (dt.Rows[i][LIST_TASKInfo.Field.Server.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Server.ToString()]));
result.Protocol = (dt.Rows[i][LIST_TASKInfo.Field.Protocol.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Protocol.ToString()]));
result.Port = (dt.Rows[i][LIST_TASKInfo.Field.Port.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Port.ToString()]));
result.UserID = (dt.Rows[i][LIST_TASKInfo.Field.UserID.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.UserID.ToString()]));
result.Password = (dt.Rows[i][LIST_TASKInfo.Field.Password.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Password.ToString()]));
result.Type = (dt.Rows[i][LIST_TASKInfo.Field.Type.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.Type.ToString()]));
result.IsUse = (dt.Rows[i][LIST_TASKInfo.Field.IsUse.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][LIST_TASKInfo.Field.IsUse.ToString()]));
return(result);
}
private string CreateWhereClause(LIST_TASKInfo obj)
{
String result = "";
return(result);
}
public DataTableCollection Get_Page(LIST_TASKInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr)
{
return(_objDAO.Get_Page(obj, orderBy, pageIndex, pageSize, ref sErr));
}
public string Update(LIST_TASKInfo obj)
{
return(_objDAO.Update(obj));
}
public Int32 Add(LIST_TASKInfo obj, ref string sErr)
{
return(_objDAO.Add(obj, ref sErr));
}
public string TransferIn(DataRow row)
{
LIST_TASKInfo inf = new LIST_TASKInfo(row);
return(InsertUpdate(inf));
}
public DataTable ToTransferInStruct()
{
return(LIST_TASKInfo.ToDataTable());
}
