public RecordInfo getRecordsInfo(String difficulty, Context context)
{
dbHelper = new DBHelper(context);
SQLiteDatabase db = dbHelper.WritableDatabase;
SQLiteCursor gc = (SQLiteCursor)db.Query("general", null, "difficulty = ?", new String[]{difficulty}, null, null, null);
int avgTimeColIndex = gc.GetColumnIndex("avgTime");
int gamesCountColIndex = gc.GetColumnIndex("gamesCount");
int avgTime = 0;
int gamesCount = 0;
if (gc.MoveToFirst()){
avgTime = gc.GetInt(avgTimeColIndex);
gamesCount = gc.GetInt(gamesCountColIndex);
}
RecordInfo result = new RecordInfo(avgTime, gamesCount, new Java.Lang.String(difficulty));
SQLiteCursor c = (SQLiteCursor)db.Query("records", null, " difficulty = ?", new String[]{difficulty}, null, null, null);
if (c.MoveToFirst()) {
int timeColIndex = c.GetColumnIndex("time");
result.addRecord(c.GetInt(timeColIndex));
while (c.MoveToNext()) {
result.addRecord(c.GetInt(timeColIndex));
}
}
return result;
}
public void clearDB(Context context)
{
dbHelper = new DBHelper(context);
SQLiteDatabase db = dbHelper.WritableDatabase;
db.Delete("general", null, null);
db.Delete("records", null, null);
}
public ListHitViewer()
{
InitializeComponent();
db = new DBHelper();
//load up the app bar
ApplicationBar = new ApplicationBar();
ApplicationBar.Mode = ApplicationBarMode.Minimized;
ApplicationBar.Opacity = 1.0;
ApplicationBar.IsVisible = true;
ApplicationBar.IsMenuEnabled = true;
//get the item from the phone state! woo!
if (PhoneApplicationService.Current.State.ContainsKey("CurrentItem") && PhoneApplicationService.Current.State["CurrentItem"] != null)
{
_item = PhoneApplicationService.Current.State["CurrentItem"] as OldItem;
//only show share if the _item is not null
ApplicationBarIconButton btnShareAppBar = new ApplicationBarIconButton();
btnShareAppBar.IconUri = new Uri("/Assets/AppBarIcons/share.png", UriKind.Relative);
btnShareAppBar.Text = "Tap To Share";
ApplicationBar.Buttons.Add(btnShareAppBar);
btnShareAppBar.Click += new EventHandler(btnShareAppBar_Click);
}
//feedback button
ApplicationBarIconButton btnFeedbackAppBar = new ApplicationBarIconButton();
btnFeedbackAppBar.IconUri = new Uri("/Assets/AppBarIcons/questionmark.png", UriKind.Relative);
btnFeedbackAppBar.Text = "Feedback";
ApplicationBar.Buttons.Add(btnFeedbackAppBar);
btnFeedbackAppBar.Click += new EventHandler(btnFeedbackAppBar_Click);
}
protected void Page_Load(object sender, EventArgs e)
{
#region 标签信息
string strTagInfo = "";
try
{
string sql = "select * from [tb_tag] where tag_ispublic=1";
DataTable dt = new DataTable();
DBHelper dbh = new DBHelper(config.DBConn);
dt = dbh.ExecuteDataTable("", sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
strTagInfo += "<a href=\"default.aspx?id=" + dt.Rows[i]["tag_id"].ToString() + "\" class=\"tag\" target=\"_blank\">" + dt.Rows[i]["tag_name"].ToString() + "</a>";
}
}
dbh.Dispose();
dt.Dispose();
}
catch (Exception ex)
{
strTagInfo = ex.ToString();
}
this.tagBall.InnerHtml = strTagInfo;
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (string.IsNullOrWhiteSpace(Request.QueryString["Exhibition"])) return;
string strExhibitionId = Request.QueryString["Exhibition"];
DBHelper objHelper = new DBHelper();
General objGen = new General();
string strSQL = @"SELECT EXHIBITION_NAME,
EXHIBITION_DETAILS,
EXHIBITON_TEXT,
EXHIBITION_IMAGE
FROM INSTA_MST_EXHIBITION
WHERE EXHIBITION_ID =" + objGen.gReplaceQuotes(strExhibitionId);
IDataReader reader = objHelper.gExecuteReader(CommandType.Text, strSQL);
while (reader.Read())
{
img.Src = "../../upload/images/Exhibition/" + Convert.ToString(reader["EXHIBITION_IMAGE"]);
ltHeading.Text = Convert.ToString(reader["EXHIBITION_NAME"]) + Convert.ToString(reader["EXHIBITION_DETAILS"]);
ltDetail.Text = Convert.ToString(reader["EXHIBITON_TEXT"]);
}
reader.Close();
reader.Dispose();
}
}
DBHelper helper; // 和数据库打交道
public AddBudget(string name)
{
InitializeComponent();
currentUser = name;
helper = new DBHelper();
initialize();
}
public void QueryTest()
{
// Arrange-测试设置,创建对象
DBHelper db = new DBHelper();
Customer customer = new Customer()
{
UserName = "******",
Password = "******",
Email = "EMAIL-1 ",
PhoneNumber = "PHONE-1 ",
IsFirstTimeLogin = false,
AccessFailedCount = 0,
CreationDate = DateTime.Now,
IsActive = false
};
int count = 0;
List<Customer> customerList = new List<Customer>();
// 拼接字符串的时候要注意标量的名字要与类中的成员变量名一样（可忽略字母的大小写）
// 例如：此处sql中的@Password中的Password就必须与Customer类中的成员变量Password名称一样（可忽略大小写）
string querySQL = @"SELECT * FROM dbo.CICUser WHERE UserName=@UserName AND PasswordHash=@Password";
// Act-测试行为,使用功能
customerList = db.Query<Customer>(querySQL, customer).ToList();
count = customerList.Count;
// Assert-测试结果,验证结果
Assert.AreEqual(1,count);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Url.Host.ToLower() == "localhost")
{
//base.login_user_id = 40123; //user
//base.login_user_id = 40110; //exec producer -- skip
//base.login_user_id = 272; //producer -- elyse
//base.login_user_id = 205; //coordinator
base.login_user_id = 144; //administrator -- randy
theader.Visible = false;
aheader.Visible = false;
levaNav.Visible = false;
tfooter.Visible = false;
levbNav.Visible = false;
groupTest = this.TestGroupMembership;
}
else
{
base.Page_Load("/newallocations/LockAllocations.aspx");
groupTest = base.testmembership;
}
DBHelper db = new DBHelper();
if (!groupTest.Invoke(ref db, "A3Coordinator") && !groupTest.Invoke(ref db, "A2Administrator"))
Response.Redirect("/permitError.html");
int week_num = RGA.Allocations.Data.Utility.CurrectWeek() + 1;
WeekNumber.Value = week_num.ToString();
Week.Text = RGA.Allocations.Data.Utility.CurrectWeekStartDate(week_num).ToString("MM/dd/yy");
}
public List<string> GetUserID(string mode, string user_id)
{
List<string> lst = new List<string>();
DBHelper helper = new DBHelper();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter(CONSTANT.MODE, mode);
param[1] = new SqlParameter(CONSTANT.USER_ID, user_id);
DataSet ds = helper.executeSelectQuery(PROCEDURES.DELETE_USER_OPERTAION, param);
if (ds != null)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
lst.Add(item[0].ToString());
}
}
return lst;
}
//const double AllowRange = 0.5;
public static HoborModel HoborAsker(DBHelper DBHelper, double XAxis, double YAxis)
{
HoborModel result=new HoborModel();
double AllowRange = GetConfig.GetAllowRange();
double xAxisAbove = XAxis + AllowRange
, xAxisBelow = XAxis - AllowRange
, yAxisAbove = YAxis + AllowRange
, yAxisBelow = YAxis - AllowRange;
string commandText = "SELECT * FROM Hobor WHERE XAxis BETWEEN @XAxis1 AND @XAxis2 AND YAxis Between @YXias1 AND @YXias2";
System.Data.DataTable dt = DBHelper.GetData(commandText, new List<Parameter>()
{
new Parameter("@XAxis1",xAxisBelow)
,new Parameter("@XAxis2",xAxisAbove)
,new Parameter("@YXias1",yAxisBelow)
,new Parameter("@YXias2", yAxisAbove)
});
if (dt != null && dt.Rows.Count > 0)
{
result.IsExist = true;
result.CountryName = dt.Rows[0]["CountryName"].ToString();
result.Name = dt.Rows[0]["Name"].ToString();
result.XAxis = Common.ConvertToDouble(dt.Rows[0]["XAxis"]);
result.YAxis = Common.ConvertToDouble(dt.Rows[0]["YAxis"]);
result.Info = dt.Rows[0]["Info"].ToString();
}
return result;
}
internal DateTime[] GetYourDates(DBHelper db_, TZ tz_)
{
string tableName = "eventTimesGMT";
switch (tz_)
{
case TZ.HK: tableName = "eventTimesHK"; break;
case TZ.LN: tableName = "eventTimesLN"; break;
case TZ.NY: tableName = "eventTimesNY"; break;
case TZ.GMT: tableName = "eventTimesGMT"; break;
}
var sql = string.Format("select eventTimeLocal from {1} where eventID={0} order by eventTimeGMT", EventID, tableName);
var ds = db_.Execute(sql);
if (DBHelper.HasData(ds))
{
var list = new List<DateTime>();
foreach (DataRow row in ds.Tables[0].Rows)
list.Add((DateTime)row[0]);
return list.ToArray();
}
return null;
}
public ImportItem(IProject project, DBHelper dbHelper)
{
this._TheProject = project;
this.DBHelper = dbHelper;
this.TheProject.TargetDateChanged += this.OnDateChanged;
}
protected void Page_Load(object sender, EventArgs e)
{
IsInGroup groupTest = null;
if (Request.Url.Host.ToLower() == "localhost")
{
//base.login_user_id = _UserId = 40123; //user
//base.login_user_id = _UserId = 40110; //exec producer -- skip
//base.login_user_id = _UserId = 272; //producer -- elyse
//base.login_user_id = _UserId = 205; //coordinator
base.login_user_id = _UserId = 144; //administrator -- randy
theader.Visible = false;
aheader.Visible = false;
levaNav.Visible = false;
tfooter.Visible = false;
levbNav.Visible = false;
groupTest = TestGroupMembership;
}
else
{
base.Page_Load("/newallocations/TeamAllocation.aspx");
_UserId = base.login_user_id;
groupTest = base.testmembership;
}
// determine if the user's group and set a variable to use when printing out allocations
DBHelper db = new DBHelper();
if (groupTest.Invoke(ref db, "A3Coordinator"))
_secType = RgaWeb.SecurityType.EditAll;
if (groupTest.Invoke(ref db, "A2Administrator"))
_secType = RgaWeb.SecurityType.EditAll;
if (groupTest.Invoke(ref db, "A8Producer"))
_secType = RgaWeb.SecurityType.EditUpcoming;
if (groupTest.Invoke(ref db, "A5ExecProducer"))
_secType = RgaWeb.SecurityType.EditUpcoming;
if (!Page.IsPostBack)
{
LoadRegions();
LoadDepartments();
// retrieve current week and date
_StartWeek = RgaData.Utility.CurrectWeek();
_StartDate = RgaData.Utility.CurrectWeekStartDate(_StartWeek);
// setup week picker
ctlWeekPicker.CurrentWeek = _StartWeek;
ctlWeekPicker.CurrectWeekStartDate = _StartDate;
}
else
{
// set start week
_StartWeek = ctlWeekPicker.CurrentWeek;
}
// set up delegate to rebind the grid when week selection is changed
DelSelectWeek delSelectWeek = new DelSelectWeek(this.ctlWeekPicker_SelectedIndexChanged);
ctlWeekPicker.UpdateCurrentWeek = delSelectWeek;
}
public bool Test()
{
SqlParameter[] param = new SqlParameter[1];
DBHelper helper = new DBHelper();
param[0] = new SqlParameter(CONSTANT.CAT_ID, "ZCVV");
bool ds = helper.InsertQuery(PROCEDURES.CAT_INSERT, param);
return ds;
}
public void putRecord(long time, String difficulty, Context context)
{
dbHelper = new DBHelper(context);
ContentValues cv = new ContentValues();
SQLiteDatabase db = dbHelper.WritableDatabase;
SQLiteCursor c = (SQLiteCursor)db.Query("records", null, " difficulty = ?", new String[]{difficulty}, null, null, null);
int count = 1;
if (c.MoveToFirst()) {
int idColIndex = c.GetColumnIndex("id");
int timeColIndex = c.GetColumnIndex("time");
int maxDBindex = c.GetInt(idColIndex);
int maxDBtime = c.GetInt(timeColIndex);
count++;
while (c.MoveToNext()) {
if (c.GetInt(timeColIndex) > maxDBtime){
maxDBtime = c.GetInt(timeColIndex);
maxDBindex = c.GetInt(idColIndex);
}
count++;
}
if (count == 6){
if (time < maxDBtime){
db.Delete("records", " id = ?", new String[]{maxDBindex + ""});
} else {
c.Close();
db.Close();
return;
}
}
}
cv.Put("time", time);
cv.Put("difficulty", difficulty);
db.Insert("records", null, cv);
cv.Clear();
SQLiteCursor gc = (SQLiteCursor)db.Query("general", null, "difficulty = ?", new String[]{difficulty}, null, null, null);
gc.MoveToFirst();
int avgTimeColIndex = gc.GetColumnIndex("avgTime");
int gamesCountColIndex = gc.GetColumnIndex("gamesCount");
int avgTime = 0;
int gamesCount = 0;
if (gc.MoveToFirst()){
avgTime = gc.GetInt(avgTimeColIndex);
gamesCount = gc.GetInt(gamesCountColIndex);
}
int newGamesCount = gamesCount + 1;
int newAvgTime = (avgTime * gamesCount / newGamesCount) + (int)(time / newGamesCount);
cv.Put("difficulty", difficulty);
cv.Put("avgTime", newAvgTime);
cv.Put("gamesCount", newGamesCount);
db.Delete("general", " difficulty = ?", new String[]{difficulty});
db.Insert("general", null, cv);
db.Close();
c.Close();
gc.Close();
}
public frmCMS()
{
InitializeComponent();
this.DBHelper = new DBHelper(new DBHelperConnection(this.ConnectionString ,this.FactoryName ));
this.cmbApp.DataSource = this.DBHelper.GetDataSet("SELECT * FROM VOD_APP ORDER BY APP_CODE", "VOD_APP").Tables[0];
this.cmbApp.DisplayMember = "APP_NAME";
this.cmbApp.ValueMember = "APP_CODE";
this.LoadList();
}
/// <summary>
/// ����Ĭ�ϵ����ݿ������
/// </summary>
/// <returns></returns>
public static DBHelper Instance()
{
if (helper == null)
{
helper = new DBHelper(connectionString, dbProviderName);
return helper;
}
return helper;
}
public int deleteProduct(string product_id)
{
DBHelper helper = new DBHelper();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter(CONSTANT.PRODUCT_ID, product_id);
int res = helper.InsertQuery(PROCEDURES.DELETE_PRODUCT, param);
return res;
}
public void QueryAllTest()
{
// arrange
DBHelper db = new DBHelper();
var list = db.QueryAll<DealerServiceLog>().ToList();
// act
int count = list.Count;
// assert
Assert.AreEqual(4, count);
}
public ActionResult Create_Essay(Essay model,AccountLogin user)
{
DBHelper tmpDBHelper = new DBHelper();
var title = model.Title;
var content = model.Content;
var userID = Session["UserId"].ToString();
tmpDBHelper.SqlExcute("insert into Essay(UserId,EssayTitle,EssayContent) values('"+userID+"','"+title+"','"+content+"')");
return Redirect("../Home/Index");
}
public int deleteSubCategory(int id)
{
DBHelper helper = new DBHelper();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter(CONSTANT.SUB_CATEGORY_ID, id);
int res = helper.InsertQuery(PROCEDURES.DELETE_SUB_CATEGORY, param);
return res;
}
protected override void ResetStore()
{
var db = new DBHelper(DbProviderFactories.GetFactory("MySql.Data.MySqlClient"), ConnectionString);
var store = (MySqlStore)Store;
var a = store.EventsTable;
var b = store.ProjectionIndexTable;
var c = store.ProjectionCheckpointTable;
db.ExecuteNonQuery($"TRUNCATE TABLE `{a}`; TRUNCATE TABLE `{b}`; TRUNCATE TABLE `{c}`;");
}
protected override void ResetStore()
{
var db = new DBHelper(DbProviderFactories.GetFactory("System.Data.SQLite"), ConnectionString);
var store = (SQLiteStore)Store;
var a = store.EventsTable;
var b = store.ProjectionIndexTable;
var c = store.ProjectionCheckpointTable;
db.ExecuteNonQuery($"DELETE FROM {a}; DELETE FROM SQLITE_SEQUENCE WHERE NAME='{a}'; DELETE FROM {b}; DELETE FROM SQLITE_SEQUENCE WHERE NAME='{b}'; DELETE FROM {c}; DELETE FROM SQLITE_SEQUENCE WHERE NAME='{c}';");
}
protected override void ResetStore()
{
var db = new DBHelper(SqlClientFactory.Instance, ConnectionString);
var store = (BaseSqlStore)Store;
var a = store.EventsTable;
var b = store.ProjectionIndexTable;
var c = store.ProjectionCheckpointTable;
db.ExecuteNonQuery($"TRUNCATE TABLE [{a}]; TRUNCATE TABLE [{b}]; TRUNCATE TABLE [{c}];");
}
public static string GetEventDatesAsXml(EventGroup eg_, TZ tz_, DateTime minDate_, DateTime maxDate_)
{
DateTime[] dates = null;
using (var db = new DBHelper())
{
dates = eg_.GetYourDates(db, tz_);
}
return dates == null ? null : dates
.Where(x=>x >=minDate_ && x<=maxDate_)
.Select(x => new { Date = x.ToString("dd-MMM-yyyy HH:mm:ss") }).ToGenericTableXml();
}
// 初始化工作
public void initialize()
{
common = new Entity.Commons(currentUser);
helper = new DBHelper();
inout.DisplayMemberPath = "Name";
inout.SelectedValuePath = "Id";
inout.ItemsSource = common.InOutList;
acctype.DisplayMemberPath = "TypeName";
acctype.SelectedValuePath = "Id";
acctype.ItemsSource = common.AccountTypeList;
}
public FinanceViewModel()
{
if (_db == null)
{
Assembly assem = Assembly.GetExecutingAssembly();
_db = new DBHelper(assem.FullName.Substring(0, assem.FullName.IndexOf(",")), DBHelper.DatabaseName);
} // if
if (!isTestInserted)
{
_db.InsertTestValues();
isTestInserted = true;
} // if
}
protected void Page_Load(object sender, EventArgs e)
{
IsInGroup groupTest = null;
if (Request.Url.Host.ToLower() == "localhost")
{
//base.login_user_id = _UserId = 40123; //user
//base.login_user_id = _UserId = 40110; //exec producer -- skip
//base.login_user_id = _UserId = 272; //producer -- elyse
//base.login_user_id = _UserId = 205; //coordinator
base.login_user_id = _UserId = 144; //administrator -- randy
theader.Visible = false;
aheader.Visible = false;
levaNav.Visible = false;
tfooter.Visible = false;
levbNav.Visible = false;
groupTest = TestGroupMembership;
}
else
{
base.Page_Load("/newallocations/DeptAllocation.aspx");
_UserId = base.login_user_id;
groupTest = base.testmembership;
}
// determine if the user's group and set a variable to use when printing out allocations
DBHelper db = new DBHelper();
if (groupTest.Invoke(ref db, "A3Coordinator"))
_secType = RgaWeb.SecurityType.EditAll;
if (groupTest.Invoke(ref db, "A2Administrator"))
_secType = RgaWeb.SecurityType.EditAll;
if (!Page.IsPostBack)
{
// retrieve current week and date
_WeekNumber = RgaData.Utility.CurrectWeek();
_StartDate = RgaData.Utility.CurrectWeekStartDate(_WeekNumber);
// setup week picker
WeekPicker1.CurrentWeek = _WeekNumber;
WeekPicker1.CurrectWeekStartDate = _StartDate;
WeekNumber.Value = _WeekNumber.ToString();
}
WeekPicker1.WeekSpan = 1;
WeekPicker1.ShowEndDate = false;
DelSelectWeek delSelectWeek = new DelSelectWeek(this.WeekPicker1_SelectedIndexChanged);
WeekPicker1.UpdateCurrentWeek = delSelectWeek;
}
public void QueryManyTest()
{
// arrange
DBHelper db = new DBHelper();
string sql = "select CompanyName,CityId,CityName,Balance,Margin,PreDeposits,DealerClass,Partner_CompanyExtent.Score,OrderAmount,ContractAmount,Partner_CompanyExtent.[Status],SolutionIDs,DealerDistrict from Partner_Company,Partner_CompanyExtent where Partner_CompanyExtent.DealerID=Partner_Company.ID";
sql = "SELECT * FROM DealerClassConfig AS D JOIN DealerClassConfig AS D1 ON D.id = D1.ID ";
var list = db.Query(sql).ToList();
// act
int count = list.Count;
var first = (IDictionary<string, object>)list.FirstOrDefault();
// assert
Assert.AreEqual(3, count);
}
public string getUserDetais()
{
DBHelper helper = new DBHelper();
DataTable dt = helper.executeSelectQuery(PROCEDURES.GET_USER_DETAIS).Tables[0];
if (dt != null)
{
return (JSONConvertor.getJSONData(dt));
}
else
{
return null;
}
}
public bool Insert(Answers a)
{
a.Id = DBHelper <Answers> .GetMaxId(tableName, "id");
return(DBHelper <Answers> .Insert(tableName, DBHelper <Answers> .GetSim(a)) > 0);
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="DB">DBHelper的实例</param>
public FOUNDERPCB_FRIGHTE_03BLL(DBHelper DB)
{
founderpcb_frighte_03Dal = new FOUNDERPCB_FRIGHTE_03DAL(DB);
}
public AdminController()
: base()
{
ViewBag.CurrentTab = "Administration";
ViewBag.HideMail = DBHelper.GetAbstractCourseHideMailValue(ActiveCourseUser.AbstractCourseID);
}
protected void chk_CheckedChanged(object sender, EventArgs e)
{
RadioButton rdTrip = (RadioButton)sender;
if (rdTrip.Checked)
{
pageName = Utils.GetParameter("page", "home");
cid = Utils.GetParameter("cid", string.Empty);
cidsub = Utils.GetParameter("cidsub", string.Empty);
id = Utils.GetParameter("id", string.Empty);
//string cateName = Common.UtilityLocal.GetCateNameByLevel(pageName, cid, cidsub, id);
string chkID = Utils.RemoveUnicode(rdTrip.Text).ToLower();
string level = id != string.Empty ? "3" : Session["level"].ToString();
Dictionary <string, object> dic = Common.UtilityLocal.GetProductCategory(pageName, cid, cidsub, string.Empty, LangInt, level);
if (dic != null && dic.Count > 0)
{
IList <PNK_ProductCategory> lst = dic["DictProductCategory"] as IList <PNK_ProductCategory>;
if (lst.Count > 0)
{
//lst là danh sách category đến cấp hiện tại, nhưng khi click chk cần lấy hết cấp con của cấp hiện tại
ProductCategoryBLL pcBllCate = new ProductCategoryBLL();
IList <PNK_ProductCategory> lst1 = pcBllCate.GetList(LangInt, string.Empty, string.Empty, lst[0].Id, true, "p.ordering", 1, 1000, out total);
IList <PNK_ProductCategory> lst2 = lst1.Where(m => m.ProductCategoryDesc.NameUrl == chkID).ToList();
//Gen html image category
ltrHeaderCategory.Text = lst2.Count > 0 ? Common.UtilityLocal.ImagePathByFont(lst2[0]) : string.Empty;
categoryID = lst2.Count > 0 ? lst2[0].Id.ToString() : string.Empty;
//Get product by categoryID when checked
if (categoryID != string.Empty)
{
DataTable dtb = DBHelper.ExcuteFromCmd("SELECT * FROM dbo.fc_GetAllChildProductCategory(" + categoryID + ",1)", null);
string[] array = dtb.AsEnumerable()
.Select(row => row.Field <Int32>("id").ToString())
.ToArray();
string idFirst = string.Join(",", array);
total = 0;
ProductBLL pcBll = new ProductBLL();
IList <PNK_Product> lstProduct = pcBll.GetList(LangInt, string.Empty, "1", idFirst, string.Empty, currentPageIndex, DBConvert.ParseInt(ConfigurationManager.AppSettings["pageSizeCate"]), out total);
this.records = DBConvert.ParseString(total);
this.pager.PageSize = DBConvert.ParseInt(ConfigurationManager.AppSettings["pageSizeCate"]);
this.pager.ItemCount = total;
this.rptResult.DataSource = lstProduct;
this.rptResult.DataBind();
WebUtils.SeoPage(lst2[0].ProductCategoryDesc.MetaTitle, lst2[0].ProductCategoryDesc.MetaDecription, lst2[0].ProductCategoryDesc.MetaKeyword, this.Page);
}
else
{
this.records = DBConvert.ParseString(total);
this.pager.PageSize = DBConvert.ParseInt(ConfigurationManager.AppSettings["pageSizeCate"]);
this.pager.ItemCount = total;
this.rptResult.DataSource = lst2;
this.rptResult.DataBind();
}
}
}
}
}
public List <Answers> GetAnswerByQuestionId(int id, int pageSize, int pageNum, out int pageCount)
{
return(DBHelper <Answers> .Select(pageSize, pageNum, tableName, " questionId = " + id, "id", false, out pageCount, " id,anMemberId,answer,inTime,ip,isSys "));
}
