protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (CurrentUser.RightIsAdmin || CurrentUser.HasFactoryAdminRole())
{
if (CurrentUser.RightCanDelete || CurrentUser.RightIsCurrentFactoryAdmin)
{
buttonDelete.Visible = true;
}
else
{
buttonDelete.Visible = false;
}
DataSet ds = new DataSet();
#region 工厂数据绑定
ds.ReadXml(Server.MapPath("..") + "\\ERPReportFactory.xml");
dropDownListFactory.DataSource = ds;
dropDownListFactory.DataTextField = "Name";
dropDownListFactory.DataValueField = "Value";
dropDownListFactory.DataBind();
if (dropDownListFactory.Items.Count == 0)
{
dropDownListFactory.Items.Add(new ListItem("暂无工厂", "0"));
}
else if (!CurrentUser.RightIsAdmin)
{
for (int i = dropDownListFactory.Items.Count - 1; i >= 0; i--)
{
int tmpID = Convert.ToInt32(dropDownListFactory.Items[i].Value);
if (!CurrentUser.FactoryIDList.Contains(tmpID) || (CurrentUser.FactoryIDList.Contains(tmpID) && CurrentUser.UseTypeList[CurrentUser.FactoryIDList.IndexOf(tmpID)] == 0))
{
dropDownListFactory.Items.Remove(dropDownListFactory.Items[i]);
}
}
}
dropDownListFactory.SelectedIndex = 0;
#endregion
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
labelTitle.Text = "修改ERP辅助功能";
int ID = Convert.ToInt32(Request.QueryString["ID"]);
dropDownListFactory.Enabled = false;
buttonCopy.Visible = true;
InfoSysEntityTableAdapters.SQLReportTableAdapter sqlAdapter = new InfoSysEntityTableAdapters.SQLReportTableAdapter();
InfoSysEntity.SQLReportDataTable curTable = sqlAdapter.SelectByID(ID);
foreach (InfoSysEntity.SQLReportRow curRow in curTable.Rows)
{
textBoxName.Text = curRow.SQLReportName;
textBoxShowURL.Text = (curRow.SQLReportShowURL.GetType() == typeof(DBNull)) ? "" : curRow.SQLReportShowURL;
dropDownListReportCate.SelectedValue = curRow.SQLReportCate.ToString();
dropDownListFactory.SelectedValue = curRow.SQLReportFactory.ToString();
textBoxSortIndex.Text = curRow.SQLReportSortIndex.ToString();
rightTable = new InfoSysEntityTableAdapters.ERPAddinRightTableAdapter().GetDataBySQLReportID(curRow.SQLReportID);
break;
}
}
else
{
buttonCopy.Visible = false;
buttonDelete.Visible = false;
}
departmentDatabinding();
rightTableDataBing();
}
else
{
FounderTecInfoSys.Common.PageGeneralAction.GoBackShowWarmingWindow("您没有权限查看此页面,开通权限请与管理员联系");
Response.End();
}
}
}
protected void buttonSave_Click(object sender, EventArgs e)
{
string strReportName = textBoxName.Text.Trim();
string strShowURL = textBoxShowURL.Text.Trim();
if (strReportName.Equals(string.Empty))
{
FounderTecInfoSys.Common.PageGeneralAction.ShowWarmingWindow("功能名称不能为空");
textBoxName.Focus();
return;
}
int sortIndex = Convert.ToInt32(textBoxSortIndex.Text);
int factoryID = Convert.ToInt32(dropDownListFactory.SelectedValue);
int reportCate = Convert.ToInt32(dropDownListReportCate.SelectedValue);
string strCreator = System.Web.HttpContext.Current.User.Identity.Name.Trim();
DateTime dtTime = DateTime.Now;
int reportStatus = Convert.ToInt32(radioButtonListReportStatus.SelectedValue);
InfoSysEntityTableAdapters.ERPAddinRightTableAdapter rightAdapter = new InfoSysEntityTableAdapters.ERPAddinRightTableAdapter();
int ID = 0;
if (actionType.ToLower().Trim().Equals("normal") && !string.IsNullOrEmpty(Request.QueryString["ID"]))
{
ID = Convert.ToInt32(Request.QueryString["ID"]);
if (new InfoSysEntityTableAdapters.SQLReportTableAdapter().UpdateQuery(strReportName, reportCate, "", "", "", "", strShowURL, reportStatus, strCreator, dtTime, "", "", 0, "", factoryID, sortIndex, 1, ID) > 0)
{
rightAdapter.DeleteQuery(ID);
//Response.Redirect("InputAddinForm.aspx", true);
}
else
{
FounderTecInfoSys.Common.PageGeneralAction.ShowWarmingWindow("操作出现异常, 请稍后再试");
return;
}
}
else
{
ID = Convert.ToInt32(new InfoSysEntityTableAdapters.SQLReportTableAdapter().InsertQuery(strReportName, reportCate, "", "", "", "", strShowURL, reportStatus, strCreator, strCreator, dtTime, dtTime, "", "", 0, 0, "", factoryID, sortIndex, 1, 1));
if (ID > 0)
{
Response.Write(strJSForRefresh);
//Response.Redirect("InputAddinForm.aspx", true);
}
else
{
FounderTecInfoSys.Common.PageGeneralAction.ShowWarmingWindow("操作出现异常, 请稍后再试");
return;
}
}
if (ID > 0)
{
foreach (InfoSysEntity.ERPAddinRightRow curRow in rightTable.Rows)
{
rightAdapter.InsertQuery(ID, curRow.ERPAddinRightName, strCreator);
}
Response.Write(strJSForRefresh);
}
else
{
FounderTecInfoSys.Common.PageGeneralAction.ShowWarmingWindow("操作出现异常, 请稍后再试");
}
}
