public static List <PointExchange> GetPointExchanges(string MemberNo, bool RealData) { string db = GetDB(RealData); List <PointExchange> result = new List <PointExchange>(); IConnection con = new ConnectionLocator(db).connection; using (DbConnection dbCon = con.Connect()) { try { dbCon.Open(); using (DbDataAdapter adapter = con.factory.CreateDataAdapter()) { StringBuilder sql = new StringBuilder(); sql.AppendFormat("EXEC MC_GetPointExchangesByMemberNo @MEMBER_NO='{0}'", MemberNo); adapter.SelectCommand = new CommandManager().CreateQueryCommand(dbCon, sql.ToString()); DataSet ds = new DataSet(); adapter.Fill(ds, "MC_GetPointExchangesByMemberNo"); if (ds.Tables["MC_GetPointExchangesByMemberNo"].Rows.Count > 0) { foreach (DataRow row in ds.Tables["MC_GetPointExchangesByMemberNo"].Rows) { PointExchange d = new PointExchange(); d.Id = Convert.ToString(row["ID"]);; d.RecodeDate = Convert.ToDateTime(row["RECODE_DATE"]); d.MemberNo = Convert.ToString(row["MEMBER_NO"]); d.Point = Convert.ToInt32(row["POINT"]); d.Machine = new Machine(); d.Machine.Id = Convert.ToString(row["MACHINE_ID"]); d.Machine.Name = Convert.ToString(row["MACHINE_NAME"]); d.PublishedTime = Convert.ToInt32(row["PUBLISHED_TIME"]); result.Add(d); } } } } catch { return(null); } } if (result.Count > 0) { return(result); } return(null); }
public static PointExchange GetPointExchange(string id, bool RealData) { string db = GetDB(RealData); PointExchange result = new PointExchange(); IConnection con = new ConnectionLocator(db).connection; using (DbConnection dbCon = con.Connect()) { try { dbCon.Open(); using (DbDataAdapter adapter = con.factory.CreateDataAdapter()) { StringBuilder sql = new StringBuilder(); sql.AppendFormat("EXEC MC_GET_DETAIL_POINT_EXCHANGE @ID='{0}'", id); adapter.SelectCommand = new CommandManager().CreateQueryCommand(dbCon, sql.ToString()); DataSet ds = new DataSet(); adapter.Fill(ds, "TBL_POINT_EXCHANGE"); if (ds.Tables["TBL_POINT_EXCHANGE"].Rows.Count > 0) { foreach (DataRow row in ds.Tables["TBL_POINT_EXCHANGE"].Rows) { result.Id = id; result.RecodeDate = Convert.ToDateTime(row["RECODE_DATE"]); result.PublishedTime = Convert.ToInt32(row["PUBLISHED_TIME"]); result.MemberNo = Convert.ToString(row["MEMBER_NO"]); result.Point = Convert.ToInt32(row["POINT"]); result.Machine = new Machine(); result.Machine.Id = Convert.ToString(row["MACHINE_ID"]); result.Machine.Name = Convert.ToString(row["MACHINE_NAME"]); } } } } catch { return(null); } } if ((result.MemberNo != null) && (result.MemberNo != "")) { return(result); } return(null); }
protected void btnRptPointExchangeExcel_Click(object sender, EventArgs e) { PointExchange bllGiftExchange = new PointExchange(); int Counts = this.NetPagerParameter.RecordCount; string strSql = this.QueryCondition() + " and GiftExchange.ExchangeStatus=2 and GiftExchange.MemID=Mem.MemID and GiftExchange.ExchangeUserID = SysUser.UserID and Mem.MemShopID = SysShop.ShopID"; strSql = PubFunction.GetShopAuthority(this._UserShopID, "MemShopID", strSql); DataTable dtGiftExchange = bllGiftExchange.GetListSP(100000, 1, out Counts, new string[] { strSql }).Tables[0]; DataExcelInfo.RptGiftExchangeExcel(dtGiftExchange, this._UserName); }