private void initView()
{
if (mode == mode.Add)
{
btnOK.ButtonText = "新增";
btnOK.IdleFillColor = Color.FromArgb(33, 166, 117);
btnOK.IdleLineColor = Color.FromArgb(33, 166, 117);
btnOK.ActiveFillColor = Color.FromArgb(33, 166, 117);
btnOK.ActiveLineColor = Color.FromArgb(33, 166, 117);
panelInfo.Visible = false;
txtName.Text = mRosterInfo.RST_NAME;
txtMobile.Text = mRosterInfo.RST_MAIN;
txtAddr.Text = mRosterInfo.RST_ADDR;
dpkDealDTTM.Value = DateTime.Today;
ddlStatus.SelectedIndex = 3;
ddlType.SelectedIndex = 0;
ddlDealer.SelectedIndex = APConfig.getSelectIndex(ddlDealer, mRosterInfo.RST_PRINCIPAL) == -1 ? 0 : APConfig.getSelectIndex(ddlDealer, mRosterInfo.RST_PRINCIPAL);
ddlY.SelectedIndex = 0;
ddlM.SelectedIndex = 0;
}
else if (mode == mode.Edit)
{
btnOK.ButtonText = "修改";
btnOK.IdleFillColor = Color.FromArgb(255, 161, 0);
btnOK.IdleLineColor = Color.FromArgb(255, 161, 0);
btnOK.ActiveFillColor = Color.FromArgb(255, 161, 0);
btnOK.ActiveLineColor = Color.FromArgb(255, 161, 0);
btnItemAdd.Visible = false;
btnItemDel.Visible = false;
btnItemPick.Visible = false;
btnClear.Visible = false;
btnDone.Visible = false;
lblTotalAmt.Visible = false;
panelInfo.Visible = true;
RosterDial_RInfo view = new RosterDial_RInfo(APConfig.Conn);
view.Conditions = " 1=1 ";
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.rsdserno.ToString(), serno);
if (view.load())
{
txtName.Text = view.RST_NAME;
txtMobile.Text = view.RST_MAIN;
txtAddr.Text = view.RST_ADDR;
ddlDealer.SelectedIndex = APConfig.getSelectIndex(ddlDealer, view.RSD_DEALER);
ddlStatus.SelectedIndex = APConfig.getSelectIndex(ddlStatus, view.RSD_STATUS);
ddlType.SelectedIndex = APConfig.getSelectIndex(ddlType, view.RSD_ITEMTYPE);
txtItemInfo.Text = view.RSD_ITEM;
txtAmount.Text = view.RSD_AMOUNT;
txtComment.Text = view.RSD_COMMENT;
lblInsertBy.Text = view.RSD_INSERTBY;
lblInsertDTTM.Text = view.RSD_INSERTDTTM.ToString();
lblModifyBy.Text = view.RSD_MODIFIEDBY;
lblModifyDTTM.Text = view.RSD_MODIFIEDDTTM.ToString();
dpkDealDTTM.Value = view.RSD_DEALDDTTM;
}
}
else if (mode == mode.View)
{
DisableControls();
btnOK.ButtonText = "確認";
btnItemAdd.Visible = false;
btnItemDel.Visible = false;
btnClear.Visible = false;
btnItemPick.Visible = false;
btnDone.Visible = false;
panelInfo.Visible = true;
lblTotalAmt.Visible = false;
RosterDial_RInfo view = new RosterDial_RInfo(APConfig.Conn);
view.Conditions = " 1=1 ";
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.rsdserno.ToString(), serno);
if (view.load())
{
txtName.Text = view.RST_NAME;
txtMobile.Text = view.RST_MAIN;
txtAddr.Text = view.RST_ADDR;
ddlDealer.SelectedIndex = APConfig.getSelectIndex(ddlDealer, view.RSD_DEALER);
ddlStatus.SelectedIndex = APConfig.getSelectIndex(ddlStatus, view.RSD_STATUS);
ddlType.SelectedIndex = APConfig.getSelectIndex(ddlType, view.RSD_ITEMTYPE);
txtItemInfo.Text = view.RSD_ITEM;
txtAmount.Text = view.RSD_AMOUNT;
txtComment.Text = view.RSD_COMMENT;
lblInsertBy.Text = view.RSD_INSERTBY;
lblInsertDTTM.Text = view.RSD_INSERTDTTM.ToString();
lblModifyBy.Text = view.RSD_MODIFIEDBY;
lblModifyDTTM.Text = view.RSD_MODIFIEDDTTM.ToString();
dpkDealDTTM.Value = view.RSD_DEALDDTTM;
}
}
}
private void saleLoadData(int pageNum)
{
int total = 0;
dgvSale.Rows.Clear();
DataGridViewRowCollection rows = dgvSale.Rows;
RosterDial_RInfo view = new RosterDial_RInfo(APConfig.Conn);
view.Conditions = " 1=1 ";
if (!string.IsNullOrEmpty(txtSaleItem.Text))
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.item.ToString(), txtSaleItem.Text);
}
if (!string.IsNullOrEmpty(txtSaleMain.Text))
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.main.ToString(), txtSaleMain.Text);
}
if (!string.IsNullOrEmpty(txtSaleName.Text))
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.name.ToString(), txtSaleName.Text);
}
if (!string.IsNullOrEmpty(txtSaleComment.Text))
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.comment.ToString(), txtSaleComment.Text);
}
//if (!string.IsNullOrEmpty(dpkSaleInsertSDTTM.Value.ToString()) && ckbSaleInsertDTTM.Checked)
// view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.createSDTTM.ToString(), dpkSaleInsertSDTTM.Value.ToString("yyyy/MM/dd"));
//if (!string.IsNullOrEmpty(dpkSaleInsertSDTTM.Value.ToString()) && ckbSaleInsertDTTM.Checked)
// view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.createEDTTM.ToString(), dpkSaleInsertSDTTM.Value.ToString("yyyy/MM/dd"));
if (!string.IsNullOrEmpty(dpkSaleModifySDTTM.Value.ToString()) && ckbSaleModifyDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.modifySDTTM.ToString(), dpkSaleModifySDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkSaleModifyEDTTM.Value.ToString()) && ckbSaleModifyDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.modifyEDTTM.ToString(), dpkSaleModifyEDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkSaleDealSDTTM.Value.ToString()) && ckbSaleDealDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealSDTTM.ToString(), dpkSaleDealSDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkSaleDealEDTTM.Value.ToString()) && ckbSaleDealDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealEDTTM.ToString(), dpkSaleDealEDTTM.Value.ToString("yyyy/MM/dd"));
}
if (ddlSaleDealer.SelectedIndex != 0)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealer.ToString(), ddlSaleDealer.SelectedItem.ToString());
}
if (ddlSaleStatus.SelectedIndex != 0)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.status.ToString(), ddlSaleStatus.SelectedItem.ToString());
}
if (ddlSaleType.SelectedIndex != 0)
{
if (ddlSaleType.SelectedItem.ToString() == "銷貨淨值") //Harsh Code
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.typelist.ToString(), " '銷貨收入','銷貨折扣'");
}
else
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.type.ToString(), ddlSaleType.SelectedItem.ToString());
}
}
//組排序指令
if (dgvSale.SortedColumn is null)
{
view.OrderBy = view.getOptionOrderBy(RosterDial_RInfo.ncSort.Default.ToString());
}
else
{
string sortname = dgvSale.SortedColumn.Name;
string sortmode = APConfig.GetValueFromDescription <SortMode>(dgvSale.SortOrder.ToString()).ToString();
view.OrderBy = string.Format("{0} {1}", view.getOptionOrderBy(sortname), sortmode);
}
//查詢頁數初始化且自動跳轉至第一頁
if (pageNum == 0)
{
APConfig.loadPage(ddlSalePage, view.calculatePage(APConfig.PageCount));
return;
}
//計算總合
if (view.load())
{
while (!view.IsEof)
{
total += int.Parse(view.RSD_AMOUNT);
view.next();
}
}
//塞入資料
DataSet ds = APConfig.GoPage(view.SQLStatement, pageNum);
foreach (DataRow dr in ds.Tables[0].Rows)
{
rows.Add(new Object[] { dr.ItemArray[0], dr.ItemArray[14], dr.ItemArray[13], dr.ItemArray[1], dr.ItemArray[2], dr.ItemArray[3], dr.ItemArray[6], dr.ItemArray[4], dr.ItemArray[5], dr.ItemArray[7], dr.ItemArray[10] });
}
lblSaleTotal.Text = view.calculateCount().ToString();
lblSaleTotalAmount.Text = string.Format("{0:n0} 元", total);
}
