/// <summary>
/// 修改产品供应商信息
/// </summary>
/// <param name="stock"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE UpdateProductStock(ivt_warehouse_product stock, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
stock.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
stock.update_user_id = user.id;
var old = Getwarehouse_product(stock.id);
if (!(new ivt_warehouse_product_dal().Update(stock)))
{
return(ERROR_CODE.ERROR);
}
//操作日志
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.WAREHOUSE_PRODUCT, //
oper_object_id = stock.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = new ivt_warehouse_product_dal().CompareValue(old, stock),
remark = "修改产品库存信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="data"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE Insert(d_account_classification data, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var cla = _dal.FindSignleBySql <d_account_classification>($"select * from d_account_classification where name='{data.name}' and delete_time=0");
if (cla != null)
{
return(ERROR_CODE.EXIST);
}
data.create_time = data.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
data.create_user_id = user_id;
_dal.Insert(data);
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = "",
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ACCOUNTCLASS, //
oper_object_id = data.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(data),
remark = "新增客户类别信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public ERROR_CODE Update(sys_quote_email_tmpl tmpl, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.PARAMS_ERROR);
}
tmpl.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
tmpl.update_user_id = user.id;
if (!dal.Update(tmpl))
{
return(ERROR_CODE.ERROR);
}
//日志
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.QUOTE_TEMP,
oper_object_id = tmpl.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = dal.CompareValue(dal.FindNoDeleteById(tmpl.id), tmpl),
remark = "修改邮件模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE Add(sys_quote_tmpl sqt, long user_id, out int id)
{
id = sqt.id = (int)(_dal.GetNextIdCom());
sqt.update_user_id = sqt.create_user_id;
sqt.create_time = sqt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
_dal.Insert(sqt);//把数据保存到数据库表
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.QUOTE_TEMP,
oper_object_id = sqt.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(sqt),
remark = "新增报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE update(sys_quote_tmpl sqt, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var old = GetQuoteTemplate(sqt.id);
sqt.update_user_id = user_id;
sqt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
if (!_dal.Update(sqt))
{
return(ERROR_CODE.ERROR);
}
//写个操作日志
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.QUOTE_TEMP, //数据库缺少对应，报价模板
oper_object_id = sqt.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, sqt),
remark = "更新报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 保存权限等级，主要使用更新操作
/// </summary>
/// <param name="sqt"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE Save(sys_security_level_limit sqt, long user_id)
{
sys_security_level_limit_dal sslld = new sys_security_level_limit_dal();
var da = sslld.FindSignleBySql <sys_security_level_limit>($"select * from sys_security_level_limit where security_level_id={sqt.security_level_id} and limit_id={sqt.limit_id} ");
if (da != null)//判断是否已经保存过权限点数据
{
if (sqt.limit_type_value_id != da.limit_type_value_id)
{
sslld.Update(sqt);
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SECURITY_LEVEL,
oper_object_id = sqt.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(sqt),
remark = "新增权限点关联模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
}
}
else
{
sqt.id = (int)(_dal.GetNextIdCom());
sslld.Insert(sqt);//把数据保存到数据库表
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SECURITY_LEVEL,
oper_object_id = sqt.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(sqt),
remark = "新增权限点关联模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 从全部当前激活的合同中排除
/// </summary>
/// <param name="id"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE Exclude(long id, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var exc = new ctt_contract_dal();
var exc_role = new ctt_contract_exclusion_role_dal();
ctt_contract_exclusion_role role = new ctt_contract_exclusion_role();
var excc = exc.FindListBySql <ctt_contract>($"select * from ctt_contract where status_id = 1 and end_date> CURDATE() and delete_time = 0");
if (excc.Count > 0)
{
foreach (var i in excc)
{
var exccrole = exc_role.FindListBySql <ctt_contract_exclusion_role>($"select * from ctt_contract_exclusion_role where role_id={id} and contract_id={i.id} and delete_time=0");
if (exccrole == null)
{
try
{
role.contract_id = i.id;
role.id = (int)(_dal.GetNextIdCom());
role.role_id = id;
role.create_user_id = role.update_user_id = user_id;
role.create_time = role.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
exc_role.Insert(role);
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTRACT_EXCLUSTION_ROLE, //角色
oper_object_id = role.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(role),
remark = "新增合同例外因素--角色"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
}
catch
{
return(ERROR_CODE.ERROR);
}
}
}
}
else
{
return(ERROR_CODE.CONTRACT_NO_ACTIVE);
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="id"></param>
/// <param name="user_id"></param>
/// <param name="returnvalue"></param>
/// <returns></returns>
public ERROR_CODE Delete(long id, long user_id, out string returnvalue)
{
returnvalue = string.Empty;
StringBuilder re = new StringBuilder();
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
//工时、队列、合同、员工部门等
//
var res = new sys_resource_dal().FindListBySql <sys_resource>($"");
if (res.Count > 0)
{
re.Append("角色不能被删除，因为它被以下对象引用：");
int n = 1;
foreach (var ii in res)
{
re.Append("N" + (n++) + "\t\t" + ii.name + "\n");
}
returnvalue = re.ToString();
return(ERROR_CODE.EXIST);
}
var data = _dal.FindById(id);
if (data == null)
{
return(ERROR_CODE.ERROR);
}
data.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
data.delete_user_id = user_id;
if (!_dal.Update(data))
{
return(ERROR_CODE.ERROR);
}
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ROLE, //角色
oper_object_id = data.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = _dal.AddValue(data),
remark = "删除角色信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 通过id删除
/// </summary>
/// <param name="id"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE Delete(long id, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var data = _dal.FindById(id);
if (data == null)
{
return(ERROR_CODE.ERROR);
}
if (data.is_system > 0)
{
return(ERROR_CODE.SYSTEM);
}
var mar = new crm_account_dal().FindListBySql($"select * from crm_account where classification_id={id} and delete_time=0");
if (mar.Count > 0)
{
foreach (var acc in mar)
{
acc.classification_id = null;
acc.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
acc.update_user_id = user_id;
if (!new crm_account_dal().Update(acc))
{
return(ERROR_CODE.ERROR);
}
}
}
data.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
data.delete_user_id = user_id;
if (!_dal.Update(data))
{
return(ERROR_CODE.ERROR);
}
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = "",
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ACCOUNTCLASS, //
oper_object_id = data.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = _dal.AddValue(data),
remark = "删除客户类别信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE default_quote_template(long user_id, long id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.PARAMS_ERROR);
}
var sq = _dal.FindById(id);
var old = sq;
if (sq == null)
{
return(ERROR_CODE.ERROR);
}
if (sq.is_default == 1)
{
return(ERROR_CODE.DEFAULT);
}
sys_quote_tmpl sqt = _dal.FindSignleBySql <sys_quote_tmpl>($"select * from sys_quote_tmpl where is_default=1 and cate_id='{sq.cate_id}'");
if (sqt != null)
{
sqt.is_default = 0;
sqt.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
sqt.update_user_id = user_id;
if (_dal.Update(sqt) == false)
{
return(ERROR_CODE.ERROR);
}
}
sq.is_default = 1;
sq.update_user_id = user_id;
sq.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
if (_dal.Update(sq) == false)
{
return(ERROR_CODE.ERROR);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.QUOTE_TEMP,
oper_object_id = sq.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, sq),
remark = "修改报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 插入日志
/// </summary>
/// <param name="objId">操作对象id</param>
/// <param name="userId">userid</param>
/// <param name="type">操作类型</param>
/// <param name="cate">操作对象种类</param>
/// <param name="operDesc">操作内容</param>
/// <param name="remark">备注</param>
public static void OperLog(long objId, long userId, DicEnum.OPER_LOG_TYPE type, DicEnum.OPER_LOG_OBJ_CATE cate, string operDesc, string remark)
{
sys_oper_log log = new sys_oper_log();
log.user_id = userId;
log.user_cate = "用户";
log.name = "";
log.phone = "";
log.oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
log.oper_object_cate_id = (int)cate;
log.oper_object_id = objId;// 操作对象id
log.oper_type_id = (int)type;
log.oper_description = operDesc;
log.remark = remark;
dal.Insert(log);
}
/// <summary>
/// 激活安全等级
/// </summary>
/// <param name="user_id"></param>
/// <param name="id"></param>
/// <returns></returns>
public ERROR_CODE ActiveSecurityLevel(long user_id, int id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var old = GetSecurityLevel(id);
// sys_security_level sclev = new sys_security_level();
var seclev = old;
if (seclev == null)
{
return(ERROR_CODE.ERROR);
}
if (seclev.is_active != null && seclev.is_active > 0)
{
return(ERROR_CODE.ACTIVATION);//已经激活
}
seclev.is_active = 1;
seclev.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
seclev.update_user_id = user_id;
if (ss_dal.Update(seclev) == false)
{
return(ERROR_CODE.ERROR);//更新激活状态失败
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SECURITY_LEVEL,
oper_object_id = seclev.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = ss_dal.CompareValue(old, seclev),
remark = "修改权限点关联模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE active_quote_template(long user_id, long id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.PARAMS_ERROR);
}
var temp = _dal.FindById(id);
var old = temp;
if (temp == null)
{
return(ERROR_CODE.ERROR);
}
if (temp.is_active > 0)
{
return(ERROR_CODE.ACTIVATION);
}
temp.is_active = 1;
temp.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
temp.update_user_id = user_id;
if (_dal.Update(temp) == false)
{
return(ERROR_CODE.ERROR);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.QUOTE_TEMP,
oper_object_id = temp.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, temp),
remark = "修改报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 报价模板的删除
/// </summary>
/// 报价模板
public ERROR_CODE quote_template_delete(long user_id, long id)
{
sys_quote_tmpl sqt = GetQuoteTemplate(id);
if (sqt != null)
{
if (sqt.is_system == 1 || sqt.is_custom == 1 || sqt.is_default == 1)
{
return(ERROR_CODE.ERROR);//以下模板不能删除：
}
else
{
sqt.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
sqt.delete_user_id = id;
_dal.Update(sqt);
#region 添加日志
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = "",
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.QUOTE_TEMP,
oper_object_id = sqt.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = _dal.AddValue(sqt),
remark = "删除报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
#endregion
return(ERROR_CODE.SUCCESS);
}
}
return(ERROR_CODE.ERROR);//获取数据失败，不能删除
}
/// <summary>
/// 停用该角色
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ERROR_CODE NoAction(long id, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var data = GetOneData((int)id);
var old = data;
if (data != null && data.is_active == 0)
{
return(ERROR_CODE.NO_ACTIVATION);
}
if (data == null)
{
return(ERROR_CODE.ERROR);
}
data.is_active = 0;
data.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
data.update_user_id = user.id;
if (!_dal.Update(data))
{
return(ERROR_CODE.ERROR);
}
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ROLE, //角色
oper_object_id = data.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, data),
remark = "停用角色信息"
}; // 创建日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE Update(sys_role role, long user_id)
{
var old = GetOneData((int)role.id);
role.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
role.update_user_id = user.id;
var ro = _dal.FindSignleBySql <sys_role>($"select * from sys_role where name='{role.name}' and delete_time=0 ");
if (ro != null && ro.id != role.id)
{
return(ERROR_CODE.EXIST);
}
if (_dal.Update(role) == false)
{
return(ERROR_CODE.ERROR);
}
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ROLE, //角色
oper_object_id = role.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, role),
remark = "修改角色"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE copy_quote_template(long user_id, ref long id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.PARAMS_ERROR);
}
var sq = _dal.FindById(id);
if (sq == null)
{
return(ERROR_CODE.ERROR);
}
sq.is_default = 0;
sq.is_system = 0;
sq.oid = 0;
id = sq.id = (int)(_dal.GetNextIdCom());
sq.name = "(copy of)" + sq.name + Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
sq.create_time = sq.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
sq.create_user_id = sq.update_user_id = user_id;
_dal.Insert(sq);
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.QUOTE_TEMP,
oper_object_id = sq.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(sq),
remark = "修改报价模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE Update(sys_department sd, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var de = _dal.FindSignleBySql <sys_department>($"select * from sys_department where name='{sd.name}' and delete_time=0");
var old = _dal.FindSignleBySql <sys_department>($"select * from sys_department where id={sd.id} and delete_time=0");
if (de != null && de.id != sd.id)
{
return(ERROR_CODE.EXIST);
}
sd.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
sd.update_user_id = user_id;
sd.cate_id = (int)DEPARTMENT_CATE.DEPARTMENT;
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.DEPARTMENT, //部门
oper_object_id = sd.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, sd),
remark = "修改部门信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
if (!_dal.Update(sd))
{
return(ERROR_CODE.ERROR);
}
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE DeleteInventory(long id, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
ivt_warehouse_product_dal inv_dal = new ivt_warehouse_product_dal();
var inv = inv_dal.FindNoDeleteById(id);
if (inv == null)
{
return(ERROR_CODE.ERROR);
}
inv.delete_user_id = user_id;
inv.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
if (!inv_dal.Update(inv))
{
return(ERROR_CODE.ERROR);
}
//操作日志
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.WAREHOUSE_PRODUCT, //
oper_object_id = inv.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = _dal.AddValue(inv),
remark = "删除产品库存信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE Insert(sys_role role, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
// 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var ro = _dal.FindSignleBySql <sys_role>($"select * from sys_role where name='{role.name}' and delete_time=0 ");
if (ro != null)
{
return(ERROR_CODE.EXIST);
}
role.id = (int)(_dal.GetNextIdCom());
role.create_time = role.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
role.create_user_id = role.update_user_id = user_id;
role.create_user_id = user.id;
_dal.Insert(role);
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ROLE, //员工
oper_object_id = role.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(role),
remark = "新增角色"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
///新增产品库存信息
/// </summary>
/// <param name="stock"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE InsertProductStock(ivt_warehouse_product stock, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
//唯一性校验
ivt_warehouse_product_dal kk = new ivt_warehouse_product_dal();
var re = kk.FindSignleBySql <ivt_warehouse_product>($"select * from ivt_warehouse_product where product_id={stock.product_id} and warehouse_id={stock.warehouse_id} and delete_time=0");
if (re != null)
{
return(ERROR_CODE.EXIST);
}
stock.id = (int)(_dal.GetNextIdCom());
stock.create_time = stock.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
stock.create_user_id = stock.update_user_id = user_id;
kk.Insert(stock);
//操作日志
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.WAREHOUSE_PRODUCT, //
oper_object_id = stock.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(stock),
remark = "新增产品库存信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
public ERROR_CODE UpdateSecurityLevel(sys_security_level seclev, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var older = GetSecurityLevel(seclev.id);
var old = GetSecurityLevel(seclev.id);
old.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
old.update_user_id = user_id;
old.name = seclev.name;
old.is_active = seclev.is_active;
bool k = new sys_security_level_dal().Update(old);
if (k == false)
{
return(ERROR_CODE.ERROR);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SECURITY_LEVEL,
oper_object_id = seclev.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = new sys_security_level_dal().CompareValue(old, older),
remark = "修改权限点关联模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 删除sys_resource_territory中的员工和地域的关系
/// </summary>
/// <param name="aid"></param>
/// <param name="tid"></param>
/// <returns></returns>
public bool DeleteAccount_Territory(long aid, long tid, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(false);
}
sys_resource_territory_dal cat_dal = new sys_resource_territory_dal();
var i = cat_dal.FindSignleBySql <sys_resource_territory>($"select * from sys_resource_territory where resource_id={aid} and territory_id={tid} and delete_time=0");
if (i != null)
{
i.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
i.delete_user_id = user_id;
if (cat_dal.Update(i))
{
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.RESOURCE, //员工
oper_object_id = i.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = cat_dal.AddValue(i),
remark = "删除地域与员工的关联"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
return(true);
}
}
return(false);
}
public void UpdatePermission(sys_resource res, long user_id)
{
res.update_user_id = user_id;
res.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
if (_dal.Update(res))
{
var add_account_log = new sys_oper_log();
var user = UserInfoBLL.GetUserInfo(user_id);
add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTACTS,
oper_object_id = res.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.AddValue(res),
remark = "更新客户信息权限"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log);
}
}
/// <summary>
/// 复制安全等级
/// </summary>
/// <param name="user_id"></param>
/// <param name="id"></param>
/// <param name="copy_id"></param>
/// <returns></returns>
public bool CopySecurityLevel(long user_id, int id, out int copy_id)
{
var s1 = new sys_security_level_dal().FindById(id);
copy_id = -1;
if (s1 == null)
{
return(false);
}
sys_security_level s = new sys_security_level();
s.id = copy_id = (int)(_dal.GetNextIdCom());
s.name = "（copy of）" + s1.name;
s.is_active = 1;
s.is_active = 0;
s.license_type_id = s1.license_type_id;
s.create_time = s.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
s.create_user_id = s.update_user_id = user_id;
ss_dal.Insert(s);
//更新复制插入语句
//insert into sys_security_level_limit(id,security_level_id,limit_id,limit_type_value_id) select (select f_nextval('seq_com')),3,limit_id,limit_type_value_id from sys_security_level_limit where security_level_id=2
try {
if (ssl_dal.ExecuteSQL($"insert into sys_security_level_limit(id,security_level_id,limit_id,limit_type_value_id) select (select f_nextval('seq_com')),{copy_id},limit_id,limit_type_value_id from sys_security_level_limit where security_level_id={id}") != 130)
{
return(false);
}
} catch {
return(false);
}
sys_security_level_module_dal ssm_dal = new sys_security_level_module_dal();
try {
if (ssm_dal.ExecuteSQL($"insert into `sys_security_level_module` (`id`, `security_level_id`, `module_id`, `module_limit_id`, `module_limit_value`, `module_value`) select (select f_nextval('seq_com')),{copy_id}, `module_id`, `module_limit_id`, `module_limit_value`, `module_value` from sys_security_level_module where security_level_id={id}") <= 0)
{
return(false);
}
} catch {
return(false);
}
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(false);
}
try {
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SECURITY_LEVEL,
oper_object_id = s.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = ss_dal.AddValue(s),
remark = "新增权限点关联模板"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
} catch {
}
return(true);
}
/// <summary>
/// 撤销订阅审批
/// </summary>
/// <param name="user_id"></param>
/// <param name="ids"></param>
/// <returns></returns>
public ERROR_CODE Revoke_Subscriptions(long user_id, string ids, out string re)
{
re = string.Empty;
StringBuilder returnvalue = new StringBuilder();
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
crm_account_deduction cad = new crm_account_deduction();
crm_subscription cs = new crm_subscription(); //订阅表
crm_subscription_period csp = new crm_subscription_period(); //订阅周期表
crm_subscription_dal cs_dal = new crm_subscription_dal();
crm_subscription_period_dal csp_dal = new crm_subscription_period_dal();
if (!string.IsNullOrEmpty(ids))
{
var idList = ids.Split(',');
foreach (var id in idList)
{
var oldcad = cad = GetAccountDed(long.Parse(id));
if (cad.invoice_id != null)
{
var ci = new ctt_invoice_dal().FindNoDeleteById((long)cad.invoice_id);
if (ci.is_voided != 1)
{
returnvalue.Append(id + "条目已经生成发票（发票ID：" + cad.invoice_id + "），请先作废该发票\n");
}
}
else
{
cad.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
cad.delete_user_id = user.id;
// 插入日志
var add1_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ACCOUNT_DEDUCTION,
oper_object_id = cad.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = cad_dal.CompareValue(oldcad, cad),
remark = "删除审批并提交"
}; // 创建日志
new sys_oper_log_dal().Insert(add1_log); // 插入日志
if (!cad_dal.Update(cad))
{
return(ERROR_CODE.ERROR);
}
else
{
}
}
//订阅
if (cad.object_id != null)
{
var oldcsp = csp = csp_dal.FindSignleBySql <crm_subscription_period>($"select * from crm_subscription_period where id={cad.object_id}");
cs = cs_dal.FindNoDeleteById(csp.subscription_id);
csp.approve_and_post_user_id = null;
csp.approve_and_post_date = null;
csp.period_price = cs.period_price;
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SUBSCRIPTION_PERIOD, //订阅周期
oper_object_id = csp.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = cad_dal.CompareValue(oldcsp, csp),
remark = "修改订阅周期"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
if (!csp_dal.Update(csp))
{
return(ERROR_CODE.ERROR);
}
}
}
}
if (!string.IsNullOrEmpty(returnvalue.ToString()))
{
re = returnvalue.ToString();
return(ERROR_CODE.EXIST);
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 撤销里程碑审批
/// </summary>
/// <param name="user_id"></param>
/// <param name="ids"></param>
/// <returns></returns>
public ERROR_CODE Revoke_Milestones(long user_id, string ids, out string re)
{
re = string.Empty;
StringBuilder returnvalue = new StringBuilder();
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
crm_account_deduction cad = new crm_account_deduction();
ctt_contract_milestone ccm = new ctt_contract_milestone();
ctt_contract_milestone_dal ccm_dal = new ctt_contract_milestone_dal();
if (!string.IsNullOrEmpty(ids))
{
var idList = ids.Split(',');
foreach (var id in idList)
{
var oldcad = cad = GetAccountDed(long.Parse(id));
if (cad.invoice_id != null)
{
var ci = new ctt_invoice_dal().FindNoDeleteById((long)cad.invoice_id);
if (ci.is_voided != 1)
{
returnvalue.Append(id + "条目已经生成发票（发票ID：" + cad.invoice_id + "），请先作废该发票\n");
}
}
else
{
cad.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
cad.delete_user_id = user.id;
// 插入日志
var add1_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ACCOUNT_DEDUCTION,
oper_object_id = cad.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = cad_dal.CompareValue(oldcad, cad),
remark = "删除审批并提交"
}; // 创建日志
new sys_oper_log_dal().Insert(add1_log); // 插入日志
if (!cad_dal.Update(cad))
{
return(ERROR_CODE.ERROR);
}
else
{
}
}
//里程碑
if (cad.object_id != null)
{
var oldccm = ccm = ccm_dal.FindSignleBySql <ctt_contract_milestone>($"select * from ctt_contract_milestone where id={cad.object_id} and delete_time=0");
ccm.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
ccm.update_user_id = user.id;
ccm.status_id = (int)MILESTONE_STATUS.READY_TO_BILL;
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTRACT_MILESTONE,
oper_object_id = ccm.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = cad_dal.CompareValue(oldccm, ccm),
remark = "修改合同里程碑"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
if (!ccm_dal.Update(ccm))
{
return(ERROR_CODE.ERROR);
}
}
}
}
if (!string.IsNullOrEmpty(returnvalue.ToString()))
{
re = returnvalue.ToString();
return(ERROR_CODE.EXIST);
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 撤销定期服务审批
/// </summary>
/// <param name="user_id"></param>
/// <param name="ids"></param>
/// <returns></returns>
public ERROR_CODE Revoke_Recurring_Services(long user_id, string ids, out string re)
{
re = string.Empty;
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
StringBuilder returnvalue = new StringBuilder();
crm_account_deduction cad = new crm_account_deduction(); //审批并提交
ctt_contract_cost ccc = new ctt_contract_cost(); //成本
ctt_contract cc = new ctt_contract(); //合同
ctt_contract_service_period ccsp = new ctt_contract_service_period(); //合同服务周期
ctt_contract_service_adjust ccsa = new ctt_contract_service_adjust(); //合同服务调整
ctt_contract_service_period_dal ccsp_dal = new ctt_contract_service_period_dal();
ctt_contract_service_adjust_dal ccsa_dal = new ctt_contract_service_adjust_dal();
if (!string.IsNullOrEmpty(ids))
{
var idList = ids.Split(',');
foreach (var id in idList)
{
var oldcad = cad = GetAccountDed(long.Parse(id));
if (cad.invoice_id != null)
{
var ci = new ctt_invoice_dal().FindNoDeleteById((long)cad.invoice_id);
if (ci.is_voided != 1)
{
returnvalue.Append(id + "条目已经生成发票（发票ID：" + cad.invoice_id + "），请先作废该发票\n");
}
}
else
{
cad.delete_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
cad.delete_user_id = user.id;
// 插入日志
var add1_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.ACCOUNT_DEDUCTION,
oper_object_id = cad.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = cad_dal.CompareValue(oldcad, cad),
remark = "删除审批并提交"
}; // 创建日志
new sys_oper_log_dal().Insert(add1_log); // 插入日志
if (!cad_dal.Update(cad))
{
return(ERROR_CODE.ERROR);
}
//类型为服务
if (cad.type_id == (int)ACCOUNT_DEDUCTION_TYPE.SERVICE)
{
var oldccsp = ccsp = ccsp_dal.FindSignleBySql <ctt_contract_service_period>($"select * from ctt_contract_service_period where contract_id={cad.contract_id} and delete_time=0");
ccsp.approve_and_post_date = null;
ccsp.approve_and_post_user_id = null;
ccsp.period_adjusted_price = ccsp.period_price * ccsp.quantity;
ccsp.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
ccsp.update_user_id = user.id;
var add2_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTRACT_SERVICE_PERIOD, //
oper_object_id = ccsp.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = cad_dal.CompareValue(oldccsp, ccsp),
remark = "修改合同服务周期"
}; // 创建日志
new sys_oper_log_dal().Insert(add2_log); // 插入日志
if (!ccsp_dal.Update(ccsp))
{
return(ERROR_CODE.ERROR);
}
}
//类型为服务调整
if (cad.type_id == (int)ACCOUNT_DEDUCTION_TYPE.SERVICE_ADJUST)
{
var oldccsa = ccsa = ccsa_dal.FindSignleBySql <ctt_contract_service_adjust>($"select * from ctt_contract_service_adjust where contract_id={cad.contract_id} and delete_time=0");
cc = new ctt_contract_dal().FindSignleBySql <ctt_contract>($"select * from ctt_contract where id={cad.contract_id} and delete_time=0");
ccsa.approve_and_post_date = null;
ccsa.approve_and_post_user_id = null;
ccsa.adjust_prorated_price_change = (decimal)cc.setup_fee;
ccsa.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
ccsa.update_user_id = user.id;
var add2_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTRACT_SERVICE_ADJUST, //
oper_object_id = ccsp.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.DELETE,
oper_description = cad_dal.CompareValue(oldccsa, ccsa),
remark = "修改合同服务调整"
}; // 创建日志
new sys_oper_log_dal().Insert(add2_log); // 插入日志
if (ccsp_dal.Update(ccsp))
{
}
}
//类型为初始费用
if (cad.type_id == (int)ACCOUNT_DEDUCTION_TYPE.INITIAL_COST)
{
var oldcc = cc = new ctt_contract_dal().FindSignleBySql <ctt_contract>($"select * from ctt_contract where id={cad.contract_id} and delete_time=0");
cc.adjust_setup_fee = cc.setup_fee;
cc.setup_fee_approve_and_post_user_id = null;
cc.setup_fee_approve_and_post_date = null;
cc.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
cc.update_user_id = user.id;
var add2_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTACTS,
oper_object_id = cad.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = cad_dal.CompareValue(oldcc, cc),
remark = "修改合同初始费用"
}; // 创建日志
new sys_oper_log_dal().Insert(add2_log); // 插入日志
if (!new ctt_contract_dal().Update(cc))
{
return(ERROR_CODE.ERROR);
}
}
}
}
}
if (!string.IsNullOrEmpty(returnvalue.ToString()))
{
re = returnvalue.ToString();
return(ERROR_CODE.EXIST);
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 新增地域
/// </summary>
/// <param name="data"></param>
/// <param name="user_id"></param>
/// <returns></returns>
public ERROR_CODE SaveTerritory(d_general data, long user_id, ref int id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
if (id > 0)
{
var res = new GeneralBLL().GetSingleGeneral(data.name, data.general_table_id);
if (res != null && res.id != data.id)
{
return(ERROR_CODE.EXIST);
}
var old = new GeneralBLL().GetSingleGeneral(data.id);
data.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
data.update_user_id = user_id;
if (!_dal.Update(data))
{
return(ERROR_CODE.ERROR);
}
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.General_Code, //
oper_object_id = data.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, data),
remark = "修改地域信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
}
else
{
data.general_table_id = (int)GeneralTableEnum.TERRITORY;
data.create_time = data.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
data.create_user_id = user_id;
//唯一性校验
var res = new GeneralBLL().GetSingleGeneral(data.name, data.general_table_id);
if (res != null)
{
return(ERROR_CODE.EXIST);
}
_dal.Insert(data);
var re = _dal.FindSignleBySql <d_general>($"select * from d_general where name='{data.name}'");
if (re != null)
{
id = re.id;
}
var add_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.General_Code,
oper_object_id = data.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(data),
remark = "新增地域信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_log); // 插入日志
}
return(ERROR_CODE.SUCCESS);
}
/// <summary>
/// 新增员工信息
/// </summary>
/// <param name="data"></param>
/// <param name="user_id"></param>
/// <param name="id"></param>
/// <returns></returns>
public ERROR_CODE Insert(SysUserAddDto data, long user_id, out long id)
{
id = data.sys_res.id = _dal.GetNextIdCom();
sys_resource findRes;
if (string.IsNullOrEmpty(data.sys_res.mobile_phone))
{
findRes = _dal.FindSignleBySql <sys_resource>($"select * from sys_resource where email='{data.sys_res.email}' and delete_time=0");
}
else
{
findRes = _dal.FindSignleBySql <sys_resource>($"select * from sys_resource where (email='{data.sys_res.email}' or mobile_phone='{data.sys_res.mobile_phone}') and delete_time=0");
}
if (findRes != null)
{
return(ERROR_CODE.SYS_NAME_EXIST);
}
data.sys_res.create_user_id = data.sys_res.update_user_id = user_id;
data.sys_res.create_time = data.sys_res.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
_dal.Insert(data.sys_res);
//操作日志新增一条日志,操作对象种类：员工
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{
return(ERROR_CODE.USER_NOT_FIND);
}
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTACTS, //员工
oper_object_id = data.sys_res.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(data.sys_res),
remark = "保存员工信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
data.sys_user.id = id;
//加密
data.sys_user.password = new Tools.Cryptographys().SHA1Encrypt(data.sys_user.password);
new sys_user_dal().Insert(data.sys_user);
add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.CONTACTS,
oper_object_id = data.sys_user.id,// 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.ADD,
oper_description = _dal.AddValue(data.sys_user),
remark = "保存客户信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log);
if (data.timeoffPolicy != null)
{
new TimeOffPolicyBLL().AddTimeoffResource(id.ToString(), data.timeoffPolicy.timeoff_policy_id, data.timeoffPolicy.effective_date, user_id);
}
if (data.internalCost != null && data.internalCost.Count > 0)
{
var costDal = new sys_resource_internal_cost_dal();
foreach (var cost in data.internalCost)
{
cost.resource_id = id;
cost.id = costDal.GetNextIdCom();
costDal.Insert(cost);
}
}
if (data.availability != null)
{
data.availability.id = _dal.GetNextIdCom();
data.availability.resource_id = id;
data.availability.create_time = Tools.Date.DateHelper.ToUniversalTimeStamp();
data.availability.update_time = data.availability.create_time;
data.availability.create_user_id = user_id;
data.availability.update_user_id = user_id;
new sys_resource_availability_dal().Insert(data.availability);
}
sys_resource_additional_time_dal timeDal = new sys_resource_additional_time_dal();
if (data.addTime1 != null)
{
data.addTime1.id = timeDal.GetNextIdCom();
data.addTime1.resource_id = id;
timeDal.Insert(data.addTime1);
}
if (data.addTime2 != null)
{
data.addTime2.id = timeDal.GetNextIdCom();
data.addTime2.resource_id = id;
timeDal.Insert(data.addTime2);
}
return(ERROR_CODE.SUCCESS);
}
