public void Delete(string ucid)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=" + ucid;
dbOperHandler.Delete("N_UserContract");
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UcId=" + ucid;
dbOperHandler.Delete("N_UserContractDetail");
}
}
public void DeleteLogs()
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "1=1";
dbOperHandler.Delete("N_UserCharge");
}
}
public void Delete(string Id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "id=" + Id;
dbOperHandler.Delete("N_UserBank");
}
}
public int DeletesMessageById(string Id)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "Id=@Id";
dbOperHandler.AddConditionParameter("@Id", (object)Id);
return(dbOperHandler.Delete("N_UserMessage"));
}
}
public int DeletesMessage(string UserId)
{
int result;
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=@UserId";
dbOperHandler.AddConditionParameter("@UserId", UserId);
result = dbOperHandler.Delete("N_UserMessage");
}
return(result);
}
public string SaveContract(string ParentId, string UserId, decimal money, decimal per)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId;
dbOperHandler.Delete("Act_UserFHDetail");
dbOperHandler.Reset();
dbOperHandler.AddFieldItem("ParentId", ParentId);
dbOperHandler.AddFieldItem("UserId", UserId);
dbOperHandler.AddFieldItem("MinMoney", money);
dbOperHandler.AddFieldItem("Group3", per);
dbOperHandler.AddFieldItem("IsUsed", 1);
dbOperHandler.Insert("Act_UserFHDetail");
}
return(base.JsonResult(1, "分配契约成功！"));
}
public string SaveContract(string ParentId, string UserId, Decimal money, Decimal per)
{
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.ConditionExpress = "UserId=" + UserId;
dbOperHandler.Delete("Act_UserFHDetail");
dbOperHandler.Reset();
dbOperHandler.AddFieldItem(nameof(ParentId), (object)ParentId);
dbOperHandler.AddFieldItem(nameof(UserId), (object)UserId);
dbOperHandler.AddFieldItem("MinMoney", (object)money);
dbOperHandler.AddFieldItem("Group3", (object)per);
dbOperHandler.AddFieldItem("IsUsed", (object)1);
dbOperHandler.Insert("Act_UserFHDetail");
}
return(this.JsonResult(1, "分配契约成功！"));
}