private void Save()
{
SVM_SalesTargetBLL bll = new SVM_SalesTargetBLL((int)ViewState["TargetID"]);
foreach (GridViewRow gr in gv_List.Rows)
{
int id = (int)gv_List.DataKeys[gr.RowIndex][0];
SVM_SalesTarget_Detail item = bll.GetDetailModel(id);
item.Quantity = int.Parse(((TextBox)gr.FindControl("tbx_Quantity1")).Text) * new PDT_ProductBLL(item.Product).Model.ConvertFactor;
item.Remark = ((TextBox)gr.FindControl("tbx_Remark")).Text;
bll.UpdateDetail(item);
}
}
protected void btn_SalesTarget_Click(object sender, EventArgs e)
{
#region 已有分配单展示,没有则生成
MCSTreeControl tr_OrganizeCity = (MCSTreeControl)UC_DetailView1.FindControl("SVM_SalesTarget_OrganizeCity");
MCSSelectControl select_Client = (MCSSelectControl)UC_DetailView1.FindControl("SVM_SalesTarget_Client");
DropDownList ddl_Month = (DropDownList)UC_DetailView1.FindControl("SVM_SalesTarget_AccountMonth");
if (tr_OrganizeCity.SelectValue == "0" || select_Client.SelectValue == "")
{
lb_Msg.Text = "必填先选择要填报的客户!";
MessageBox.Show(this, "必填先选择要填报的客户!" + tr_OrganizeCity.SelectValue + "|" + select_Client.SelectValue);
return;
}
int id = SVM_SalesTargetBLL.InitProductList(int.Parse(tr_OrganizeCity.SelectValue), int.Parse(ddl_Month.SelectedValue), int.Parse(select_Client.SelectValue == "" ? "0" : select_Client.SelectValue), (int)Session["UserID"]);
Response.Redirect("SalesTargetDetail.aspx?TargetID=" + id.ToString());
#endregion
}
private void BindData()
{
SVM_SalesTargetBLL bll = new SVM_SalesTargetBLL((int)ViewState["TargetID"]);
ViewState["ClientID"] = bll.Model.Client;
UC_DetailView1.BindData(bll.Model);
UC_DetailView1.SetControlsEnable(false);
BindGrid();
if (bll.Model.ApproveFlag == 1)
{
gv_List.SetControlsEnable(false);
bt_Approve.Visible = false;
bt_Save.Visible = false;
bt_Del.Visible = false;
}
}
private void Save()
{
SVM_SalesTargetBLL bll = new SVM_SalesTargetBLL((int)ViewState["TargetID"]);
foreach (GridViewRow gr in gv_List.Rows)
{
int id = (int)gv_List.DataKeys[gr.RowIndex][0];
SVM_SalesTarget_Detail item = bll.GetDetailModel(id);
item.Quantity = int.Parse(((TextBox)gr.FindControl("tbx_Quantity1")).Text) * new PDT_ProductBLL(item.Product).Model.ConvertFactor;
item.Remark = ((TextBox)gr.FindControl("tbx_Remark")).Text;
bll.UpdateDetail(item);
}
}
private void BindData()
{
SVM_SalesTargetBLL bll = new SVM_SalesTargetBLL((int)ViewState["TargetID"]);
ViewState["ClientID"] = bll.Model.Client;
UC_DetailView1.BindData(bll.Model);
UC_DetailView1.SetControlsEnable(false);
BindGrid();
if (bll.Model.ApproveFlag == 1)
{
gv_List.SetControlsEnable(false);
bt_Approve.Visible = false;
bt_Save.Visible = false;
bt_Del.Visible = false;
}
}
protected decimal GetTargetSumPrice(string TargetID)
{
return(SVM_SalesTargetBLL.GetTargetSumPrice(int.Parse(TargetID)));
}
private void BindGrid()
{
if (tr_detail.Visible)
{
string condition = "1=1";
#region 组织查询条件
//管理片区及所有下属管理片区
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND SVM_SalesTarget.OrganizeCity IN (" + orgcitys + ")";
}
//会计月条件
condition += " AND SVM_SalesTarget.AccountMonth BETWEEN " + ddl_BeginMonth.SelectedValue + " AND " + ddl_EndMonth.SelectedValue;
if (rbl_ApproveFlag.SelectedValue != "0")
{
condition += " AND SVM_SalesTarget.ApproveFlag= " + rbl_ApproveFlag.SelectedValue;
}
if (select_Client.SelectValue != "")
{
condition += " AND SVM_SalesTarget.Client = " + select_Client.SelectValue;
}
else
{
condition += " AND CM_Client.ClientType=" + ViewState["ClientType"].ToString();
if ((int)ViewState["ClientType"] == 2 && ViewState["DIClassify"] != null)
{
condition += " AND MCS_SYS.dbo.UF_Spilt(CM_Client.ExtPropertys,'|',7)='" + ViewState["DIClassify"].ToString() + "'";
}
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
else
{
int organizecity = int.Parse(tr_OrganizeCity.SelectValue);
int client = select_Client.SelectValue == "" ? 0 : int.Parse(select_Client.SelectValue);
if (organizecity == 0)
{
organizecity = 1;
}
DataTable dt = SVM_SalesTargetBLL.GetSummary(organizecity, client, int.Parse(ddl_BeginMonth.SelectedValue), int.Parse(ddl_EndMonth.SelectedValue), int.Parse(ViewState["ClientType"].ToString()));
int _quantity = 0;
decimal _totalvalue = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
_quantity += (int)dt.Rows[i]["SumQuantity"];
_totalvalue += (decimal)dt.Rows[i]["SumMoney"];
}
DataRow dr = dt.NewRow();
dr["ProductCode"] = "合计";
dr["SumQuantity"] = _quantity;
dr["SumMoney"] = _totalvalue;
dt.Rows.Add(dr);
gv_Summary.DataSource = dt;
gv_Summary.DataBind();
}
}
