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