/// <summary>
/// 取消操作
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool QuXiao(int id)
{
SOSOshop.Model.AdminInfo adminInfo = SOSOshop.BLL.AdministrorManager.Get();
string s = string.Format(@"declare @uid int,@Gift_ID int,@Gift_Number decimal,@Integral decimal
if exists(select * from MemberIntegralGiftExchange where [State]<>0 and [id]={0}) begin
update MemberIntegralGiftExchange set ontime=getdate(),Editer={1},[State]=0
where [State]<>0 and [id]={0}
select @uid = uid, @Gift_ID = Gift_ID, @Gift_Number = Gift_Number from MemberIntegralGiftExchange where [id]={0}
select @Integral = Integral * @Gift_Number from MemberIntegralGift where [id]=@Gift_ID
update MemberIntegralGift set Number = Number + @Gift_Number where [id]=@Gift_ID
update MemberIntegral set realityIntegral = realityIntegral + @Integral where [uid]=@uid
end
select @uid,@Integral", id, adminInfo == null ? 0 : adminInfo.AdminId);
SOSOshop.BLL.Db db = new SOSOshop.BLL.Db();
DataSet ds = db.ExecuteDataSet(s);
bool ok = ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && !ds.Tables[0].Rows[0].IsNull(0);
if (ok)
{
int uid = int.Parse(ds.Tables[0].Rows[0][0].ToString());
decimal integral = decimal.Parse(ds.Tables[0].Rows[0][1].ToString());
SOSOshop.BLL.Integral.MemberIntegral bll2 = new SOSOshop.BLL.Integral.MemberIntegral();
bll2.PresentIntegral(uid, Convert.ToInt32(integral), "返还兑换礼品的积分", true);
}
return(ok);
}
protected void Page_Load(object sender, EventArgs e)
{
tablist.Sorting += new GridViewSortEventHandler(tablist_Sorting);
if (!IsPostBack)
{
#region ajax
if (ChangeHope.WebPage.PageRequest.GetFormString("Option") != string.Empty && ChangeHope.WebPage.PageRequest.GetFormString("id") != "")
{
string types = Request["Option"].Trim();
string id = ChangeHope.WebPage.PageRequest.GetFormString("id");
string ids = ChangeHope.WebPage.PageRequest.GetFormString("ids").Trim(',');
int uid = 0; int.TryParse(id, out uid);
//获取上级单位
if (types == "GetParentIncName")
{
if (!string.IsNullOrEmpty(ids))
{
StringBuilder s = new StringBuilder();
DataSet IncNames = bll.ExecuteDataSet("select ID, Name, isnull(BuyFilingStatus,2) from DrugsBase_Enterprise where ID in (" + ids + ")");
if (IncNames != null && IncNames.Tables.Count > 0 && IncNames.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in IncNames.Tables[0].Rows)
{
s.Append("{ID:" + dr[0] + ",Name:'" + dr[1].ToString().Replace("'", "\\'") + "',BuyFilingStatus:" + dr[2] + "},");
}
}
Response.Write("[" + s.ToString().TrimEnd(',') + "]");
}
else if (uid > 0)
{
string s = "";
object IncName = bll.ExecuteScalar("select Name from DrugsBase_Enterprise where ID='" + uid + "'");
if (IncName != null)
{
s = IncName.ToString();
}
Response.Write(s);
}
}
//删除
else if (types == "del")
{
if (isDelete())
{
bool noBecause = ChangeHope.WebPage.PageRequest.GetFormString("noBecause") == "";
if (noBecause && bll.ExecuteScalar("select 1 from orders where ReceiverId in (" + id + ")") != null)
{
Response.Write("noBecauseOrders");
}
else
{
bool ok = false;
if (uid > 0)
{
ok = new SOSOshop.BLL.MemberAccount().Delete(uid);
}
else
{
ok = new SOSOshop.BLL.MemberAccount().DeleteAll(id);
}
Response.Write(ok ? "ok" : "");
if (ok)
{
#region 后台用户操作日志记录
SOSOshop.Model.AdminInfo adminInfo = SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd("删除买家信息", (adminInfo == null ? 0 : adminInfo.AdminId), (adminInfo == null ? "" : adminInfo.AdminName), 1);
#endregion
}
}
}
else
{
Response.Write("no");
}
}
//审核
else if (types == "State")
{
if (isEdit())
{
bool ok = 0 < bll.ExecuteNonQuery("UPDATE memberaccount SET State = 0 where State <> 0 and UID in (" + id + ")");
Response.Write(ok ? "ok" : "");
}
else
{
Response.Write("no");
}
}
//获取积分
else if (types == "getIntegral")
{
int integral = 0;
if (SOSOshop.BLL.PowerPass.isPass("008009001"))
{
try
{
SOSOshop.BLL.Integral.MemberIntegral bll2 = new SOSOshop.BLL.Integral.MemberIntegral();
integral = bll2.GetRealityIntegral(uid);
}
catch { }
Response.Write(integral);
}
else
{
Response.Write("no");
}
}
//赠送积分
else if (types == "editIntegral")
{
int integral = 0; int.TryParse(Request["integral"], out integral);
if (SOSOshop.BLL.PowerPass.isPass("008009015"))
{
bool ok = false;
try
{
SOSOshop.BLL.Integral.MemberIntegral bll2 = new SOSOshop.BLL.Integral.MemberIntegral();
SOSOshop.Model.AdminInfo adminInfo = SOSOshop.BLL.AdministrorManager.Get();
string remarks = string.Format("管理员{0}赠送积分", (adminInfo == null ? "" : adminInfo.AdminName));
bll2.PresentIntegral(uid, integral, remarks);
ok = true;
#region 后台用户操作日志记录
SOSOshop.BLL.Logs.Log.LogAdminAdd(remarks + "给" + Request["TrueName"] + "：" + integral, (adminInfo == null ? 0 : adminInfo.AdminId), (adminInfo == null ? "" : adminInfo.AdminName), 1);
#endregion
}
catch { }
Response.Write(ok ? "ok" : "");
}
else
{
Response.Write("no");
}
}
Response.End();
return;
}
#endregion
if (!SOSOshop.BLL.PowerPass.isPass("008009001") && !SOSOshop.BLL.PowerPass.isPass("008009012"))
{
SOSOshop.BLL.PromptInfo.Popedom("000000000000", "对不起，您没有查看的权限!");
}
//显示列表
Search_Click(null, null);
}
//权限赋值
isCheckUp = SOSOshop.BLL.PowerPass.isPass("008009013");
IsEdit = SOSOshop.BLL.PowerPass.isPass("008009004");
IsDelete = SOSOshop.BLL.PowerPass.isPass("008009003");
IsPresentIntegral = SOSOshop.BLL.PowerPass.isPass("008009015");
}