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()); }