/// <summary>
/// 获得部门最大排序号
/// </summary>
/// <returns></returns>
public static int GetMaxSortIndex()
{
string sql = "SELECT MAX(sortIndex) + 1 FROM UT_SYS_OU";
DataTable dt = NDDBAccess.Fill(sql);
return(NDConvert.ToInt32(dt.Rows[0][0].ToString()));
}
/// <summary>
/// 数据行操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = NDConvert.ToInt32(e.CommandArgument);
string GiftID = grid.DataKeys[rowIndex]["ID"].ToString();
switch (e.CommandName)
{
case "Status":
GiftsEntity entity = new GiftsEntity(GiftID);
if (entity.Status == (int)CommonEnum.GiftStatus.Close)
{
entity.Status = (int)CommonEnum.GiftStatus.Online;
}
else
{
entity.Status = (int)CommonEnum.GiftStatus.Close;
}
entity.UpdateTime = DateTime.Now;
new GiftsRule().Update(entity);
PageHelper.ShowMessage("状态更改成功！");
BindGridView();
break;
case "View":
PageHelper.WriteScript("window.open('../../Web/Gifts/ImagePhoto.aspx?ID=" + GiftID + "');");
break;
}
}
/// <summary>
/// 保存
/// </summary>
private void Save()
{
GiftsEntity entity = new GiftsEntity();
Stream fileStream = fuPicture.PostedFile.InputStream;
byte[] FileContent = new byte[fileStream.Length];
fileStream.Read(FileContent, 0, FileContent.Length);
fileStream.Close();
byte[] LittlePicture = FileContent;
entity.ID = Guid.NewGuid().ToString();
entity.GiftName = txtGiftName.Text.Trim();
entity.NeedPoint = NDConvert.ToInt32(txtNeedPoints.Text.Trim());
entity.RemainAmount = NDConvert.ToInt32(txtRemainAmount.Text.Trim());
entity.Description = txtDescription.Text.Trim();
entity.Status = (int)CommonEnum.GiftStatus.Close;
entity.CreateTime = DateTime.Now;
if (FileContent.Length > 0)
{
entity.Picture = FileContent;
}
new GiftsRule().Add(entity);
}
/// <summary>
/// 获取url参数
/// </summary>
public void LoadGetUrlPara()
{
if (!string.IsNullOrEmpty(Request.QueryString["userid"]))
{
UserID = NDConvert.ToInt64(Request.QueryString["userid"]);
}
}
/// <summary>
/// 部门下拉框
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void drpOUList_SelectedIndexChanged(object sender, EventArgs e)
{
if (drpOUList.SelectedIndex == 0)
{
drpChildList.Visible = false;
}
else
{
if (new OUQuery().IsOUParent(NDConvert.ToInt64(drpOUList.SelectedValue)))
{
drpChildList.Visible = true;
BindOUList(NDConvert.ToInt64(drpOUList.SelectedValue));
}
else
{
drpChildList.Visible = false;
if (drpOUList.SelectedIndex != 0)
{
drpPersonList.Enabled = true;
BindPerson(NDConvert.ToInt64(drpOUList.SelectedValue), 0);
BindTreeView();
}
else
{
drpPersonList.Enabled = false;
tvRight.ClearAll();
}
}
}
}
/// <summary>
/// 邦定人员
/// </summary>
private void BindPerson(long OUID, int flag)
{
drpPersonList.Items.Clear();
DataTable dt = null;
if (flag == 0)
{
if (OUID == 0)
{
dt = new UserQuery().GetRightOUUser(NDConvert.ToInt64(drpOUList.SelectedValue));
}
else
{
dt = new UserQuery().GetRightOUUser(OUID);
}
}
else
{
if (OUID == 0)
{
dt = new UserQuery().GetRightOUUser(NDConvert.ToInt64(drpChildList.SelectedValue));
}
else
{
dt = new UserQuery().GetRightOUUser(OUID);
}
}
NDHelperWebControl.LoadDropDownList(drpPersonList, dt, "UserName", "UserID", new ListItem("请选择", "0"));
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnQuery_Click(object sender, EventArgs e)
{
if (!CheckData())
{
PageHelper.ShowExceptionMessage(hidInfo.Value);
return;
}
viewpage1.CurrentPageIndex = 1;
this.SurveyName = txtSurveyName.Text.Trim();
this.State = NDConvert.ToInt32(ddlState.SelectedValue);
this.Active = NDConvert.ToInt32(ddlActive.SelectedValue);
this.ClassID = NDConvert.ToInt32(ddlSurveyClass.SelectedValue);
this.BeginDate = NDConvert.ToDateTime(wdcBeginDate.Value);
if (NDConvert.ToDateTime(wdcEndDate.Value) == NDConvert.ToDateTime("1900-1-1"))
{
this.EndDate = NDConvert.ToDateTime("2999-12-31");
}
else
{
this.EndDate = NDConvert.ToDateTime(wdcEndDate.Value);
}
BindGridView();
}
/// <summary>
/// toolbar
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void toolbar_MenuItemClick(object sender, MenuEventArgs e)
{
switch (e.Item.Value)
{
case "Delete":
int succeed = 0;
for (int i = 0; i < grid.Rows.Count; i++)
{
CheckBox chkItem = (CheckBox)grid.Rows[i].FindControl("chkItem");
if (chkItem != null && chkItem.Checked == true)
{
this.FID = NDConvert.ToInt64(grid.DataKeys[i]["FID"].ToString());
MenuFunctionEntity entity = new MenuFunctionEntity(FID);
entity.IsDeleted = true;
new MenuFunctionRule().Update(entity);
succeed++;
}
}
if (succeed > 0)
{
BindGridView();
PageHelper.ShowMessage("删除成功！");
}
break;
}
}
public static int GetMaxSortIndex(long OUParentID)
{
string sql = string.Format("SELECT MAX(sortIndex) + 1 FROM UT_SYS_OU where OUParentID={0}", OUParentID);
DataTable dt = NDDBAccess.Fill(sql);
return(NDConvert.ToInt32(dt.Rows[0][0].ToString()));
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
int RowIndex = NDConvert.ToInt32(e.CommandArgument.ToString());
this.CodeDetailID = NDConvert.ToInt64(grid.DataKeys[RowIndex].Values["CodeDetailID"].ToString());
CodeDetailEntity entity = new CodeDetailEntity(CodeDetailID);
switch (e.CommandName)
{
case "Modify":
txtCodeDetailName.Text = entity.CodeDetailName;
txtCodeDetailValue.Text = entity.CodeDetailValue;
txtDetailMemo.Text = entity.DetailMemo;
this.CurOperation = (int)OperationEnum.UPDATE;
break;
case "Del":
entity.IsDeleted = true;
new CodeDetailRule().Update(entity);
txtCodeDetailName.Text = "";
txtCodeDetailValue.Text = "";
txtDetailMemo.Text = "";
BindGridView();
this.CurOperation = (int)OperationEnum.INSERT;
this.CodeDetailID = 0;
PageHelper.ShowMessage("删除成功！");
break;
}
}
/// <summary>
/// toolbar事件
/// 作者：姚东
/// 时间：20101025
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void toolbar_MenuItemClick(object sender, MenuEventArgs e)
{
switch (e.Item.Value)
{
case "Delete":
string cid = "";
int count = 0;
int num = 0;
for (int i = 0; i < grid.Rows.Count; i++)
{
CheckBox chkItem = (CheckBox)grid.Rows[i].FindControl("chkItem");
if (chkItem != null && chkItem.Checked == true)
{
count++;
cid = grid.DataKeys[i]["CID"].ToString();
SurveyClassEntity entity = new SurveyClassEntity(NDConvert.ToInt64(cid));
new SurveyClassRule().Delete(entity);
}
}
if (count == this.grid.Rows.Count)
{
viewpage1.CurrentPageIndex = viewpage1.CurrentPageIndex == 1 ? 1 : viewpage1.CurrentPageIndex - 1;
}
BindGridView();
PageHelper.ShowMessage("停用成功！");
if (num > 0)
{
PageHelper.ShowExceptionMessage("部分(已审核、禁用)信息无法停用！");
}
break;
}
}
/// <summary>
/// 邦定GridView
/// </summary>
private void BindGridView()
{
long UserID = NDConvert.ToInt64(Session["UserID"]); //当前管理操作的中
DataSet ds = GetData(UserID.ToString());
DataTable dt = ds.Tables[1];
grid.DataSource = dt;
grid.DataBind();
BindviewPage(NDConvert.ToInt32(ds.Tables[0].Rows[0][0].ToString()));
for (int i = 0; i < grid.Rows.Count; i++)
{
long ID = NDConvert.ToInt64(grid.DataKeys[i]["SID"].ToString());
DataTable GetSurveyInfo = new SurveyManage_Layer().GetSurveyTable(ID.ToString(), UserID.ToString());
//编辑
//LinkButton objEdit = (LinkButton)grid.Rows[i].Cells[10].Controls[0];
//System.Web.UI.WebControls.Image image2 = new System.Web.UI.WebControls.Image();
//image2.Style.Add("margin", "0");
//image2.ImageUrl = "images/edit2.gif";
//objEdit.Text = "编辑";
//grid.Rows[i].Cells[10].Controls.AddAt(0, image2);
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnQuery_Click(object sender, EventArgs e)
{
viewpage1.CurrentPageIndex = 1;
this.TxtSurveyName = txtSurveyName.Text.Trim();
if (!string.IsNullOrEmpty(getBackNum.Text.Trim()))
{
this.GetBackNum = NDConvert.ToInt32(getBackNum.Text.Trim());
}
else
{
this.GetBackNum = -1;
}
if (!string.IsNullOrEmpty(ddlSurveyClass.Text.Trim()))
{
this.DdlSurveyClass = NDConvert.ToInt32(ddlSurveyClass.Text.Trim());
}
else
{
this.DdlSurveyClass = -1;
}
this.WdcBeginDate = NDConvert.ToDateTime(wdcBeginDate.Value);
if (NDConvert.ToDateTime(wdcEndDate.Value) == NDConvert.ToDateTime("1900-1-1"))
{
this.WdcEndDate = NDConvert.ToDateTime("2999-12-31");
}
else
{
this.WdcEndDate = NDConvert.ToDateTime(wdcEndDate.Value);
}
BindGridView();
}
/// <summary>
/// 邦定GridView
/// </summary>
private void BindGridView()
{
DataSet ds = GetData();
DataTable dt = ds.Tables[1];
grid.DataSource = dt;
grid.DataBind();
BindviewPage(NDConvert.ToInt32(ds.Tables[0].Rows[0][0].ToString()));
for (int i = 0; i < grid.Rows.Count; i++)
{
LinkButton obj = (LinkButton)grid.Rows[i].Cells[8].Controls[0];
if (NDConvert.ToInt32(grid.DataKeys[i]["Status"].ToString()) == (int)CommonEnum.GiftExchangeStatus.ForExchange)
{
obj.Text = "同意兑换";
obj.Enabled = true;
//obj.Attributes.Add("onclick", "if(confirm('确认要进行此次礼品兑换么？')==true）return true; else return false;");
obj.Attributes.Add("onclick", "return ConfirmExchange();");
}
else if (NDConvert.ToInt32(grid.DataKeys[i]["Status"].ToString()) == (int)CommonEnum.GiftExchangeStatus.HasExchange)
{
obj.Text = "已兑换";
obj.Enabled = false;
}
else
{
obj.Text = "已放弃";
obj.Enabled = false;
}
}
}
/// <summary>
/// 获取最大排序号
/// </summary>
/// <returns></returns>
public static int MaxSortIndex(long MenuID)
{
string sql = "SELECT MAX(SortIndex) FROM UT_SYS_MenuFunction WHERE IsDeleted = 0 AND MenuID = " + MenuID;
DataTable dt = NDDBAccess.Fill(sql);
return(NDConvert.ToInt32(dt.Rows[0][0].ToString()) + 1);
}
/// <summary>
/// 保存
/// </summary>
private void Save()
{
PartnerEntity entity = new PartnerEntity();
Stream fileStream = fuPicture.PostedFile.InputStream;
byte[] FileContent = new byte[fileStream.Length];
fileStream.Read(FileContent, 0, FileContent.Length);
fileStream.Close();
byte[] LittlePicture = FileContent;
entity.ID = Guid.NewGuid().ToString();
entity.Name = txtName.Text.Trim();
entity.URL = txtURL.Text.Trim();
if (txtSort.Text.Trim() == "")
{
entity.sort = 0;
}
else
{
entity.sort = NDConvert.ToInt32(txtSort.Text.Trim());
}
entity.Status = (int)CommonEnum.PartnerStatus.Online;
if (FileContent.Length > 0)
{
entity.Image = FileContent;
}
new PartnerRule().Add(entity);
}
/// <summary>
/// 数据行操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = NDConvert.ToInt32(e.CommandArgument);
string partnerID = grid.DataKeys[rowIndex]["ID"].ToString();
switch (e.CommandName)
{
case "Status":
PartnerEntity entity = new PartnerEntity(partnerID);
if (entity.Status == (int)CommonEnum.PartnerStatus.Offline)
{
entity.Status = (int)CommonEnum.PartnerStatus.Online;
}
else
{
entity.Status = (int)CommonEnum.PartnerStatus.Offline;
}
new PartnerRule().Update(entity);
PageHelper.ShowMessage("状态更改成功！");
BindGridView();
break;
case "View":
PageHelper.WriteScript("window.open('ImagePhoto.aspx?ID=" + partnerID + "');");
break;
}
}
/// <summary>
/// 获得URL参数
/// </summary>
private void GetUrlParameter()
{
if (Request.QueryString["ID"] != null && Request.QueryString["ID"] != "")
{
this.CodeGroupID = NDConvert.ToInt64(Request.QueryString["ID"].ToString());
}
}
/// <summary>
/// toolbar事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void toolbar_MenuItemClick(object sender, MenuEventArgs e)
{
switch (e.Item.Value)
{
case "Delete":
for (int i = 0; i < grid.Rows.Count; i++)
{
CheckBox chkItem = (CheckBox)grid.Rows[i].FindControl("chkItem");
if (chkItem != null && chkItem.Checked == true)
{
this.CodeDetailID = NDConvert.ToInt64(grid.DataKeys[i]["CodeDetailID"].ToString());
CodeDetailEntity entity = new CodeDetailEntity(CodeDetailID);
entity.IsDeleted = true;
new CodeDetailRule().Update(entity);
}
}
this.CurOperation = (int)OperationEnum.INSERT;
this.CodeDetailID = 0;
txtCodeDetailName.Text = "";
txtCodeDetailValue.Text = "";
txtDetailMemo.Text = "";
BindGridView();
PageHelper.ShowMessage("删除成功！");
break;
}
}
public void initToolBar()
{
if (!IsPostBack)
{
long UserID = NDConvert.ToInt64(Session["UserID"]); //当前管理操作的中
if (UserID > 0)
{
int userType = ConvertInt(new SurveyManage_Layer().GetUserType(ConvertString(UserID)));
if (userType == (int)CommonEnum.QSUserType.AdminUserType)
{
MenuItem Pass = new MenuItem();
Pass.Text = "审批通过";
Pass.Value = "Pass";
Pass.ImageUrl = "../web/Images/icon/accept.png";
MenuItem Invalid = new MenuItem();
Invalid.Text = "审批退回";
Invalid.Value = "Invalid";
Invalid.ImageUrl = "../web/Images/icon/arrow_undo.png";
this.toolbar.Items.Add(Pass);
this.toolbar.Items.Add(Invalid);
}
else if (userType == (int)CommonEnum.QSUserType.CommonUserType)
{
}
MenuItem ReInput = new MenuItem();
ReInput.Text = "重新提交审批";
ReInput.Value = "ReInput";
ReInput.ImageUrl = "../web/Images/icon/arrow_redo.jpg";
this.toolbar.Items.Add(ReInput);
}
}
}
/// <summary>
/// 修改
/// </summary>
private void Update()
{
PartnerEntity entity = new PartnerEntity(this.PartnerID);
if (fuPicture.PostedFile.ContentLength > 0)
{
Stream fileStream = fuPicture.PostedFile.InputStream;
byte[] FileContent = new byte[fileStream.Length];
fileStream.Read(FileContent, 0, FileContent.Length);
fileStream.Close();
byte[] LittlePicture = FileContent;
entity.Image = LittlePicture;
}
entity.Name = txtName.Text.Trim();
entity.URL = txtURL.Text.Trim();
if (txtSort.Text.Trim() == "")
{
entity.sort = 0;
}
else
{
entity.sort = NDConvert.ToInt32(txtSort.Text.Trim());
}
new PartnerRule().Update(entity);
}
/// <summary>
/// 数据行操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = NDConvert.ToInt32(e.CommandArgument);
long ID = NDConvert.ToInt64(grid.DataKeys[rowIndex]["ID"].ToString());
ExchangeEntity entity = new ExchangeEntity(ID);
switch (e.CommandName)
{
case "Status":
//GiftsEntity entity = new GiftsEntity(GiftID);
if (entity.Status == (int)CommonEnum.GiftExchangeStatus.ForExchange)
{
entity.Status = (int)CommonEnum.GiftExchangeStatus.HasExchange;
entity.ExchangeTime = DateTime.Now;
new ExchangeRule().Update(entity);
new HuiYuanRule().UpdateRemainPoint(entity.HuiYuanGuid, entity.UsedPoint);
PageHelper.ShowMessage("状态更改成功！");
BindGridView();
}
break;
case "View":
PageHelper.WriteScript("window.open('../../Web/Gifts/ImagePhoto.aspx?ID=" + entity.GiftGuid + "');");
break;
}
}
/// <summary>
/// 获取调查问卷的数量
/// 作者：姚东
/// 时间：20100925
/// </summary>
/// <returns></returns>
public int GetSurveyAmount()
{
string sql = @"SELECT count(1) FROM UV_QS_SurveyTable WHERE State=1 and Active=1 and
datediff(day,getdate(),isnull(EndDate,'2199-12-31'))>=0
and (MaxAnswerAmount=0 or MaxAnswerAmount<>0 and AnswerAmount<MaxAnswerAmount) and ApprovalStaus=1";
return(NDConvert.ToInt32(NDDBAccess.Fill(sql).Rows[0][0]));
}
/// <summary>
/// toolbar事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void toolbar_MenuItemClick(object sender, MenuEventArgs e)
{
long ID = 0;
switch (e.Item.Value)
{
case "Delete":
if (e.Item.Value == "Delete")
{
for (int i = 0; i < tvOU.CheckedNodes.Count; i++)
{
Infragistics.WebUI.UltraWebNavigator.Node tn = (Infragistics.WebUI.UltraWebNavigator.Node)tvOU.CheckedNodes[i];
if (tn.Nodes.Count > 0)
{
PageHelper.ShowExceptionMessage("选择删除的部门中不能包含有下级部门！");
return;
}
if (UserQuery.IsHavePerson(NDConvert.ToInt64(tn.DataKey.ToString())))
{
PageHelper.ShowExceptionMessage("选择删除的部门中有人员,请先删除人员后再删除部门！");
return;
}
}
for (int j = 0; j < tvOU.CheckedNodes.Count; j++)
{
Infragistics.WebUI.UltraWebNavigator.Node tn = (Infragistics.WebUI.UltraWebNavigator.Node)tvOU.CheckedNodes[j];
OUEntity entity = new OUEntity(NDConvert.ToInt64(tn.DataKey.ToString()));
entity.UpdateDate = DateTime.Now;
entity.IsDeleted = true;
new OURule().Update(entity);
}
BindTreeView();
PageHelper.ShowMessage("删除成功！");
}
break;
case "Add":
if (tvOU.CheckedNodes.Count > 0)
{
int tnLevel = ((Infragistics.WebUI.UltraWebNavigator.Node)tvOU.CheckedNodes[0]).Level;
if (tnLevel >= 3)
{
PageHelper.ShowExceptionMessage("此处部门树视图只支持到4层！");
return;
}
ID = NDConvert.ToInt64(((Infragistics.WebUI.UltraWebNavigator.Node)tvOU.CheckedNodes[0]).DataKey.ToString());
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "add", "showModalWindow('OUDetailLY', '添加',600, 450, '../../web/SysManager/OUDetail.aspx?Operation=1&ID=' + " + ID + ");", true);
break;
case "Update":
ID = NDConvert.ToInt64(((Infragistics.WebUI.UltraWebNavigator.Node)tvOU.CheckedNodes[0]).DataKey.ToString());
Page.ClientScript.RegisterStartupScript(this.GetType(), "update", "showModalWindow('OUDetailLY', '修改',600, 450, '../../web/SysManager/OUDetail.aspx?Operation=2&ID=' + " + ID + ");", true);
break;
}
}
/// <summary>
/// 绑定
/// </summary>
private void BindGridView()
{
DataSet ds = GetData();
DataTable dt = ds.Tables[1];
grid.DataSource = dt;
grid.DataBind();
BindviewPage(NDConvert.ToInt32(ds.Tables[0].Rows[0][0].ToString()));
}
/// <summary>
/// 获得列合计数据
/// </summary>
/// <param name="dt"></param>
/// <param name="ColumnName"></param>
/// <returns></returns>
public static int StatColumn(DataTable dt, string ColumnName)
{
int Sum = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
Sum += NDConvert.ToInt32(dt.Rows[i][ColumnName].ToString());
}
return(Sum);
}
/// <summary>
/// 数据行操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = NDConvert.ToInt32(e.CommandArgument);
switch (e.CommandName)
{
case "SurveyName":
break;
}
}
/// <summary>
/// toolbar事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void toolbar_MenuItemClick(object sender, MenuEventArgs e)
{
switch (e.Item.Value)
{
case "Delete":
long ID = 0;
int count = 0;
bool hasValidData = false;
for (int i = 0; i < grid.Rows.Count; i++)
{
CheckBox chkItem = (CheckBox)grid.Rows[i].FindControl("chkItem");
if (chkItem != null && chkItem.Checked == true)
{
count++;
ID = NDConvert.ToInt64(grid.DataKeys[i]["ID"].ToString());
ExchangeEntity entity = new ExchangeEntity(ID);
if (entity.Status == (int)CommonEnum.GiftExchangeStatus.ForExchange)
{
hasValidData = true;
//更新礼品兑换状态
entity.Status = (int)CommonEnum.GiftExchangeStatus.HasDrop;
new ExchangeRule().Update(entity);
//更新会员积分
PointEntity pointEntity = new PointEntity(entity.HuiYuanGuid);
pointEntity.RemainPoint += entity.UsedPoint;
new PointRule().Update(pointEntity);
//更新礼品余量
GiftsEntity giftsEntity = new GiftsEntity(entity.GiftGuid);
giftsEntity.RemainAmount += 1;
new GiftsRule().Update(giftsEntity);
}
}
}
if (count == this.grid.Rows.Count)
{
viewpage1.CurrentPageIndex = viewpage1.CurrentPageIndex == 1 ? 1 : viewpage1.CurrentPageIndex - 1;
}
BindGridView();
if (hasValidData)
{
PageHelper.ShowMessage("操作成功！");
}
else
{
PageHelper.ShowExceptionMessage("不能对该记录进行取消操作！");
}
break;
}
}
/// <summary>
/// 检查代码名称是否已经存在
/// </summary>
/// <returns></returns>
public static bool IsExisitCode(long MenuID, string FCode)
{
string sql = "SELECT COUNT(*) FROM UT_SYS_MenuFunction WHERE IsDeleted = 0 AND MenuID = " + MenuID + " AND FCode = '" + FCode + "'";
DataTable dt = NDDBAccess.Fill(sql);
if (NDConvert.ToInt64(dt.Rows[0][0].ToString()) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 获得URL参数
/// 作者：姚东
/// 时间：20101027
/// </summary>
private void GetUrlParameter()
{
if (Request.QueryString["Operation"] != null && Request.QueryString["Operation"] != "")
{
this.CurOperation = NDConvert.ToInt32(Request.QueryString["Operation"].ToString());
}
if (Request.QueryString["ID"] != null && Request.QueryString["ID"] != "")
{
this.CID = NDConvert.ToInt64(Request.QueryString["ID"]);
}
}
