/// <summary>
/// 用户开始注册，生成手机短信的验证码
/// </summary>
/// <param name="phone"></param>
/// <param name="userName"></param>
/// <returns></returns>
public string NewUserSentSMSCode(string phone, string userName, string flagstatus)
{
Random rd = new Random();
var aa = rd.Next(1000, 10000);
string SMSCode = aa.ToString();
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
broker.BeginTransaction();
try
{
string sql = @" INSERT INTO [eContract].[dbo].[UserPhoneSMSCode](phonenumber,sendtime,expiretime,smscode,spare2,SMSId,flagstatus) VALUES ( '" + phone + "', GETDATE() , 20 ,'" + SMSCode + "','',NEWID(),'" + flagstatus + "')";
var success = broker.ExecuteSQL(sql);
broker.Commit();
}
catch (Exception e)
{
}
}
/*var reciever = emailAddress;
* var cc = "";
* var title = "用户注册";
* var content = "感谢您注册磐石系统账号，您的验证码是:" + verificationCode;
* LubrSentMail lubrmial = new LubrSentMail();
* lubrmial.SendEmail(reciever, title, content, null);*/
return(SMSCode);
}
/// <summary>
/// 用户开始注册，生成邮箱的验证码
/// </summary>
/// <param name="phone"></param>
/// <param name="userName"></param>
/// <param name="emailAddress"></param>
/// <returns></returns>
public string NewUserSentVerificationCode(string phone, string userName, string emailAddress)
{
Random rd = new Random();
var aa = rd.Next(100000, 999999);
string verificationCode = aa.ToString();
emailAddress = emailAddress.TrimStart().TrimEnd();
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
broker.BeginTransaction();
try
{
string sql = @" INSERT INTO dbo.[User]( userid ,username ,password ,age ,realname ,idcard ,userclass ,createtime ,endtime ,logintime ,emailaddress ,phonenumber,VerificationCode) VALUES ( NEWID() ,'" + userName + "' ,'' ,0 ,'" + userName + "' ,'' ,0 ,GETDATE() ,GETDATE() ,GETDATE() ,'" + emailAddress + "' ,'" + phone + "','" + verificationCode + "')";
var success = broker.ExecuteSQL(sql);
broker.Commit();
}
catch (Exception e)
{
}
}
var reciever = emailAddress;
var cc = "";
var title = "用户注册";
var content = "感谢您注册磐石系统账号，您的验证码是:" + verificationCode;
LubrSentMail lubrmial = new LubrSentMail();
lubrmial.SendEmail(reciever, title, content, null);
return("");
}
/// <summary>
/// 保存到目标数据库
/// </summary>
/// <param name="tableMap"></param>
/// <param name="dtSource"></param>
private void SaveToTargetDB(TableMap tableMap, DataTable dtSource)
{
// 目标为数据表的情况
string curProcess = "";
DataAccessBroker broker = DataAccessFactory.Instance(this.TargetDataAccessCfg);
try
{
// 事务开始
curProcess = "事务开始";
broker.BeginTransaction();
DatabaseCommand.SaveToTargetDB(broker, tableMap, dtSource);
// 事务提交
curProcess = "事务提交";
broker.Commit();
}
catch (Exception ex)
{
// 事务回滚
broker.RollBack();
throw ex;
}
finally
{
broker.Close();
}
// 写日志
LogManager.Current.WriteCommonLog(this.JobCode, "成功将数据保存到目标表" + tableMap.TargetTable.TableName, this.ThreadName);
}
/// <summary>
/// 从数据库得到来源数据
/// </summary>
/// <returns></returns>
public DataTable GetSourceDataFromDB(Hashtable parameters, TableMap tableMap)
{
DataTable dtSource = null;
DataAccessBroker brokerSource = DataAccessFactory.Instance(this.SourceDataAccessCfg);
try
{
string sqlString = tableMap.GetSourceSelectSQL(this.MaxCount);
// 替换sql中的宏变量
sqlString = BaseCommand.ReplaceParameters(this.InitialParameters, sqlString);
DataSet dataSetSource = brokerSource.FillSQLDataSet(sqlString);
// 源数据为空时，不做任何操作
if (dataSetSource == null || dataSetSource.Tables.Count == 0)
{
return(null);
}
// 取第一个表
dtSource = dataSetSource.Tables[0];
}
finally
{
brokerSource.Close();
}
// 写日志
LogManager.Current.WriteCommonLog(this.JobCode, "从数据表" + tableMap.SourceTable.TableName + "获得" + dtSource.Rows.Count.ToString() + "笔记录。", this.ThreadName);
return(dtSource);
}
public bool UpdateDepartmentInfo(CasDepartmentDomain casDepartmentDomain, DataAccessBroker broker)
{
try
{
#region 除已经存在的用户
var strsql = new StringBuilder();
strsql.AppendFormat(" DELETE FROM CAS_DEPT_USER WHERE DEPT_ID= {0}", Utils.ToSQLStr(casDepartmentDomain.CasDepartmentEntity.DeptId).Trim());
var val = DataAccess.SelectScalar(strsql.ToString(), broker);
#endregion
var depUserEnites = new List <CasDeptUserEntity>();
string[] userIds;
userIds = casDepartmentDomain.CasDepartmentEntity.DeptUserIds.ToString().Split(',');
for (int i = 0; i < userIds.Length; i++)
{
var depUserEnity = new CasDeptUserEntity();
depUserEnity.DeptId = casDepartmentDomain.CasDepartmentEntity.DeptId;
depUserEnity.UserId = userIds[i];
depUserEnity.IsDeleted = false;
depUserEnity.CreatedBy = WebCaching.UserId;
depUserEnity.CreateTime = DateTime.Now;
depUserEnity.LastModifiedBy = WebCaching.UserId;
depUserEnity.LastModifiedTime = DateTime.Now;
depUserEnites.Add(depUserEnity);
}
DataAccess.Insert <CasDeptUserEntity>(depUserEnites, broker);
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 删除部门
/// </summary>
/// <param name="DeptIds"></param>
/// <returns></returns>
public virtual bool DeleteDepartmentDomain(List <string> DeptIds)
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
List <CasDeptUserEntity> lDeptUser = new List <CasDeptUserEntity>();
List <CasDepartmentEntity> lDepartment = new List <CasDepartmentEntity>();
foreach (string id in DeptIds)
{
lDepartment.Add(GetById <CasDepartmentEntity>(id));
lDeptUser.AddRange(GetDeptUserDomainByDeptID(id));
}
broker.BeginTransaction();
DataAccess.Delete <CasDepartmentEntity>(lDepartment, broker);
DataAccess.Delete <CasDeptUserEntity>(lDeptUser, broker);
broker.Commit();
return(true);
}
catch (Exception ex)
{
broker.RollBack();
return(false);
}
}
}
public bool DeletePRByIds(string deleteKeys, ref string strError)
{
List <string> listKeys = deleteKeys.Split(',').ToList();
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
List <CasContractFilingEntity> listContractFilings = new List <CasContractFilingEntity>();
foreach (string id in listKeys)
{
listContractFilings.Add(GetById <CasContractFilingEntity>(id));
}
broker.BeginTransaction();
DataAccess.Delete <CasContractFilingEntity>(listContractFilings, broker);
broker.Commit();
return(true);
}
catch (Exception ex)
{
broker.RollBack();
return(false);
}
}
}
public static void Update <T>(DataAccessBroker broker, List <T> list) where T : EntityBase
{
// 目标为数据表的情况
string curProcess = "";
try
{
// 保存数据
curProcess = "修改数据";
if (list.Count > 0)
{
string sqlString = "UPDATE " + list[0].OringTableSchema.TableName + " SET " + ParseSQL(list[0].OringTableSchema.ValueColumnInfo, ",") + " WHERE " + ParseSQL(list[0].OringTableSchema.KeyColumnInfo, " AND ");
foreach (T entity in list)
{
Application.DoEvents();
// 给目标表新增记录
DataAccessParameterCollection dpc = new DataAccessParameterCollection();
foreach (ColumnInfo field in entity.OringTableSchema.AllColumnInfo)
{
dpc.AddWithValue(field, entity.GetData(field.ColumnName));
}
broker.ExecuteSQL(sqlString, dpc);
}
}
}
catch (Exception ex)
{
// 写日志
string description = "运行中异常，目前执行到'" + curProcess + "',单一事务，事务回滚.";
// 继续抛出异常
throw new InvalidOperationException(description + ex.Message);
}
}
/// <summary>
/// 新增POApprovalSet
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool InsertApprovalSet(CasPoApprovalSettingsEntity entity)
{
var poApprovalSetEntities = new List <CasPoApprovalSettingsEntity>();
string[] userId = entity.ApprovalUserValue.ToString().Split(',');
for (int i = 0; i < userId.Length; i++)
{
var poApprovalSetEntity = new CasPoApprovalSettingsEntity();
poApprovalSetEntity.PoApprovalId = Guid.NewGuid().ToString();
poApprovalSetEntity.Company = entity.Company;
poApprovalSetEntity.ContractTypeId = entity.ContractTypeId;
poApprovalSetEntity.UserId = userId[i];
poApprovalSetEntity.CreatedBy = WebCaching.UserId;
poApprovalSetEntity.CreateTime = DateTime.Now;
poApprovalSetEntity.LastModifiedBy = WebCaching.UserId;
poApprovalSetEntity.LastModifiedTime = DateTime.Now;
poApprovalSetEntities.Add(poApprovalSetEntity);
}
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
broker.BeginTransaction();
DataAccess.Insert <CasPoApprovalSettingsEntity>(poApprovalSetEntities, broker);
broker.Commit();
return(true);
}
catch (Exception ex)
{
broker.RollBack();
return(false);
}
}
//return true;
}
public static void DeleteAllIrisRecoResult()
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
broker.ExecuteSQL("delete from Iris_Reco_Result");
}
}
public virtual bool DeleteUserByIdList(List <string> idList, string userid)
{
string sql = "";
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
broker.BeginTransaction();
try
{
foreach (string id in idList)
{
sql = "UPDATE " + CasUserTable.C_TableName;
//sql += " SET " + CasUserTable.C_IS_DELETE + "=1 ";
sql += " WHERE " + CasUserTable.C_USER_ID + "='" + id + "'";
broker.ExecuteSQL(sql);
}
broker.Commit();
WebCaching.UserCaching = null;
return(true);
}
catch
{
broker.RollBack();
return(false);
}
}
}
/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sqlString">必须带上where 1=1</param>
/// <param name="lstParameter"></param>
/// <param name="grid"></param>
/// <param name="DbInstanceName">数据库实例</param>
/// <returns></returns>
public static LigerGrid QueryTable <T>(string sqlString, DataAccessParameterCollection lstParameter, LigerGrid grid, string DbInstanceName = "") where T : EntityBase, new()
{
string hql = sqlString;
string where = grid.Where;
if (!string.IsNullOrEmpty(where))
{
hql += " and (" + where + ")";
}
if (lstParameter == null)
{
lstParameter = new DataAccessParameterCollection();
}
if (grid != null && grid.LstParms != null && grid.LstParms.Count > 0)
{
foreach (var item in grid.LstParms)
{
lstParameter.Add(item.Name, new DataAccessParameter(item.Name, item.Value));
}
}
if (!string.IsNullOrEmpty(DbInstanceName))
{
using (DataAccessBroker broker = DataAccessFactory.Instance(DbInstanceName))
{
return(ExcuteTable <T>(hql, lstParameter, grid, broker));
}
}
else
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
return(ExcuteTable <T>(hql, lstParameter, grid, broker));
}
}
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="userId"></param>
/// <param name="broker"></param>
public static void DeleteUser(string userId, DataAccessBroker broker)
{
DateTime time = DateTime.Now;
string now = time.Year.ToString() + "-" + time.Month.ToString() + "-" + time.Day.ToString() + " " + time.Hour.ToString() + "-" + time.Minute.ToString() + "-" + time.Second.ToString();
string sql = "update {0} set {1}={2}, {3}=to_date('{4}','YYYY-MM-DD HH24-MI-SS') where {5}='{6}'";
broker.ExecuteSQL(sql);
}
public string GetRegionName(CasUserEntity userEntity)
{
DataAccessBroker broker = DataAccessFactory.Instance();
string sql = "SELECT CAS_REGION.REGION_NAME FROM CAS_CITY INNER JOIN CAS_REGION ON CAS_CITY.REGION_ID = CAS_REGION.REGION_ID WHERE CAS_CITY.CITY_CODE = '" + userEntity.CityCode + "'";
object result = broker.ExecuteSQLScalar(sql);
return(result == null ? "" : result.ToString());
}
/// <summary>
/// 删除文件
/// </summary>
/// <param name="id"></param>
/// <returns>true:删除成功 false:删除失败</returns>
public bool DeleteFile(string id)
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
string sql = $"DELETE FROM dbo.CAS_ATTACHMENT WHERE ATTACHMENT_ID = '{id}'";
return(broker.ExecuteSQL(sql) >= 1);
}
}
public string GetCityName(CasUserEntity userEntity)
{
DataAccessBroker broker = DataAccessFactory.Instance();
string sql = "SELECT CITY_NAME FROM CAS_CITY WHERE CITY_CODE = '" + userEntity.CityCode + "'";
object result = broker.ExecuteSQLScalar(sql);
return(result == null ? "" : result.ToString());
}
public bool UpdatePageControls(string pageID, int pageType, List <SecPageControlEntity> list)
{
List <SecPageControlEntity> oldPageControls = GetPageControls(pageID, pageType);
List <SecPageControlEntity> insertList = new List <SecPageControlEntity>();
List <SecPageControlEntity> updateList = new List <SecPageControlEntity>();
List <SecPageControlEntity> deleteList = new List <SecPageControlEntity>();
foreach (var item1 in oldPageControls)
{
bool find = false;
foreach (var item2 in list)
{
if (item2.ControlId == item1.ControlId)
{
find = true;
if (item1.ControlName != item2.ControlName || item1.ServerId != item2.ServerId)
{
updateList.Add(item2);
}
}
}
if (!find)
{
deleteList.Add(item1);
}
}
foreach (var item2 in list)
{
if (string.IsNullOrEmpty(item2.ControlId))
{
item2.ControlId = Guid.NewGuid().ToString();
insertList.Add(item2);
}
}
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
broker.BeginTransaction();
DataAccess.Update(updateList, broker);
DataAccess.Insert(insertList, broker);
foreach (var item in deleteList)
{
broker.ExecuteSQL("DELETE FROM [SEC_ROLE_CONTROL] WHERE [CONTROL_ID]='" + item.ControlId + "' and [PAGE_TYPE]=" + pageType);
}
DataAccess.Delete(deleteList, broker);
broker.Commit();
return(true);
}
catch (Exception ex)
{
broker.RollBack();
return(false);
}
}
}
public static bool CanGenrateFile()
{
string sql = "select count(*) from Iris_Reco_Image";
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
int count = Convert.ToInt32(broker.ExecuteScalar(sql, null, CommandType.Text));
return(count < 5);
}
}
/// <summary>
/// 删除实体
/// </summary>
public virtual void Delete <T>(List <string> listId, DataAccessBroker broker) where T : EntityBase, new()
{
List <T> list = new List <T>();
foreach (string id in listId)
{
T t = new T();
t[t.OringTableSchema.KeyColumnInfo[0].ColumnName] = id;
list.Add(t);
}
DataAccess.Delete <T>(list, broker);
}
public virtual bool Save(CasDepartmentDomain casDepartmentDomain, ref string strError)
{
casDepartmentDomain.CasDepartmentEntity.LastModifiedTime = DateTime.Now;
casDepartmentDomain.CasDepartmentEntity.LastModifiedBy = WebCaching.UserId;
bool isSuccess = true;
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
broker.BeginTransaction();
if (!string.IsNullOrEmpty(casDepartmentDomain.CasDepartmentEntity.DeptId))
{
isSuccess = Update(casDepartmentDomain.CasDepartmentEntity, broker);
if (isSuccess && casDepartmentDomain.CasDepartmentEntity.DeptType.HasValue &&
casDepartmentDomain.CasDepartmentEntity.DeptType.Value == 2)
{
isSuccess = UpdateDepartmentInfo(casDepartmentDomain, broker);
}
}
else
{
casDepartmentDomain.CasDepartmentEntity.DeptId = Guid.NewGuid().ToString();
isSuccess = Insert(casDepartmentDomain.CasDepartmentEntity, broker);
if (isSuccess && casDepartmentDomain.CasDepartmentEntity.DeptType.HasValue &&
casDepartmentDomain.CasDepartmentEntity.DeptType.Value == 2)
{
isSuccess = UpdateDepartmentInfo(casDepartmentDomain, broker);
}
}
if (isSuccess)
{
broker.Commit();
}
else
{
strError = "Update failed";
broker.RollBack();
}
}
catch (Exception ex)
{
broker.RollBack();
strError = ex.Message;
}
}
return(isSuccess);
}
/// <summary>
/// 更新合同审批
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool UpdateApprovalEntites(CasContractApprovalStepEntity entity)
{
if (string.IsNullOrWhiteSpace(entity.ContractApprovalStepId))
{
return(false);
}
var strsql = new StringBuilder();
strsql.AppendFormat("DELETE FROM CAS_CONTRACT_APPROVAL_STEP_APPROVAL_DEPT WHERE CONTRACT_APPROVAL_STEP_ID= {0}",
Utils.ToSQLStr(entity.ContractApprovalStepId).Trim());
var val = DataAccess.SelectScalar(strsql.ToString());
var approvalEntites = new List <CasContractApprovalStepApprovalDeptEntity>();
string[] approvalD = new string[] { };
if (!string.IsNullOrWhiteSpace(entity.ExaminationValue))
{
approvalD = entity.ExaminationValue.ToString().Split(',');
}
for (int j = 0; j < approvalD.Length; j++)
{
var approvalEntity = new CasContractApprovalStepApprovalDeptEntity();
approvalEntity.ContractApprovalStepApprovalDeptId = Guid.NewGuid().ToString();
approvalEntity.ContractApprovalStepId = entity.ContractApprovalStepId;
approvalEntity.DeptId = approvalD[j];
approvalEntity.CreatedBy = WebCaching.UserId;
approvalEntity.CreateTime = DateTime.Now;
approvalEntity.LastModifiedBy = WebCaching.UserId;
approvalEntity.LastModifiedTime = DateTime.Now;
approvalEntites.Add(approvalEntity);
}
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
broker.BeginTransaction();
DataAccess.Insert <CasContractApprovalStepApprovalDeptEntity>(approvalEntites, broker);
DataAccess.Update(entity, broker);
broker.Commit();
return(true);
}
catch (Exception ex)
{
broker.RollBack();
return(false);
}
}
}
public virtual bool SaveUserPermissionAdd(string UserId, string strUserDeptIds, ref string strError)
{
if (string.IsNullOrEmpty(UserId))
{
return(false);
}
string[] arr = strUserDeptIds.Split(new char[] { ',' });
List <CasUserPermissionEntity> lst = new List <CasUserPermissionEntity>();
if (arr != null && arr.Length > 0)
{
foreach (var item in arr)
{
lst.Add(new CasUserPermissionEntity
{
DeptId = item,
PermissionId = Guid.NewGuid().ToString(),
UserId = UserId,
IsDeleted = false,
CreatedBy = WebCaching.UserId,
CreateTime = DateTime.Now,
LastModifiedBy = WebCaching.UserId,
LastModifiedTime = DateTime.Now
});
}
}
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
DataAccess.ExcuteNoneQuery("delete CAS_USER_PERMISSION where USER_ID='" + UserId + "' ", broker);
if (lst != null && lst.Count > 0)
{
DataAccess.Insert <CasUserPermissionEntity>(lst, broker);
}
broker.Commit();
}
catch (Exception ex)
{
SystemService.LogErrorService.InsertLog(ex);
broker.RollBack();
return(false);
}
}
return(true);
}
public virtual bool SaveRoleAdd(string UserId, string strRoleIds, string systemName, ref string strError)
{
if (string.IsNullOrEmpty(UserId))
{
return(false);
}
string[] arr = strRoleIds.Split(new char[] { ',' });
List <SecUserRoleEntity> lst = new List <SecUserRoleEntity>();
if (arr != null && arr.Length > 0)
{
foreach (var item in arr)
{
lst.Add(new SecUserRoleEntity
{
RoleId = item,
UserRoleId = Guid.NewGuid().ToString(),
UserId = UserId,
SystemName = systemName,
LastModifiedBy = WebCaching.UserId,
LastModifiedTime = DateTime.Now
});
}
}
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
DataAccess.ExcuteNoneQuery("delete SEC_USER_ROLE where USER_ID='" + UserId + "' and SYSTEM_NAME='" + systemName + "' ", broker);
if (lst != null && lst.Count > 0)
{
DataAccess.Insert <SecUserRoleEntity>(lst, broker);
}
broker.Commit();
}
catch (Exception ex)
{
SystemService.LogErrorService.InsertLog(ex);
broker.RollBack();
return(false);
}
}
return(true);
}
public virtual bool Save(string roleid, string strPageIds, ref string strError)
{
if (string.IsNullOrEmpty(roleid))
{
return(false);
}
string[] arr = strPageIds.Split(new char[] { ',' });
List <SecRolePageEntity> lst = new List <SecRolePageEntity>();
if (arr != null && arr.Length > 0)
{
foreach (var item in arr)
{
lst.Add(new SecRolePageEntity {
RoleId = roleid,
PageId = item,
LastModifiedBy = WebCaching.UserId,
LastModifiedTime = DateTime.Now
});
}
}
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
foreach (var item in lst)
{
DataAccess.ExcuteNoneQuery("delete SEC_ROLE_PAGE where ROLE_ID='" + item.RoleId + "'", broker);
}
if (lst != null && lst.Count > 0)
{
DataAccess.Insert <SecRolePageEntity>(lst, broker);
}
broker.Commit();
}
catch (Exception ex)
{
SystemService.LogErrorService.InsertLog(ex);
broker.RollBack();
return(false);
}
}
return(true);
}
/// <summary>
/// 跟新用户的登录密码
/// </summary>
/// <param name="userEntity"></param>
public void UpdateUser(LubrUserEntity userEntity)
{
//首先我得获取用户的id
var phone = userEntity.phonenumber.ToString().Trim();
var account = userEntity.username.ToString().Trim();
var userID = GetUserIdByPhoneAndAccount(phone, account);
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
broker.BeginTransaction();
CasUserEntity user = SystemService.UserService.GetById <CasUserEntity>(userID);
user.Password = Encryption.Encrypt(userEntity.password);
user.LastModifiedBy = "忘记密码";
user.LastModifiedTime = DateTime.Now;
DataAccess.Update(user, broker);
broker.Commit();
}
}
/// <summary>
/// 操作RoleUser提交功能,先删除,后插入
/// </summary>
/// <param name="userIds"></param>
/// <returns></returns>
public virtual bool SaveFunctionRoleUserDomain(List <SecUserRoleEntity> DeleteDic, List <SecUserRoleEntity> InsertDic)
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
broker.BeginTransaction();
DataAccess.Delete <SecUserRoleEntity>(DeleteDic, broker);
DataAccess.Insert <SecUserRoleEntity>(InsertDic, broker);
broker.Commit();
return(true);
}
catch
{
broker.RollBack();
return(false);
}
}
}
/// <summary>
/// 删除实体
/// </summary>
public virtual bool Delete <T>(List <string> listId) where T : EntityBase, new()
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
broker.BeginTransaction();
Delete <T>(listId, broker);
broker.Commit();
return(true);
}
catch (Exception ex)
{
broker.RollBack();
Log(ex);
return(false);
}
}
}
public virtual bool SaveUserAdd(string DeptId, string strUserIds, ref string strError)
{
if (string.IsNullOrEmpty(DeptId))
{
return(false);
}
string[] arr = strUserIds.Split(new char[] { ',' });
arr = arr.Where(p => p.Length > 0).ToArray();
List <CasDeptUserEntity> lst = new List <CasDeptUserEntity>();
if (arr != null && arr.Length > 0)
{
foreach (var item in arr)
{
lst.Add(new CasDeptUserEntity
{
UserId = item,
DeptId = DeptId,
LastModifiedBy = WebCaching.UserId,
LastModifiedTime = DateTime.Now
});
}
}
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
DataAccess.ExcuteNoneQuery("delete CAS_DEPT_USER where Dept_ID='" + DeptId + "'", broker);
if (lst != null && lst.Count > 0)
{
DataAccess.Insert <CasDeptUserEntity>(lst, broker);
}
broker.Commit();
}
catch (Exception ex)
{
SystemService.LogErrorService.InsertLog(ex);
broker.RollBack();
return(false);
}
}
return(true);
}
/// <summary>
/// 初始化选中年份所有周六、周日为非工作日
/// </summary>
/// <param name="year"></param>
/// <returns></returns>
public virtual bool InitHoliday(string year, ref string strError)
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
string startDate = year + "-01-01";
string endDate = year + "-12-31";
broker.BeginTransaction();
string sqlString = "DELETE FROM CAS_HOLIDAY WHERE HOLIDAY_DATE >= '" + startDate + "' AND HOLIDAY_DATE <= '" + endDate + "'";
broker.ExecuteNonQuery(sqlString, null, CommandType.Text);
DateTime dtStartDate = DateTime.Parse(startDate);
DateTime dtEndDate = DateTime.Parse(endDate);
for (DateTime dt = dtStartDate; dt <= dtEndDate; dt = dt.AddDays(1))
{
if (((int)dt.DayOfWeek == 0) || ((int)dt.DayOfWeek == 6))
{
CasHolidayEntity casHolidayEntity = new CasHolidayEntity();
casHolidayEntity.HolidayId = Guid.NewGuid().ToString();
casHolidayEntity.HolidayDate = dt;
casHolidayEntity.IsDeleted = false;
casHolidayEntity.CreateTime = DateTime.Now;
casHolidayEntity.CreatedBy = WebCaching.UserId;
casHolidayEntity.LastModifiedTime = DateTime.Now;
casHolidayEntity.LastModifiedBy = WebCaching.UserId;
Insert(casHolidayEntity, broker);
}
}
broker.Commit();
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
broker.RollBack();
return(false);
}
}
}
public virtual bool DeleteApprovalStep(string ApprovalStepID)
{
using (DataAccessBroker broker = DataAccessFactory.Instance())
{
try
{
List <CasContractApprovalStepApplyDeptEntity> applyDeptEntity = new List <CasContractApprovalStepApplyDeptEntity>();
List <CasContractApprovalStepApprovalDeptEntity> approvalDeptEntity = new List <CasContractApprovalStepApprovalDeptEntity>();
var entity = GetById <CasContractApprovalStepEntity>(ApprovalStepID);
var strsql = new StringBuilder();
strsql.AppendFormat(" SELECT CONTRACT_APPROVAL_STEP_APPLY_DEPT_ID FROM CAS_CONTRACT_APPROVAL_STEP_APPLY_DEPT WHERE CONTRACT_APPROVAL_STEP_ID='{0}'", ApprovalStepID);
DataSet dataSet = DataAccess.SelectDataSet(strsql.ToString());
string[] ary = Array.ConvertAll <DataRow, string>(dataSet.Tables[0].Rows.Cast <DataRow>().ToArray(), r => r["CONTRACT_APPROVAL_STEP_APPLY_DEPT_ID"].ToString());
var strsqlAppro = new StringBuilder();
strsqlAppro.AppendFormat(" SELECT CONTRACT_APPROVAL_STEP_APPROVAL_DEPT_ID FROM CAS_CONTRACT_APPROVAL_STEP_APPROVAL_DEPT WHERE CONTRACT_APPROVAL_STEP_ID='{0}'", ApprovalStepID);
DataSet dataSetAppro = DataAccess.SelectDataSet(strsqlAppro.ToString());
string[] aryAppro = Array.ConvertAll <DataRow, string>(dataSetAppro.Tables[0].Rows.Cast <DataRow>().ToArray(), r => r["CONTRACT_APPROVAL_STEP_APPROVAL_DEPT_ID"].ToString());
foreach (string id in ary)
{
applyDeptEntity.Add(GetById <CasContractApprovalStepApplyDeptEntity>(id));
}
foreach (string id in aryAppro)
{
approvalDeptEntity.Add(GetById <CasContractApprovalStepApprovalDeptEntity>(id));
}
broker.BeginTransaction();
DataAccess.Delete <CasContractApprovalStepApplyDeptEntity>(applyDeptEntity, broker);
DataAccess.Delete <CasContractApprovalStepApprovalDeptEntity>(approvalDeptEntity, broker);
Delete(entity);
broker.Commit();
return(true);
}
catch (Exception ex)
{
broker.RollBack();
return(false);
}
}
}
