public void Delete(int pf_id) { ProductTempFormatInfo info = GettempKey(pf_id); List <ProductTempFormatInfo> infos = UpdateSortingWithCategory(info.pc_id, info.pf_sorting); foreach (ProductTempFormatInfo pdtfm in infos) { db.Update(pdtfm.pc_id, pdtfm.pf_name, pdtfm.pf_value, pdtfm.pf_sorting - 1, pdtfm.pf_id); } db.Delete(pf_id); }
public List <ProductTempFormatInfo> UpdateSortingWithCategory(int pc_id, int sorting) { List <ProductTempFormatInfo> infos = new List <ProductTempFormatInfo>(); IDataReader reader = db.UpdateSorting(pc_id, sorting).CreateDataReader(); while (reader.Read()) { infos.Add(ProductTempFormatInfo.Populate(reader)); } return(infos); }
public ProductTempFormatInfo GettempKey(int pf_id) { ProductTempFormatInfo info = new ProductTempFormatInfo(); IDataReader reader = db.GetTempKey(pf_id).CreateDataReader(); while (reader.Read()) { info = ProductTempFormatInfo.Populate(reader); } return(info); }
public List <ProductTempFormatInfo> GetallWithCategory(int pc_id) { List <ProductTempFormatInfo> infos = new List <ProductTempFormatInfo>(); IDataReader reader = db.GetDataByCategory(pc_id).CreateDataReader(); while (reader.Read()) { infos.Add(ProductTempFormatInfo.Populate(reader)); } return(infos); }
public int GetCategorySortingDesc(int pc_id) { ProductTempFormatInfo info = new ProductTempFormatInfo(); IDataReader reader = db.GetCategorySortingDESC(pc_id).CreateDataReader(); if (reader.Read()) { info = ProductTempFormatInfo.Populate(reader); return(info.pf_sorting + 1); } return(1); }
protected void btNewFormat_Click(object sender, EventArgs e) { if (txtNewFormat.Text == "") { //this.Page.Controls.Add(Tools.Tomsg("請輸入規格名稱")); ShowMessage("請輸入規格名稱"); return; } ProductTempFormatInfo info = new ProductTempFormatInfo(); info.pc_id = Tools.TryParseMethod(ddlCategory.SelectedValue); info.pf_name = txtNewFormat.Text; info.pf_sorting = pdtFMBLL.GetCategorySortingDesc(info.pc_id); //寫入TempFormat 名稱、排序、類別 pdtFMBLL.Insert(info); //再提出給予Repeater rpFormat.DataSource = pdtFMBLL.GetallWithCategory(info.pc_id); rpFormat.DataBind(); }
//儲存更新 protected void btSave_Click(object sender, EventArgs e) { for (int i = 0; i < rpFormat.Items.Count; i++) { Label lbformatID = (Label)rpFormat.Items[i].FindControl("lbFormatID"); Label lbformat = (Label)rpFormat.Items[i].FindControl("lbFormat"); TextBox txtFormatValue = (TextBox)rpFormat.Items[i].FindControl("txtFormatValue"); TextBox txtSorting = (TextBox)rpFormat.Items[i].FindControl("txtSorting"); ProductTempFormatInfo info = new ProductTempFormatInfo(); info.pf_id = Tools.TryParseMethod(lbformatID.Text); info.pc_id = Tools.TryParseMethod(ddlCategory.SelectedValue); info.pf_name = lbformat.Text; info.pf_value = txtFormatValue.Text; info.pf_sorting = Tools.TryParseMethod(txtSorting.Text); //必須驗證 pdtFMBLL.Update(info); ShowMessage("儲存規格成功"); } rpFormat.DataSource = pdtFMBLL.GetallWithCategory(Tools.TryParseMethod(ddlCategory.SelectedValue)); rpFormat.DataBind(); }
public void Update(ProductTempFormatInfo info) { db.Update(info.pc_id, info.pf_name, info.pf_value, info.pf_sorting, info.pf_id); }
public void Insert(ProductTempFormatInfo info) { info.pf_sorting = GetCategorySortingDesc(info.pc_id); db.Insert(info.pc_id, info.pf_name, info.pf_value, info.pf_sorting); }
//repeater刪除規格事件 //動態上下排序事件寫於此 protected void rpFormat_ItemCommand(object source, RepeaterCommandEventArgs e) { Label lb = (Label)e.Item.FindControl("lbFormatID"); Label lb2; Label lb3; int ClickNowKey = 0; int RdyChangeKey = 0; int ClickNowSort = 0; int RdyChangeSort = 0; if (e.CommandName == "Delete") { pdtFMBLL.Delete(int.Parse(lb.Text)); } if (e.CommandName == "btnSortUp") { ClickNowKey = e.Item.ItemIndex; RdyChangeKey = e.Item.ItemIndex - 1; if (ClickNowKey > 0) { lb2 = (Label)rpFormat.Items[ClickNowKey].FindControl("lbFormatID"); lb3 = (Label)rpFormat.Items[RdyChangeKey].FindControl("lbFormatID"); ProductTempFormatInfo pdTFMClick = pdtFMBLL.GettempKey(int.Parse(lb2.Text)); ProductTempFormatInfo pdTFMChange = pdtFMBLL.GettempKey(int.Parse(lb3.Text)); ClickNowSort = pdTFMClick.pf_sorting; RdyChangeSort = pdTFMChange.pf_sorting; pdTFMClick.pf_sorting = RdyChangeSort; pdTFMChange.pf_sorting = ClickNowSort; pdtFMBLL.Update(pdTFMClick); pdtFMBLL.Update(pdTFMChange); } else { ShowMessage("此項目排序已是第一位"); } } if (e.CommandName == "btnSortDown") { ClickNowKey = e.Item.ItemIndex; RdyChangeKey = e.Item.ItemIndex + 1; if (ClickNowKey + 1 < rpFormat.Items.Count) //底部判斷錯誤 { lb2 = (Label)rpFormat.Items[ClickNowKey].FindControl("lbFormatID"); lb3 = (Label)rpFormat.Items[RdyChangeKey].FindControl("lbFormatID"); ProductTempFormatInfo pdTFMClick = pdtFMBLL.GettempKey(int.Parse(lb2.Text)); ProductTempFormatInfo pdTFMChange = pdtFMBLL.GettempKey(int.Parse(lb3.Text)); ClickNowSort = pdTFMClick.pf_sorting; RdyChangeSort = pdTFMChange.pf_sorting; pdTFMClick.pf_sorting = RdyChangeSort; pdTFMChange.pf_sorting = ClickNowSort; pdtFMBLL.Update(pdTFMClick); pdtFMBLL.Update(pdTFMChange); } else { ShowMessage("此項目排序已是最底"); } } rpFormat.DataSource = pdtFMBLL.GetallWithCategory(Tools.TryParseMethod(ddlCategory.SelectedValue)); rpFormat.DataBind(); }