public CorePODInfo Get( String USER_ID, ref string sErr) { CorePODInfo objEntr = new CorePODInfo(); connect(); InitSPCommand(_strSPGetName); AddParameter(CorePODInfo.Field.USER_ID.ToString(), USER_ID); DataTable list = new DataTable(); try { list = executeSelectSP(command); } catch (Exception ex) { sErr = ex.Message; } disconnect(); if (list.Rows.Count > 0) { objEntr = (CorePODInfo)GetDataFromDataRow(list, 0); } //if (dr != null) list = CBO.FillCollection(dr, ref list); if (sErr != "") { CoreErrorLog.SetLog(sErr); } return(objEntr); }
public DataTableCollection Get_Page(CorePODInfo 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(CorePODInfo objEntr) { connect(); InitSPCommand(_strSPUpdateName); AddParameter(CorePODInfo.Field.USER_ID.ToString(), objEntr.USER_ID); AddParameter(CorePODInfo.Field.TB.ToString(), objEntr.TB); AddParameter(CorePODInfo.Field.USER_ID1.ToString(), objEntr.USER_ID1); AddParameter(CorePODInfo.Field.USER_NAME.ToString(), objEntr.USER_NAME); AddParameter(CorePODInfo.Field.DB_DEFAULT.ToString(), objEntr.DB_DEFAULT); AddParameter(CorePODInfo.Field.LANGUAGE.ToString(), objEntr.LANGUAGE); AddParameter(CorePODInfo.Field.ROLE_ID.ToString(), objEntr.ROLE_ID); AddParameter(CorePODInfo.Field.PASS.ToString(), objEntr.PASS); string sErr = ""; try { excuteSPNonQuery(); } catch (Exception ex) { sErr = ex.Message; } disconnect(); if (sErr != "") { CoreErrorLog.SetLog(sErr); } return(sErr); }
public string InsertUpdate(CorePODInfo pODInfo) { string sErr = ""; if (IsExist(pODInfo.USER_ID)) { return(Update(pODInfo)); } else { Add(pODInfo, ref sErr); } return(sErr); }
protected override object GetDataFromDataRow(DataTable dt, int i) { CorePODInfo result = new CorePODInfo(); result.USER_ID = (dt.Rows[i][CorePODInfo.Field.USER_ID.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CorePODInfo.Field.USER_ID.ToString()])); result.TB = (dt.Rows[i][CorePODInfo.Field.TB.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CorePODInfo.Field.TB.ToString()])); result.USER_ID1 = (dt.Rows[i][CorePODInfo.Field.USER_ID1.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CorePODInfo.Field.USER_ID1.ToString()])); result.USER_NAME = (dt.Rows[i][CorePODInfo.Field.USER_NAME.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CorePODInfo.Field.USER_NAME.ToString()])); result.DB_DEFAULT = (dt.Rows[i][CorePODInfo.Field.DB_DEFAULT.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CorePODInfo.Field.DB_DEFAULT.ToString()])); result.LANGUAGE = (dt.Rows[i][CorePODInfo.Field.LANGUAGE.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CorePODInfo.Field.LANGUAGE.ToString()])); result.ROLE_ID = (dt.Rows[i][CorePODInfo.Field.ROLE_ID.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CorePODInfo.Field.ROLE_ID.ToString()])); result.PASS = (dt.Rows[i][CorePODInfo.Field.PASS.ToString()] == DBNull.Value ? "" : Convert.ToString(dt.Rows[i][CorePODInfo.Field.PASS.ToString()])); return(result); }
/// <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(CorePODInfo objEntr, ref string sErr) { int ret = -1; connect(); InitSPCommand(_strSPInsertName); AddParameter(CorePODInfo.Field.USER_ID.ToString(), objEntr.USER_ID); AddParameter(CorePODInfo.Field.TB.ToString(), objEntr.TB); AddParameter(CorePODInfo.Field.USER_ID1.ToString(), objEntr.USER_ID1); AddParameter(CorePODInfo.Field.USER_NAME.ToString(), objEntr.USER_NAME); AddParameter(CorePODInfo.Field.DB_DEFAULT.ToString(), objEntr.DB_DEFAULT); AddParameter(CorePODInfo.Field.LANGUAGE.ToString(), objEntr.LANGUAGE); AddParameter(CorePODInfo.Field.ROLE_ID.ToString(), objEntr.ROLE_ID); AddParameter(CorePODInfo.Field.PASS.ToString(), objEntr.PASS); 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); }
private string CreateWhereClause(CorePODInfo obj) { String result = ""; return(result); }
public string Update(CorePODInfo obj) { return(_CorePODDAO.Update(obj)); }
public Int32 Add(CorePODInfo obj, ref string sErr) { return(_CorePODDAO.Add(obj, ref sErr)); }