public static bool Insert(jz_userdetailEntity item)
{
bool rv = true;
try
{
DataTable dt = DBAccess.DataAccess.Miou_GetDataSetBySql(DBAccess.LogUName, string.Format("select * from {0} where {1} = {2} ;", tableName, keyName, 0)).Tables[0];
DataRow dr = dt.NewRow();
dr["zjuid"] = item.zjuid;
dr["uid"] = item.uid;
dr["fmoney"] = item.fmoney;
dr["fmoney"] = item.fmoney;
dr["remark"] = item.remark;
dr["createtime"] = DateTime.Now;
dt.Rows.Add(dr);
rv = DBAccess.DataAccess.Miou_UpdateDataSet(DBAccess.LogUName, tableName, "*", "1<>1", "", dt).StartsWith("000");
}
catch (Exception ex)
{
string ss = ex.ToString();
rv = false;
}
return(rv);
}
public ActionResult Startuserjz(int uid, double fmoney)
{
PostResponse _Respone = new PostResponse()
{
IsSuccess = false
};
if (LinkTokenSQ.MvcApplication.Syspar["OpeanLuckdraw"].keyvalue == "0")
{
_Respone.Message = LinkTokenSQ.MvcApplication.Syspar["OpeanLuckdraw"].keydes;
return(Json(_Respone));
}
var uinfo = this.GetUser();
try
{
if (fmoney <= 0)
{
_Respone.Message = "捐赠数额要>0 ";
return(Json(_Respone));
}
if (uid == uinfo.uid)
{
string info = "";
var acc = uaccountDal.GetByKeyId(uid, ref info);
if (acc.accountmony < fmoney)
{
_Respone.Message = "用户积分余额不足,谢谢支持.";
return(Json(_Respone));
}
acc.accountmony -= fmoney;
if (uaccountDal.Update(acc))
{
jz_userdetailEntity jzo = new jz_userdetailEntity();
jzo.createtime = DateTime.Now;
jzo.fmoney = fmoney;
jzo.uid = uid;
jzo.remark = "用户捐赠";
jz_userdetailDal.Insert(jzo);
uchangedetailEntity ch = new uchangedetailEntity();
ch.remark = "用户捐赠";
ch.ftype = 30;
ch.uid = uid;
ch.fmoney = fmoney;
ch.datachange_lasttime = DateTime.Now;
uchangedetailDal.Inert(ch);
_Respone.IsSuccess = true;
}
else
{
_Respone.Message = "捐赠失败,请重试看看,谢谢支持.";
}
}
}
catch (Exception ex)
{
_Respone.Message = ex.Message;
}
return(Json(_Respone));
}