/// <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>
/// 数据行操作
/// </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>
/// <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>
/// 保存
/// </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>
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>
/// 邦定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>
/// <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>
/// 邦定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 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>
/// 获得部门最大排序号
/// </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 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>
/// 保存
/// </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);
}
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>
/// <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>
/// 获取调查问卷的数量
/// 作者：姚东
/// 时间：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>
/// 绑定
/// </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="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>
/// 获得列合计数据
/// </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>
/// <returns></returns>
public static bool CheckMenuFunctionRight(long UserID, long MenuID, long FID)
{
string sql = "SELECT COUNT(*) FROM UT_SYS_MenuFunctionRight WHERE UserID = " + UserID + " AND MenuID = " + MenuID + " AND FID = " + FID;
DataTable dt = NDDBAccess.Fill(sql);
if (NDConvert.ToInt32(dt.Rows[0][0].ToString()) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 根据菜单类型获得用户操作菜单
/// </summary>
/// <param name="Account"></param>
/// <returns></returns>
public static bool IsHaveChileMenu(long parentMenuID)
{
string sql = "SELECT COUNT(*) FROM UT_SYS_Menu WHERE IsDeleted = 0 AND ParentMenuID = " + parentMenuID;
DataTable dt = NDDBAccess.Fill(sql);
if (NDConvert.ToInt32(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"]);
}
}
/// <summary>
/// 判断部门是否有人员
/// </summary>
/// <param name="OUID"></param>
/// <returns></returns>
public static bool IsHavePerson(long OUID)
{
string sql = "SELECT COUNT(*) FROM UT_SYS_User WHERE IsDeleted = 0 AND OUID = " + OUID;
DataTable dt = NDDBAccess.Fill(sql);
if (NDConvert.ToInt32(dt.Rows[0][0].ToString()) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 判断某代码组是否存在代码信息
/// </summary>
/// <param name="CodeGroupID"></param>
/// <returns></returns>
public static bool IsExistCode(long CodeGroupID)
{
string sql = "SELECT count(*) FROM UT_SYS_Code WHERE IsDeleted = 0 AND CodeGroupID = " + CodeGroupID;
DataTable dt = NDDBAccess.Fill(sql);
if (NDConvert.ToInt32(dt.Rows[0][0].ToString()) > 0)
{
return(true);
}
return(false);
}
/// <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.Name = txtName.Text.Trim();
this.Status = NDConvert.ToInt32(ddlStatus.SelectedValue);
BindGridView();
}
/// <summary>
/// 更新
/// </summary>
private void Update()
{
UserEntity entity = new UserEntity(SessionState.UserID);
entity.UserName = txtUserName.Text.Trim();
entity.Sex = NDConvert.ToInt32(rdolstSex.SelectedValue);
entity.Email = txtEmail.Text.Trim();
entity.OfficePhone = txtOfficePhone.Text.Trim();
entity.MobilePhone = txtMobilePhone.Text.Trim();
entity.UpdateDate = DateTime.Now;
new UserRule().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]["SID"].ToString());
SurveyTableEntity entity = new SurveyTableEntity(ID);
int count = 0;
switch (e.CommandName)
{
case "SurveyName":
string urlAnswer = string.Format("ClientPs.aspx?SID={0}&AnswerGUID={1}", ID, ConvertString(grid.DataKeys[rowIndex]["AnswerGUID"]));
PageHelper.WriteScript(string.Format("window.open('{0}');", urlAnswer));
if (count == this.grid.Rows.Count)
{
viewpage1.CurrentPageIndex = viewpage1.CurrentPageIndex == 1 ? 1 : viewpage1.CurrentPageIndex - 1;
}
BindGridView();
break;
case "TempPage":
BindGridView();
break;
case "Statistics":
BindGridView();
break;
case "Options":
BindGridView();
break;
case "Editer":
BindGridView();
break;
case "DeleteAnswer":
//int count = 0;
string AnswerGuid = ConvertString(grid.DataKeys[rowIndex]["AnswerGUID"]);
//new AnswerManager_Layer().DeleteAnswer(AnswerGuid); //彻底删除答卷
int ReturnNum = new AnswerManager_Layer().SetApprovalStaus("3", AnswerGuid);
new AnswerManager_Layer().UpdateAnswerNum(ReturnNum, ID.ToString());
if (count == this.grid.Rows.Count)
{
viewpage1.CurrentPageIndex = viewpage1.CurrentPageIndex == 1 ? 1 : viewpage1.CurrentPageIndex - 1;
}
BindGridView();
break;
}
}
/// <summary>
/// 生成最新排序号
/// </summary>
/// <returns></returns>
public static int GetMaxSortIndex()
{
int MaxSortIndex = 1;
string sql = "SELECT MAX(SortIndex) + 1 AS MaxSortIndex FROM UT_SYS_User";
DataTable dt = NDDBAccess.Fill(sql);
if (dt.Rows.Count > 0)
{
MaxSortIndex = NDConvert.ToInt32(dt.Rows[0]["MaxSortIndex"].ToString());
}
return(MaxSortIndex);
}
/// <summary>
/// 获得配置文件配置值(整型)
/// </summary>
/// <param name="Key"></param>
/// <returns></returns>
public static int GetConfigValueInt(string Key)
{
try
{
string Value = ConfigurationManager.AppSettings[Key];
return(NDConvert.ToInt32(Value));
}
catch
{
throw new Exception("未找到" + Key + "配置信息,或配置值错误！");
}
}
/// <summary>
/// 判断用户是否具有某项功能
/// </summary>
/// <returns></returns>
public static bool CheckRightFunction(long UserID, long MenuID, string toolbarItem)
{
string sql = "SELECT COUNT(*) " +
"FROM UT_SYS_MenuFunctionRight INNER JOIN " +
"UT_SYS_MenuFunction ON " +
"UT_SYS_MenuFunctionRight.FID = UT_SYS_MenuFunction.FID WHERE FCode = '" + toolbarItem + "' AND UserID = " + UserID + " AND UT_SYS_MenuFunctionRight.MenuID = " + MenuID;
DataTable dt = NDDBAccess.Fill(sql);
if (NDConvert.ToInt32(dt.Rows[0][0].ToString()) > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 检测代码组代码是否存在相同代码
/// </summary>
/// <param name="Account"></param>
/// <param name="userID"></param>
/// <param name="Operation"></param>
/// <returns></returns>
public static bool CheckCodeGroupKey(string CodeGroupKey, long CodeGroupID, int Operation)
{
string sql = "SELECT COUNT(*) FROM UT_SYS_CodeGroup WHERE IsDeleted = 0 AND CodeGroupKey = '" + CodeGroupKey + "'";
if (Operation == 2)
{
sql += " AND CodeGroupID <> " + CodeGroupID;
}
DataTable dt = NDDBAccess.Fill(sql);
if (NDConvert.ToInt32(dt.Rows[0][0].ToString()) > 0)
{
return(true);
}
return(false);
}
