/// <summary>
/// 删除评论
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public int DelCommentInfo(WctCommentMstrQuery query)
{
var count = 0;
var sql = "Delete from WCT_COMMENT_MSTR where COMMENT_ID='" + query.COMMENT_ID + "'";
if (query.IsMainComment)
{
sql += " or MAIN_COMMENT_ID='" + query.COMMENT_ID + "' ";
}
count = _sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
return(count);
}
/// <summary>
/// 删除分类
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public bool DelGoodsClass(string where)
{
string sql = "update MDM_GOODS_CLASS set CLASS_STATUS=0 where 1=1 and BG_NO='" + AbpSession.BG_NO + "' ";
if (!string.IsNullOrEmpty(where))
{
sql += " and " + where;
}
return(_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection()) > 0 ? true : false);
}
/// <summary>
/// 批量删除员工信息
/// </summary>
/// <param name="userIds"></param>
public void BatchDelSysUsrInfo(string userIds)
{
var sql = "Update SYS_USR_MSTR set DEL_FLAG=0 Where USR_ID in (" + userIds + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 批量删除职务信息
/// </summary>
/// <param name="dutyIds"></param>
public void BatchDelMdmDutyInfo(string dutyIds)
{
var sql = "Update MDM_DUTY_MSTR set DEL_FLAG=0 Where DUTY_ID in (" + dutyIds + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 删除用户角色关系
/// </summary>
/// <param name="userIds"></param>
public void DelSysUsrAuthInfo(string userId)
{
var sql = "Delete from SYS_USR_AUTH Where USR_ID =" + userId + "";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 批量删除回复信息
/// </summary>
/// <param name="replyIds"></param>
public void BatchDelReplyInfo(string replyIds)
{
var sql = "Update WCT_REPLY_MSTR set DEL_FLAG=0 Where REPLY_ID in (" + replyIds + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 删除微信菜单
/// </summary>
/// <param name="menuId"></param>
public void DelWxMenuInfo(string menuId)
{
var sql = "DELETE FROM WCT_MENU_MSTR Where MENU_ID='" + menuId + "'";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 批量删除公众信息
/// </summary>
/// <param name="paIds"></param>
public void BatchDelPaInfo(string paIds)
{
var sql = "Update WCT_PA_MSTR set DEL_FLAG=0 Where PA_ID in (" + paIds + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 删除子应用菜单
/// </summary>
/// <param name="appId"></param>
public void DelAppItemInfo(string appId)
{
var sql = "DELETE FROM WCT_APP_ITEM Where MSTR_ID='" + appId + "'";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 批量删除素材信息
/// </summary>
/// <param name="materialIds"></param>
public void BatchDelMaterialInfo(string materialIds)
{
var sql = "Update CMS_MATERIAL_MSTR set DEL_FLAG=0 Where MATERIAL_ID in (" + materialIds + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 顾问更新消息状态
/// </summary>
/// <param name="toUserId"></param>
/// <param name="userId"></param>
public void UpdateMessageStatus(string toUserId, string userId)
{
var sql = "Update CRM_EVA_MSTR set UDF1='已读' where EVA_REF_NO='" + userId + "' and EVA_OBJ_NO='" + toUserId + "'";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection());
}
/// <summary>
/// 批量删除角色权限信息
/// </summary>
/// <param name="roleIds"></param>
public void BatchDelSysRoleInfo(string roleIds)
{
var sql = "Update SYS_ROLE_MSTR set DEL_FLAG=0 Where ROLE_ID in (" + roleIds + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 删除角色菜单信息
/// </summary>
/// <param name="roleIds"></param>
public void DelSysRoleMenuInfo(string roleIds)
{
var sql = "Delete from SYS_ROLE_MENU_PERMISSION Where ROLE_ID in (" + roleIds + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 删除属性
/// </summary>
/// <param name="propertyId"></param>
/// <param name="where"></param>
public bool DelProValue(string propertyId, string where)
{
string sql = @"update MDM_GOODS_PROPERTY_MSTR set del_flag=0 where PROPERTY_PARENTID='" + propertyId + "' " + where;
return(_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection()) > 0);
}
/// <summary>
/// 批量删除机构信息
/// </summary>
/// <param name="buNos"></param>
public void BatchDelBuInfo(string buNos)
{
var sql = "Update MDM_BU_MSTR set DEL_FLAG=0 Where BU_NO in (" + buNos + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 批量删除系统模块信息
/// </summary>
/// <param name="sysMoudleIds"></param>
public void BatchDelSysMoudleInfo(string sysMoudleIds)
{
var sql = "Update WCT_SYSMODULE_MSTR set DEL_FLAG=0 Where SYSM_ID in (" + sysMoudleIds + ")";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}
/// <summary>
/// 删除标签记录信息
/// </summary>
/// <param name="wctId"></param>
/// <param name="fleId"></param>
public void DelTagHistInfo(string wctId, string fleId)
{
var sql = "DELETE FROM TAG_HIST Where TAG_REF_FIELD_ID='" + fleId + "' and TAG_REF_ROW_NO='" + wctId + "'";
_sqlQuery.ExcuteSql(sql, Context.Database.GetDbConnection(), null, null);
}