public DataTableCollection Get_Page(CoreQDD_FILTERInfo 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 != "") { CoreErrorLog.SetLog(sErr); } return(dtList); }
public string Update(CoreQDD_FILTERInfo objEntr) { connect(); InitSPCommand(_strSPUpdateName); AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), objEntr.DTB); AddParameter(CoreQDD_FILTERInfo.Field.QD_ID.ToString(), objEntr.QD_ID); AddParameter(CoreQDD_FILTERInfo.Field.QDD_ID.ToString(), objEntr.QDD_ID); AddParameter(CoreQDD_FILTERInfo.Field.OPERATOR.ToString(), objEntr.OPERATOR); AddParameter(CoreQDD_FILTERInfo.Field.IS_NOT.ToString(), objEntr.IS_NOT); string sErr = ""; try { excuteSPNonQuery(); } catch (Exception ex) { sErr = ex.Message; } disconnect(); if (sErr != "") { CoreErrorLog.SetLog(sErr); } return(sErr); }
public CoreQDD_FILTERInfo(CoreQDD_FILTERInfo objEntr) { _DTB = objEntr.DTB; _QD_ID = objEntr.QD_ID; _QDD_ID = objEntr.QDD_ID; _OPERATOR = objEntr.OPERATOR; _IS_NOT = objEntr.IS_NOT; }
protected override object GetDataFromDataRow(DataTable dt, int i) { CoreQDD_FILTERInfo result = new CoreQDD_FILTERInfo(); result.DTB = (dt.Rows[i][CoreQDD_FILTERInfo.Field.DTB.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CoreQDD_FILTERInfo.Field.DTB.ToString()])); result.QD_ID = (dt.Rows[i][CoreQDD_FILTERInfo.Field.QD_ID.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CoreQDD_FILTERInfo.Field.QD_ID.ToString()])); result.QDD_ID = (dt.Rows[i][CoreQDD_FILTERInfo.Field.QDD_ID.ToString()] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[i][CoreQDD_FILTERInfo.Field.QDD_ID.ToString()])); result.OPERATOR = (dt.Rows[i][CoreQDD_FILTERInfo.Field.OPERATOR.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CoreQDD_FILTERInfo.Field.OPERATOR.ToString()])); result.IS_NOT = (dt.Rows[i][CoreQDD_FILTERInfo.Field.IS_NOT.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CoreQDD_FILTERInfo.Field.IS_NOT.ToString()])); return(result); }
public string InsertUpdate(CoreQDD_FILTERInfo obj) { string sErr = ""; if (IsExist( obj.DTB, obj.QD_ID, obj.QDD_ID )) { sErr = Update(obj); } else { Add(obj, ref sErr); } return(sErr); }
public CoreQDD_FILTERInfo Get( String DTB, String QD_ID, Int32 QDD_ID, ref string sErr) { CoreQDD_FILTERInfo objEntr = new CoreQDD_FILTERInfo(); connect(); InitSPCommand(_strSPGetName); AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), DTB); AddParameter(CoreQDD_FILTERInfo.Field.QD_ID.ToString(), QD_ID); AddParameter(CoreQDD_FILTERInfo.Field.QDD_ID.ToString(), QDD_ID); DataTable list = new DataTable(); try { list = executeSelectSP(command); } catch (Exception ex) { sErr = ex.Message; } disconnect(); if (list.Rows.Count > 0) { objEntr = (CoreQDD_FILTERInfo)GetDataFromDataRow(list, 0); } //if (dr != null) list = CBO.FillCollection(dr, ref list); if (sErr != "") { CoreErrorLog.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(CoreQDD_FILTERInfo objEntr, ref string sErr) { int ret = -1; connect(); InitSPCommand(_strSPInsertName); AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), objEntr.DTB); AddParameter(CoreQDD_FILTERInfo.Field.QD_ID.ToString(), objEntr.QD_ID); AddParameter(CoreQDD_FILTERInfo.Field.QDD_ID.ToString(), objEntr.QDD_ID); AddParameter(CoreQDD_FILTERInfo.Field.OPERATOR.ToString(), objEntr.OPERATOR); AddParameter(CoreQDD_FILTERInfo.Field.IS_NOT.ToString(), objEntr.IS_NOT); 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 != "") { CoreErrorLog.SetLog(sErr); } return(ret); }
public DataTableCollection Get_Page(CoreQDD_FILTERInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr) { return(_objDAO.Get_Page(obj, orderBy, pageIndex, pageSize, ref sErr)); }
public string Update(CoreQDD_FILTERInfo obj) { return(_objDAO.Update(obj)); }
public Int32 Add(CoreQDD_FILTERInfo obj, ref string sErr) { return(_objDAO.Add(obj, ref sErr)); }
public string TransferIn(DataRow row) { CoreQDD_FILTERInfo inf = new CoreQDD_FILTERInfo(row); return(InsertUpdate(inf)); }
public DataTable ToTransferInStruct() { return(CoreQDD_FILTERInfo.ToDataTable()); }
private string CreateWhereClause(CoreQDD_FILTERInfo obj) { String result = ""; return(result); }