|
 |
| |
gridview โชว์ข้อมูลตามเงื่อนไขแบบนี้ทำได้ไหมคะ แนะนำด้วยนะคะ |
| |
 |
|
|
 |
 |
|
ไม่ทำที่ Query ก่อนที่จะ BindData ล่ะครับ 
|
 |
 |
 |
 |
| Date :
2013-11-29 09:25:38 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ขอบคุณค่ะ เขียนได้แล้ว แสดงผลดังภาพค่ะ
Code (C#)
private void Binddata()
{
eContractDBDataContext db = new eContractDBDataContext();
var chkMeal = from ml in db.Mealzs
where ml.PropID == Request.QueryString["HotelID"].ToString().ToDecimal()
where ml.ValidID == Request.QueryString["V"].ToString().ToDecimal()
where ml.CurrencyID == Request.QueryString["cur"].ToString().ToDecimal()
select ml;
if (chkMeal.ToList().Count > 0)
{
for (int i = 0; i < grdSearch.Rows.Count; i++)
{
TextBox txtMealPrice1 = new TextBox();
txtMealPrice1 = grdSearch.Rows[i].FindControl("txtMealPrice1") as TextBox;
txtMealPrice1.ReadOnly = false;
TextBox txtMealPrice2 = new TextBox();
txtMealPrice2 = grdSearch.Rows[i].FindControl("txtMealPrice2") as TextBox;
txtMealPrice2.ReadOnly = false;
TextBox txtMealPrice3 = new TextBox();
txtMealPrice3 = grdSearch.Rows[i].FindControl("txtMealPrice3") as TextBox;
txtMealPrice3.ReadOnly = false;
foreach (var item in chkMeal)
{
if (grdSearch.DataKeys[i].Value.ToString().ToDecimal() == item.MealTypeID)
{
if (item.AgeID == 33)
{
txtMealPrice1.Text = item.MealPrice.ToString();
}
if (item.AgeID == 34)
{
txtMealPrice2.Text = item.MealPrice.ToString();
}
if (item.AgeID == 36)
{
txtMealPrice3.Text = item.MealPrice.ToString();
}
if (Request.QueryString["mode"] != null)
{
CheckBox chkUse = new CheckBox();
chkUse = grdSearch.Rows[i].FindControl("chkUse") as CheckBox;
chkUse.Checked = true;
chkUse.Enabled = false;
txtMealPrice1.ReadOnly = true;
txtMealPrice2.ReadOnly = true;
txtMealPrice3.ReadOnly = true;
cmdSave.Visible = false;
cmdUpdate.Visible = true;
}
}
}
}
}
}
แล้วถ้าทำการเพิ่มข้อมูลแล้วคลิกupdate เขียนแบบนี้ถูกหรือป่าวคะ
Code (C#)
protected void cmdUpdate_Click(object sender, EventArgs e)
{
eContractDBDataContext db = new eContractDBDataContext();
int icount = 0;
for (int i = 0; i < grdSearch.Rows.Count; i++)
{
CheckBox chkUse = new CheckBox();
chkUse = grdSearch.Rows[i].FindControl("chkUse") as CheckBox;
chkUse.Enabled = false;
if (chkUse.Checked == true)
{
CheckBox chkAdult = new CheckBox();
chkAdult = grdSearch.Rows[i].FindControl("chkAdult") as CheckBox;
CheckBox chkTeen = new CheckBox();
chkTeen = grdSearch.Rows[i].FindControl("chkTeen") as CheckBox;
CheckBox chkChild = new CheckBox();
chkChild = grdSearch.Rows[i].FindControl("chkChild") as CheckBox;
TextBox txtMealPrice1 = new TextBox();
txtMealPrice1 = grdSearch.Rows[i].FindControl("txtMealPrice1") as TextBox;
if (txtMealPrice1.Text == "")
{
txtMealPrice1.Text = "0";
}
TextBox txtMealPrice2 = new TextBox();
txtMealPrice2 = grdSearch.Rows[i].FindControl("txtMealPrice2") as TextBox;
if (txtMealPrice2.Text == "")
{
txtMealPrice2.Text = "0";
}
TextBox txtMealPrice3 = new TextBox();
txtMealPrice3 = grdSearch.Rows[i].FindControl("txtMealPrice3") as TextBox;
if (txtMealPrice3.Text == "")
{
txtMealPrice3.Text = "0";
}
if (Request.QueryString["mode"] != null)
{
if (txtMealPrice1.ReadOnly == false)
{
Mealz ml = new Mealz();
ml.Compulsory = "O";
ml.CreateBy = User.Identity.Name;
ml.CurrencyID = Request.QueryString["cur"].ToString().ToDecimal();
ml.MealTypeID = grdSearch.DataKeys[i].Value.ToString().ToDecimal();
ml.PropID = Request.QueryString["HotelID"].ToString().ToDecimal();
ml.UpdateBy = "";
ml.UpdateTime = DateTime.Now;
ml.ValidYear = "";
ml.ValidID = Request.QueryString["V"].ToString().ToDecimal();
if (chkAdult.Checked == true)
{
ml.AgeID = 33;
ml.MealPrice = txtMealPrice1.Text.ToDecimal();
}
if (chkTeen.Checked == true)
{
ml.AgeID = 34;
ml.MealPrice = txtMealPrice2.Text.ToDecimal();
}
if (chkChild.Checked == true)
{
ml.AgeID = 36;
ml.MealPrice = txtMealPrice3.Text.ToDecimal();
}
ml.UpdateBy = User.Identity.Name;
ml.UpdateTime = DateTime.Now;
db.Mealzs.InsertOnSubmit(ml);
db.SubmitChanges();
chkUse.Enabled = false;
}
else
{
var editMeal = (from ml in db.Mealzs
where ml.PropID == Request.QueryString["HotelID"].ToString().ToDecimal()
where ml.ValidID == Request.QueryString["V"].ToString().ToDecimal()
where ml.CurrencyID == Request.QueryString["cur"].ToString().ToDecimal()
where ml.MealTypeID == grdSearch.DataKeys[i].Value.ToString().ToDecimal()
select ml).First();
if(chkAdult.Checked == true)
{
editMeal.AgeID = 33 ;
editMeal.MealPrice = txtMealPrice1.Text.ToDecimal();
}
if(chkTeen.Checked == true)
{
editMeal.AgeID = 34 ;
editMeal.MealPrice = txtMealPrice2.Text.ToDecimal();
}
if(chkChild.Checked == true)
{
editMeal.AgeID = 36 ;
editMeal.MealPrice = txtMealPrice3.Text.ToDecimal();
}
editMeal.UpdateBy = User.Identity.Name;
editMeal.UpdateTime = DateTime.Now;
db.SubmitChanges();
}
}
else
{
var editMeal = (from ml in db.Mealzs
where ml.PropID == Request.QueryString["HotelID"].ToString().ToDecimal()
where ml.ValidID == Request.QueryString["V"].ToString().ToDecimal()
where ml.CurrencyID == Request.QueryString["cur"].ToString().ToDecimal()
where ml.MealTypeID == grdSearch.DataKeys[i].Value.ToString().ToDecimal()
select ml).First();
if (chkAdult.Checked == true)
{
editMeal.AgeID = 33;
editMeal.MealPrice = txtMealPrice1.Text.ToDecimal();
}
if (chkTeen.Checked == true)
{
editMeal.AgeID = 34;
editMeal.MealPrice = txtMealPrice2.Text.ToDecimal();
}
if (chkChild.Checked == true)
{
editMeal.AgeID = 36;
editMeal.MealPrice = txtMealPrice3.Text.ToDecimal();
}
editMeal.UpdateBy = User.Identity.Name;
editMeal.UpdateTime = DateTime.Now;
db.SubmitChanges();
}
icount = icount + 1;
}
}
if (icount == 0)
{
Alert("er", "Please Choose Meal Type", true);
return;
}
else
{
Alert(MsgType.FinishUpdate);
return;
}
}
|
| |
|
|
| |
| Date :
2013-12-03 12:07:39 |
By :
หมูแดง |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 01
|
