public void Delete(int psf_id)
{
ProductSubFormatInfo info = GetSubFormatKey(psf_id);
List <ProductSubFormatInfo> infos = UpdateSorting(info.p_id, info.psf_sorting);
foreach (ProductSubFormatInfo pdsinfo in infos)
{
db.Update(pdsinfo.p_id, pdsinfo.psf_name, pdsinfo.psf_value, pdsinfo.psf_sorting - 1, pdsinfo.psf_id);
}
db.Delete(psf_id);
}
public List <ProductSubFormatInfo> UpdateSorting(int p_id, int psf_sorting)
{
List <ProductSubFormatInfo> infos = new List <ProductSubFormatInfo>();
IDataReader reader = db.UpdateSubFormatSorting(p_id, psf_sorting).CreateDataReader();
while (reader.Read())
{
infos.Add(ProductSubFormatInfo.Populate(reader));
}
return(infos);
}
public List <ProductSubFormatInfo> GetFormatWithProduct(int p_id)
{
List <ProductSubFormatInfo> infos = new List <ProductSubFormatInfo>();
IDataReader reader = db.GetFormatWithProduct(p_id).CreateDataReader();
while (reader.Read())
{
infos.Add(ProductSubFormatInfo.Populate(reader));
}
return(infos);
}
public ProductSubFormatInfo GetSubFormatKey(int psf_id)
{
ProductSubFormatInfo info = new ProductSubFormatInfo();
IDataReader reader = db.GetSubFormatKey(psf_id).CreateDataReader();
if (reader.Read())
{
info = ProductSubFormatInfo.Populate(reader);
}
return(info);
}
public int GetFormatInsertSorting(int p_id)
{
int check = 1;
ProductSubFormatInfo info = new ProductSubFormatInfo();
IDataReader reader = db.GetSubformatInsertSorting(p_id).CreateDataReader();
if (reader.Read())
{
info = ProductSubFormatInfo.Populate(reader);
check = info.psf_sorting + 1;
}
return(check);
}
protected void btNewFormat_Click(object sender, EventArgs e)
{
if (txtNewFormat.Text == "")
{
ShowMessage("請輸入規格名稱");
return;
}
ProductSubFormatInfo info = new ProductSubFormatInfo();
info.p_id = Tools.GetInt32SafeFromQueryString(this.Page, "id", 0);
info.psf_name = txtNewFormat.Text;
info.psf_sorting = pdsFM.GetFormatInsertSorting(Tools.GetInt32SafeFromQueryString(this.Page, "id", 0));
pdsFM.Insert(info);
rpFormat.DataSource = pdsFM.GetFormatWithProduct(Tools.GetInt32SafeFromQueryString(this.Page, "id", 0));
rpFormat.DataBind();
}
private void InsertProductSubFormat(int ProductID)
{
ProductSubFormatInfo info = new ProductSubFormatInfo();
//讀取ItemDataBound
for (int i = 0; i < rpFormat.Items.Count; i++)
{
CheckBox ckbox = (CheckBox)rpFormat.Items[i].FindControl("ckFormat");
Label lbtxtFormatName = (Label)rpFormat.Items[i].FindControl("lbFormat");
TextBox txtFormatValue = (TextBox)rpFormat.Items[i].FindControl("txtFormatValue");
TextBox txtSorting = (TextBox)rpFormat.Items[i].FindControl("txtSorting");
info.p_id = ProductID;
info.psf_name = lbtxtFormatName.Text;
info.psf_value = txtFormatValue.Text;
info.psf_sorting = Tools.TryParseMethod(txtSorting.Text); //必須驗證
if (pdsFMBLL.Insert(info) > 0)
{
ShowMessage("新增規格成功");
}
}
}
protected void rpFormat_ItemCommand(object source, RepeaterCommandEventArgs e)
{
Label lb2;
Label lb3;
int ClickNowKey = 0;
int RdyChangeKey = 0;
int ClickNowSort = 0;
int RdyChangeSort = 0;
if (e.CommandName == "Delete")
{
Label lb = (Label)e.Item.FindControl("lbFormatID");
pdsFM.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");
ProductSubFormatInfo pdsFMClick = pdsFM.GetSubFormatKey(int.Parse(lb2.Text));
ProductSubFormatInfo pdsFMChange = pdsFM.GetSubFormatKey(int.Parse(lb3.Text));
ClickNowSort = pdsFMClick.psf_sorting;
RdyChangeSort = pdsFMChange.psf_sorting;
pdsFMClick.psf_sorting = RdyChangeSort;
pdsFMChange.psf_sorting = ClickNowSort;
pdsFM.Update(pdsFMClick);
pdsFM.Update(pdsFMChange);
}
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");
ProductSubFormatInfo pdsFMClick = pdsFM.GetSubFormatKey(int.Parse(lb2.Text));
ProductSubFormatInfo pdsFMChange = pdsFM.GetSubFormatKey(int.Parse(lb3.Text));
ClickNowSort = pdsFMClick.psf_sorting;
RdyChangeSort = pdsFMChange.psf_sorting;
pdsFMClick.psf_sorting = RdyChangeSort;
pdsFMChange.psf_sorting = ClickNowSort;
pdsFM.Update(pdsFMClick);
pdsFM.Update(pdsFMChange);
}
else
{
ShowMessage("此項目排序已是最底");
}
}
rpFormat.DataSource = pdsFM.GetFormatWithProduct(Tools.GetInt32SafeFromQueryString(this.Page, "id", 0));
rpFormat.DataBind();
}
public void Update(ProductSubFormatInfo info)
{
db.Update(info.p_id, info.psf_name, info.psf_value, info.psf_sorting, info.psf_id);
}
public int Insert(ProductSubFormatInfo info)
{
return(db.Insert(info.p_id, info.psf_name, info.psf_value, info.psf_sorting));
}
