private void BindData()
{
Rpt_DataSetParams m = new Rpt_DataSetParamsBLL((Guid)ViewState["ID"]).Model;
if (m != null)
{
pl_detail.BindData(m);
ViewState["DataSet"] = m.DataSet;
if (m.RelationType > 0)
{
rbl_RelationType.SelectedValue = m.RelationType.ToString();
rbl_RelationType_SelectedIndexChanged(null, null);
}
if (ddl_RelationTableName != null || ddl_RelationTableName.Items.Count != 0)
{
ddl_RelationTableName.SelectedValue = m.RelationTableName;
ddl_RelationTableName_SelectedIndexChanged(null, null);
}
if (ddl_RelationTextField != null || ddl_RelationTextField.Items.Count != 0)
{
ddl_RelationTextField.SelectedValue = m.RelationTextField;
}
if (ddl_RelationValueField != null || ddl_RelationValueField.Items.Count != 0)
{
ddl_RelationValueField.SelectedValue = m.RelationValueField;
}
}
}
protected void bt_Increase_Click(object sender, EventArgs e)
{
int rowindex = ((GridViewRow)((Button)sender).Parent.Parent).RowIndex;
if (rowindex < gv_List.Rows.Count - 1)
{
Guid id = (Guid)gv_List.DataKeys[rowindex][0];
Rpt_DataSetParamsBLL bll = new Rpt_DataSetParamsBLL(id);
bll.Model.ParamSortID++;
bll.Update();
id = (Guid)gv_List.DataKeys[rowindex + 1][0];
bll = new Rpt_DataSetParamsBLL(id);
if (bll.Model.ParamSortID > 0) bll.Model.ParamSortID--;
bll.Update();
}
BindGrid();
}
protected void bt_Increase_Click(object sender, EventArgs e)
{
int rowindex = ((GridViewRow)((Button)sender).Parent.Parent).RowIndex;
if (rowindex < gv_List.Rows.Count - 1)
{
Guid id = (Guid)gv_List.DataKeys[rowindex][0];
Rpt_DataSetParamsBLL bll = new Rpt_DataSetParamsBLL(id);
bll.Model.ParamSortID++;
bll.Update();
id = (Guid)gv_List.DataKeys[rowindex + 1][0];
bll = new Rpt_DataSetParamsBLL(id);
if (bll.Model.ParamSortID > 0)
{
bll.Model.ParamSortID--;
}
bll.Update();
}
BindGrid();
}
private void BindData()
{
Rpt_DataSetParams m = new Rpt_DataSetParamsBLL((Guid)ViewState["ID"]).Model;
if (m != null)
{
pl_detail.BindData(m);
ViewState["DataSet"] = m.DataSet;
if (m.RelationType > 0)
{
rbl_RelationType.SelectedValue = m.RelationType.ToString();
rbl_RelationType_SelectedIndexChanged(null, null);
}
if (ddl_RelationTableName != null || ddl_RelationTableName.Items.Count != 0)
{
ddl_RelationTableName.SelectedValue = m.RelationTableName;
ddl_RelationTableName_SelectedIndexChanged(null, null);
}
if (ddl_RelationTextField != null || ddl_RelationTextField.Items.Count != 0)
{
ddl_RelationTextField.SelectedValue = m.RelationTextField;
}
if (ddl_RelationValueField != null || ddl_RelationValueField.Items.Count != 0)
{
ddl_RelationValueField.SelectedValue = m.RelationValueField;
}
}
}
protected void bt_AddTemParam_Click(object sender, EventArgs e)
{
Rpt_DataSetParamsBLL _bll = new Rpt_DataSetParamsBLL();
_bll.Model.DataSet = (Guid)ViewState["DataSet"];
_bll.Model.ParamSortID = ViewState["MaxSortID"] != null ? (int)ViewState["MaxSortID"] : 0;
_bll.Model["IsRequireField"] = "Y";
_bll.Model["Enable"] = "Y";
_bll.Model.Visible = "Y";
switch (ddl_TemParam.SelectedValue)
{
case "":
MessageBox.Show(this, "请选择要增加的预定参数!");
return;
case "OrganizeCity":
_bll.Model.ParamName = "@OrganizeCity";
_bll.Model.DisplayName = "管理片区";
_bll.Model.DataType = 1;
_bll.Model.DefaultValue = "$StaffOrganizeCity$";
_bll.Model.ControlType = 7;
_bll.Model["ControlWidth"] = "220";
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_SYS.dbo.Addr_OrganizeCity";
_bll.Model.RelationTextField = "Name";
_bll.Model.RelationValueField = "ID";
break;
case "AccountMonth":
_bll.Model.ParamName = "@AccountMonth";
_bll.Model.DisplayName = "会计月";
_bll.Model.DataType = 1;
_bll.Model.DefaultValue = "$CurrentAccountMonth$";
_bll.Model.ControlType = 3;
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_Pub.dbo.AC_AccountMonth";
_bll.Model.RelationTextField = "Name";
_bll.Model.RelationValueField = "ID";
break;
case "Staff":
_bll.Model.ParamName = "@Staff";
_bll.Model.DisplayName = "员工";
_bll.Model.DataType = 1;
_bll.Model.DefaultValue = "$StaffID$";
_bll.Model.ControlType = 6;
_bll.Model.SearchPageURL = "~/SubModule/StaffManage/Pop_Search_Staff.aspx";
_bll.Model["ControlWidth"] = "260";
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_SYS.dbo.Org_Staff";
_bll.Model.RelationTextField = "RealName";
_bll.Model.RelationValueField = "ID";
break;
case "Retailer":
_bll.Model.ParamName = "@ClientID";
_bll.Model.DisplayName = "零售商";
_bll.Model.DataType = 1;
_bll.Model.ControlType = 6;
_bll.Model.SearchPageURL = "~/SubModule/CM/PopSearch/Search_SelectClient.aspx?ClientType=3";
_bll.Model["ControlWidth"] = "260";
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_CM.dbo.CM_Client";
_bll.Model.RelationTextField = "FullName";
_bll.Model.RelationValueField = "ID";
break;
case "Distributor":
_bll.Model.ParamName = "@ClientID";
_bll.Model.DisplayName = "经销商";
_bll.Model.DataType = 1;
_bll.Model.ControlType = 6;
_bll.Model.SearchPageURL = "~/SubModule/CM/PopSearch/Search_SelectClient.aspx?ClientType=2";
_bll.Model["ControlWidth"] = "260";
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_CM.dbo.CM_Client";
_bll.Model.RelationTextField = "FullName";
_bll.Model.RelationValueField = "ID";
break;
case "BeginDate":
_bll.Model.ParamName = "@BeginDate";
_bll.Model.DisplayName = "开始日期";
_bll.Model.DataType = 4;
_bll.Model.ControlType = 2;
_bll.Model["ControlWidth"] = "70";
_bll.Model.RelationType = 1;
_bll.Model.DefaultValue = "$ThisMonthFirstDay$";
break;
case "EndDate":
_bll.Model.ParamName = "@EndDate";
_bll.Model.DisplayName = "截止日期";
_bll.Model.DataType = 4;
_bll.Model.ControlType = 2;
_bll.Model["ControlWidth"] = "70";
_bll.Model.RelationType = 1;
_bll.Model.DefaultValue = "$Today$";
break;
default:
break;
}
if (_bll.Add() == 0)
{
MessageBox.ShowAndRedirect(this, "新增成功!", "Rpt_DataSetParamsDetail.aspx?ID=" + _bll.Model.ID.ToString());
}
}
protected void bt_OK_Click(object sender, EventArgs e)
{
new Rpt_DataSetBLL((Guid)ViewState["DataSet"]).ClearCache();
Rpt_DataSetParamsBLL _bll;
if ((Guid)ViewState["ID"] != Guid.Empty)
{
//修改
_bll = new Rpt_DataSetParamsBLL((Guid)ViewState["ID"]);
}
else
{
//新增
_bll = new Rpt_DataSetParamsBLL();
_bll.Model.DataSet = (Guid)ViewState["DataSet"];
}
pl_detail.GetData(_bll.Model);
#region 判断必填项
#endregion
#region 参数数据源关联类型
_bll.Model.RelationType = int.Parse(rbl_RelationType.SelectedValue);
if (ddl_RelationTableName.Visible)
{
_bll.Model.RelationTableName = ddl_RelationTableName.SelectedValue;
}
else
{
_bll.Model.RelationTableName = "";
}
if (ddl_RelationTextField.Visible)
{
_bll.Model.RelationTextField = ddl_RelationTextField.SelectedValue;
}
else
{
_bll.Model.RelationTextField = "";
}
if (ddl_RelationValueField.Visible)
{
_bll.Model.RelationValueField = ddl_RelationValueField.SelectedValue;
}
else
{
_bll.Model.RelationValueField = "";
}
#endregion
if ((Guid)ViewState["ID"] != Guid.Empty)
{
//修改
if (_bll.Update() == 0)
{
MessageBox.ShowAndRedirect(this, "修改成功!", "Rpt_DataSetParamsList.aspx?ID=" + _bll.Model.DataSet.ToString());
}
}
else
{
//新增
if (_bll.Add() == 0)
{
MessageBox.ShowAndRedirect(this, "新增成功!", "Rpt_DataSetParamsList.aspx?ID=" + _bll.Model.DataSet.ToString());
}
}
}
protected void bt_AddTemParam_Click(object sender, EventArgs e)
{
Rpt_DataSetParamsBLL _bll = new Rpt_DataSetParamsBLL();
_bll.Model.DataSet = (Guid)ViewState["DataSet"];
_bll.Model.ParamSortID = ViewState["MaxSortID"] != null ? (int)ViewState["MaxSortID"] : 0;
_bll.Model["IsRequireField"] = "Y";
_bll.Model["Enable"] = "Y";
_bll.Model.Visible = "Y";
switch (ddl_TemParam.SelectedValue)
{
case "":
MessageBox.Show(this, "请选择要增加的预定参数!");
return;
case "OrganizeCity":
_bll.Model.ParamName = "@OrganizeCity";
_bll.Model.DisplayName = "管理片区";
_bll.Model.DataType = 1;
_bll.Model.DefaultValue = "$StaffOrganizeCity$";
_bll.Model.ControlType = 7;
_bll.Model["ControlWidth"] = "220";
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_SYS.dbo.Addr_OrganizeCity";
_bll.Model.RelationTextField = "Name";
_bll.Model.RelationValueField = "ID";
break;
case "AccountMonth":
_bll.Model.ParamName = "@AccountMonth";
_bll.Model.DisplayName = "会计月";
_bll.Model.DataType = 1;
_bll.Model.DefaultValue = "$CurrentAccountMonth$";
_bll.Model.ControlType = 3;
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_Pub.dbo.AC_AccountMonth";
_bll.Model.RelationTextField = "Name";
_bll.Model.RelationValueField = "ID";
break;
case "Staff":
_bll.Model.ParamName = "@Staff";
_bll.Model.DisplayName = "员工";
_bll.Model.DataType = 1;
_bll.Model.DefaultValue = "$StaffID$";
_bll.Model.ControlType = 6;
_bll.Model.SearchPageURL = "~/SubModule/StaffManage/Pop_Search_Staff.aspx";
_bll.Model["ControlWidth"] = "260";
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_SYS.dbo.Org_Staff";
_bll.Model.RelationTextField = "RealName";
_bll.Model.RelationValueField = "ID";
break;
case "Retailer":
_bll.Model.ParamName = "@ClientID";
_bll.Model.DisplayName = "零售商";
_bll.Model.DataType = 1;
_bll.Model.ControlType = 6;
_bll.Model.SearchPageURL = "~/SubModule/CM/PopSearch/Search_SelectClient.aspx?ClientType=3";
_bll.Model["ControlWidth"] = "260";
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_CM.dbo.CM_Client";
_bll.Model.RelationTextField = "FullName";
_bll.Model.RelationValueField = "ID";
break;
case "Distributor":
_bll.Model.ParamName = "@ClientID";
_bll.Model.DisplayName = "经销商";
_bll.Model.DataType = 1;
_bll.Model.ControlType = 6;
_bll.Model.SearchPageURL = "~/SubModule/CM/PopSearch/Search_SelectClient.aspx?ClientType=2";
_bll.Model["ControlWidth"] = "260";
_bll.Model.RelationType = 2;
_bll.Model.RelationTableName = "MCS_CM.dbo.CM_Client";
_bll.Model.RelationTextField = "FullName";
_bll.Model.RelationValueField = "ID";
break;
case "BeginDate":
_bll.Model.ParamName = "@BeginDate";
_bll.Model.DisplayName = "开始日期";
_bll.Model.DataType = 4;
_bll.Model.ControlType = 2;
_bll.Model["ControlWidth"] = "70";
_bll.Model.RelationType = 1;
_bll.Model.DefaultValue = "$ThisMonthFirstDay$";
break;
case "EndDate":
_bll.Model.ParamName = "@EndDate";
_bll.Model.DisplayName = "截止日期";
_bll.Model.DataType = 4;
_bll.Model.ControlType = 2;
_bll.Model["ControlWidth"] = "70";
_bll.Model.RelationType = 1;
_bll.Model.DefaultValue = "$Today$";
break;
default:
break;
}
if (_bll.Add() == 0)
{
MessageBox.ShowAndRedirect(this, "新增成功!", "Rpt_DataSetParamsDetail.aspx?ID=" + _bll.Model.ID.ToString());
}
}
protected void bt_OK_Click(object sender, EventArgs e)
{
new Rpt_DataSetBLL((Guid)ViewState["DataSet"]).ClearCache();
Rpt_DataSetParamsBLL _bll;
if ((Guid)ViewState["ID"] != Guid.Empty)
{
//修改
_bll = new Rpt_DataSetParamsBLL((Guid)ViewState["ID"]);
}
else
{
//新增
_bll = new Rpt_DataSetParamsBLL();
_bll.Model.DataSet = (Guid)ViewState["DataSet"];
}
pl_detail.GetData(_bll.Model);
#region 判断必填项
#endregion
#region 参数数据源关联类型
_bll.Model.RelationType = int.Parse(rbl_RelationType.SelectedValue);
if (ddl_RelationTableName.Visible)
{
_bll.Model.RelationTableName = ddl_RelationTableName.SelectedValue;
}
else
{
_bll.Model.RelationTableName = "";
}
if (ddl_RelationTextField.Visible)
{
_bll.Model.RelationTextField = ddl_RelationTextField.SelectedValue;
}
else
{
_bll.Model.RelationTextField = "";
}
if (ddl_RelationValueField.Visible)
{
_bll.Model.RelationValueField = ddl_RelationValueField.SelectedValue;
}
else
{
_bll.Model.RelationValueField = "";
}
#endregion
if ((Guid)ViewState["ID"] != Guid.Empty)
{
//修改
if (_bll.Update() == 0)
{
MessageBox.ShowAndRedirect(this, "修改成功!", "Rpt_DataSetParamsList.aspx?ID=" + _bll.Model.DataSet.ToString());
}
}
else
{
//新增
if (_bll.Add() == 0)
{
MessageBox.ShowAndRedirect(this, "新增成功!", "Rpt_DataSetParamsList.aspx?ID=" + _bll.Model.DataSet.ToString());
}
}
}