/// <summary> /// 新建公司 /// </summary> /// <param name="company">公司实体对象</param> /// <param name="tran">中间事务对象</param> /// <returns>返回处理后的公司实体对象</returns> public Company Add(Company company, ICTransaction tran) { if (company == null) { throw new ArgumentNullException("company"); } company.CompanyId = KeyGenerator.GenNewGuidKey(); StringBuilder query = new StringBuilder(); query.AppendLine(@"INSERT INTO "); query.AppendLine(@" `Company` ( "); query.AppendLine(@" `CompanyId` "); query.AppendLine(@" ,`CompanyCode` "); query.AppendLine(@" ,`Name` "); query.AppendLine(@" ,`Address` "); query.AppendLine(@" ,`ParentCompanyId` "); query.AppendLine(@" ,`RVersion` "); query.AppendLine(@" ,`Status` "); query.AppendLine(@" ,`CreaterId` "); query.AppendLine(@" ,`CreateTime` "); query.AppendLine(@" ,`UpdatorId` "); query.AppendLine(@" ,`UpdateTime` "); query.AppendLine(@" ) "); query.AppendLine(@"VALUES ( "); query.AppendLine(@" @CompanyId "); query.AppendLine(@" ,@CompanyCode "); query.AppendLine(@" ,@Name "); query.AppendLine(@" ,@Address "); query.AppendLine(@" ,@ParentCompanyId "); query.AppendLine(@" ,@RVersion "); query.AppendLine(@" ,@Status "); query.AppendLine(@" ,@CreaterId "); query.AppendLine(@" ,@CreateTime "); query.AppendLine(@" ,@UpdatorId "); query.AppendLine(@" ,@UpdateTime "); query.AppendLine(@"); "); MySqlParameter[] paramCollection = new MySqlParameter[11]; paramCollection[0] = new MySqlParameter("@CompanyId", MySqlDbType.String, 40); paramCollection[1] = new MySqlParameter("@CompanyCode", MySqlDbType.String, 5); paramCollection[2] = new MySqlParameter("@Name", MySqlDbType.String, 200); paramCollection[3] = new MySqlParameter("@Address", MySqlDbType.String, 500); paramCollection[4] = new MySqlParameter("@ParentCompanyId", MySqlDbType.String, 40); paramCollection[5] = new MySqlParameter("@RVersion", MySqlDbType.Int32); paramCollection[6] = new MySqlParameter("@Status", MySqlDbType.Int32); paramCollection[7] = new MySqlParameter("@CreaterId", MySqlDbType.String, 40); paramCollection[8] = new MySqlParameter("@CreateTime", MySqlDbType.DateTime); paramCollection[9] = new MySqlParameter("@UpdatorId", MySqlDbType.String, 40); paramCollection[10] = new MySqlParameter("@UpdateTime", MySqlDbType.DateTime); paramCollection[0].Value = company.CompanyId; paramCollection[1].Value = company.CompanyCode; paramCollection[2].Value = company.Name; paramCollection[3].Value = company.Address; paramCollection[4].Value = company.ParentCompanyId; paramCollection[5].Value = company.RVersion; paramCollection[6].Value = company.Status; paramCollection[7].Value = company.CreaterId; paramCollection[8].Value = company.CreateTime; paramCollection[9].Value = company.UpdatorId; paramCollection[10].Value = company.UpdateTime; try { int effectCount = 0; if (company != null) { if (tran != null) { effectCount = MySqlHelper.ExecuteNonQuery((MySqlConnection)tran.Connection, query.ToString(), paramCollection); } else { effectCount = MySqlHelper.ExecuteNonQuery(this.CurrentConnectionString, query.ToString(), paramCollection); } } if (effectCount == 0) { company.CompanyId = string.Empty; throw new ResponseException((int)ResultCode.NoDataInsert, company.CompanyCode); } } catch (Exception ex) { company.CompanyId = string.Empty; throw new Exception(ex.Message, ex); } return(company); }
/// <summary> /// 新建公司 /// </summary> /// <param name="company">公司实体对象</param> /// <param name="tran">中间事务对象</param> /// <returns>返回处理后的公司实体对象</returns> public Company Add(Company company, ICTransaction tran) { if (company == null) { throw new ArgumentNullException("company"); } company.CompanyId = KeyGenerator.GenNewGuidKey(); StringBuilder query = new StringBuilder(); query.AppendLine(@"INSERT INTO "); query.AppendLine(@" [Company] ( "); query.AppendLine(@" [CompanyId] "); query.AppendLine(@" ,[CompanyCode] "); query.AppendLine(@" ,[Name] "); query.AppendLine(@" ,[Address] "); query.AppendLine(@" ,[ParentCompanyId] "); query.AppendLine(@" ,[RVersion] "); query.AppendLine(@" ,[Status] "); query.AppendLine(@" ,[CreaterId] "); query.AppendLine(@" ,[CreateTime] "); query.AppendLine(@" ,[UpdatorId] "); query.AppendLine(@" ,[UpdateTime] "); query.AppendLine(@" ) "); query.AppendLine(@"VALUES ( "); query.AppendLine(@" @CompanyId "); query.AppendLine(@" ,@CompanyCode "); query.AppendLine(@" ,@Name "); query.AppendLine(@" ,@Address "); query.AppendLine(@" ,@ParentCompanyId "); query.AppendLine(@" ,@RVersion "); query.AppendLine(@" ,@Status "); query.AppendLine(@" ,@CreaterId "); query.AppendLine(@" ,@CreateTime "); query.AppendLine(@" ,@UpdatorId "); query.AppendLine(@" ,@UpdateTime "); query.AppendLine(@"); "); DBParamCollection <DBParam> paramCollection = new DBParamCollection <DBParam>(); paramCollection.Add(new DBParam("@CompanyId", company.CompanyId, DbType.String, 40)); paramCollection.Add(new DBParam("@CompanyCode", company.CompanyCode, DbType.String, 5)); paramCollection.Add(new DBParam("@Name", company.Name, DbType.String, 200)); paramCollection.Add(new DBParam("@Address", company.Address, DbType.String, 500)); paramCollection.Add(new DBParam("@ParentCompanyId", company.ParentCompanyId, DbType.String, 40)); paramCollection.Add(new DBParam("@RVersion", company.RVersion, DbType.Int32)); paramCollection.Add(new DBParam("@Status", company.Status, DbType.Int32)); paramCollection.Add(new DBParam("@CreaterId", company.CreaterId, DbType.String, 40)); paramCollection.Add(new DBParam("@CreateTime", company.CreateTime, DbType.DateTime)); paramCollection.Add(new DBParam("@UpdatorId", company.UpdatorId, DbType.String, 40)); paramCollection.Add(new DBParam("@UpdateTime", company.UpdateTime, DbType.DateTime)); try { int effectCount = 0; if (company != null) { if (tran != null) { DbTransaction dbTran = ((MssqlTransaction)tran).CurrentTransaction; effectCount = MssqlHelper.ExecuteNonQuery(dbTran, CommandType.Text, query.ToString(), paramCollection); } else { effectCount = MssqlHelper.ExecuteNonQuery(this.CurrentConnectionString, CommandType.Text, query.ToString(), paramCollection); } } if (effectCount == 0) { company.CompanyId = string.Empty; throw new ResponseException((int)ResultCode.NoDataInsert, company.CompanyCode); } } catch (Exception ex) { company.CompanyId = string.Empty; throw new Exception(ex.Message, ex); } return(company); }
/// <summary> /// 新建员工 /// </summary> /// <param name="employee">员工实体对象</param> /// <param name="tran">中间事务对象</param> /// <returns>返回处理后的员工实体对象</returns> public Employee Add(Employee employee, ICTransaction tran) { if (employee == null) { throw new ArgumentNullException("employee"); } employee.EmployeeId = KeyGenerator.GenNewGuidKey(); StringBuilder query = new StringBuilder(); query.AppendLine(@"INSERT INTO "); query.AppendLine(@" `Employee` ( "); query.AppendLine(@" `EmployeeId` "); query.AppendLine(@" ,`EmployeeCode` "); query.AppendLine(@" ,`Name` "); query.AppendLine(@" ,`Birthday` "); query.AppendLine(@" ,`Sex` "); query.AppendLine(@" ,`CompanyId` "); query.AppendLine(@" ,`DepartmentId` "); query.AppendLine(@" ,`PositionId` "); query.AppendLine(@" ,`Rand` "); query.AppendLine(@" ,`RVersion` "); query.AppendLine(@" ,`Status` "); query.AppendLine(@" ,`CreaterId` "); query.AppendLine(@" ,`CreateTime` "); query.AppendLine(@" ,`UpdatorId` "); query.AppendLine(@" ,`UpdateTime` "); query.AppendLine(@" ,`StartWorkDate` "); query.AppendLine(@" ,`JoinDate` "); query.AppendLine(@" ) "); query.AppendLine(@"VALUES ("); query.AppendLine(@" @EmployeeId "); query.AppendLine(@" ,@EmployeeCode "); query.AppendLine(@" ,@Name "); query.AppendLine(@" ,@Birthday "); query.AppendLine(@" ,@Sex "); query.AppendLine(@" ,@CompanyId "); query.AppendLine(@" ,@DepartmentId "); query.AppendLine(@" ,@PositionId "); query.AppendLine(@" ,@Rand "); query.AppendLine(@" ,@RVersion "); query.AppendLine(@" ,@Status "); query.AppendLine(@" ,@CreaterId "); query.AppendLine(@" ,@CreateTime "); query.AppendLine(@" ,@UpdatorId "); query.AppendLine(@" ,@UpdateTime "); query.AppendLine(@" ,@StartWorkDate "); query.AppendLine(@" ,@JoinDate "); query.AppendLine(@"); "); MySqlParameter[] paramCollection = new MySqlParameter[17]; paramCollection[0] = new MySqlParameter("@EmployeeId", MySqlDbType.String, 40); paramCollection[1] = new MySqlParameter("@EmployeeCode", MySqlDbType.String, 15); paramCollection[2] = new MySqlParameter("@Name", MySqlDbType.String, 50); paramCollection[3] = new MySqlParameter("@Birthday", MySqlDbType.DateTime); paramCollection[4] = new MySqlParameter("@Sex", MySqlDbType.Int32); paramCollection[5] = new MySqlParameter("@CompanyId", MySqlDbType.String, 40); paramCollection[6] = new MySqlParameter("@DepartmentId", MySqlDbType.String, 40); paramCollection[7] = new MySqlParameter("@PositionId", MySqlDbType.String, 40); paramCollection[8] = new MySqlParameter("@Rand", MySqlDbType.Int32); paramCollection[9] = new MySqlParameter("@RVersion", MySqlDbType.Int32); paramCollection[10] = new MySqlParameter("@Status", MySqlDbType.Int32); paramCollection[11] = new MySqlParameter("@CreaterId", MySqlDbType.String, 40); paramCollection[12] = new MySqlParameter("@CreateTime", MySqlDbType.DateTime); paramCollection[13] = new MySqlParameter("@UpdatorId", MySqlDbType.String, 40); paramCollection[14] = new MySqlParameter("@UpdateTime", MySqlDbType.DateTime); paramCollection[15] = new MySqlParameter("@StartWorkDate", MySqlDbType.DateTime); paramCollection[16] = new MySqlParameter("@JoinDate", MySqlDbType.DateTime); paramCollection[0].Value = employee.EmployeeId; paramCollection[1].Value = employee.EmployeeCode; paramCollection[2].Value = employee.Name; paramCollection[3].Value = employee.Birthday; paramCollection[4].Value = employee.Sex; paramCollection[5].Value = employee.CompanyId; paramCollection[6].Value = employee.DepartmentId; paramCollection[7].Value = employee.PositionId; paramCollection[8].Value = employee.Rand; paramCollection[9].Value = employee.RVersion; paramCollection[10].Value = employee.Status; paramCollection[11].Value = employee.CreaterId; paramCollection[12].Value = employee.CreateTime; paramCollection[13].Value = employee.UpdatorId; paramCollection[14].Value = employee.UpdateTime; paramCollection[15].Value = employee.StartWorkDate; paramCollection[16].Value = employee.JoinDate; try { int effectCount = 0; if (tran != null) { effectCount = MySqlHelper.ExecuteNonQuery((MySqlConnection)tran.Connection, query.ToString(), paramCollection); } else { effectCount = MySqlHelper.ExecuteNonQuery(this.CurrentConnectionString, query.ToString(), paramCollection); } if (effectCount == 0) { employee.EmployeeId = string.Empty; throw new ResponseException((int)ResultCode.NoDataInsert, employee.EmployeeCode); } } catch (Exception ex) { employee.EmployeeId = string.Empty; throw new Exception(ex.Message, ex); } return(employee); }
/// <summary> /// 新建员工 /// </summary> /// <param name="employee">员工实体对象</param> /// <param name="tran">中间事务对象</param> /// <returns>返回处理后的员工实体对象</returns> public Employee Add(Employee employee, ICTransaction tran) { if (employee == null) { throw new ArgumentNullException("employee"); } employee.EmployeeId = KeyGenerator.GenNewGuidKey(); StringBuilder query = new StringBuilder(); query.AppendLine(@"INSERT INTO "); query.AppendLine(@" [Employee] ( "); query.AppendLine(@" [EmployeeId] "); query.AppendLine(@" ,[EmployeeCode] "); query.AppendLine(@" ,[Name] "); query.AppendLine(@" ,[Birthday] "); query.AppendLine(@" ,[Sex] "); query.AppendLine(@" ,[CompanyId] "); query.AppendLine(@" ,[DepartmentId] "); query.AppendLine(@" ,[PositionId] "); query.AppendLine(@" ,[Rand] "); query.AppendLine(@" ,[RVersion] "); query.AppendLine(@" ,[Status] "); query.AppendLine(@" ,[CreaterId] "); query.AppendLine(@" ,[CreateTime] "); query.AppendLine(@" ,[UpdatorId] "); query.AppendLine(@" ,[UpdateTime] "); query.AppendLine(@" ,[StartWorkDate] "); query.AppendLine(@" ,[JoinDate] "); query.AppendLine(@" ) "); query.AppendLine(@"VALUES ("); query.AppendLine(@" @EmployeeId "); query.AppendLine(@" ,@EmployeeCode "); query.AppendLine(@" ,@Name "); query.AppendLine(@" ,@Birthday "); query.AppendLine(@" ,@Sex "); query.AppendLine(@" ,@CompanyId "); query.AppendLine(@" ,@DepartmentId "); query.AppendLine(@" ,@PositionId "); query.AppendLine(@" ,@Rand "); query.AppendLine(@" ,@RVersion "); query.AppendLine(@" ,@Status "); query.AppendLine(@" ,@CreaterId "); query.AppendLine(@" ,@CreateTime "); query.AppendLine(@" ,@UpdatorId "); query.AppendLine(@" ,@UpdateTime "); query.AppendLine(@" ,@StartWorkDate "); query.AppendLine(@" ,@JoinDate "); query.AppendLine(@"); "); DBParamCollection <DBParam> paramCollection = new DBParamCollection <DBParam>(); paramCollection.Add(new DBParam("@EmployeeId", employee.EmployeeId, DbType.String, 40)); paramCollection.Add(new DBParam("@EmployeeCode", employee.EmployeeCode, DbType.String, 15)); paramCollection.Add(new DBParam("@Name", employee.Name, DbType.String, 50)); paramCollection.Add(new DBParam("@Birthday", employee.Birthday, DbType.DateTime)); paramCollection.Add(new DBParam("@Sex", employee.Sex, DbType.Int32)); paramCollection.Add(new DBParam("@CompanyId", employee.CompanyId, DbType.String, 40)); paramCollection.Add(new DBParam("@DepartmentId", employee.DepartmentId, DbType.String, 40)); paramCollection.Add(new DBParam("@PositionId", employee.PositionId, DbType.String, 40)); paramCollection.Add(new DBParam("@Rand", employee.Rand, DbType.Int32)); paramCollection.Add(new DBParam("@RVersion", employee.RVersion, DbType.Int32)); paramCollection.Add(new DBParam("@Status", employee.Status, DbType.Int32)); paramCollection.Add(new DBParam("@CreaterId", employee.CreaterId, DbType.String, 40)); paramCollection.Add(new DBParam("@CreateTime", employee.CreateTime, DbType.DateTime)); paramCollection.Add(new DBParam("@UpdatorId", employee.UpdatorId, DbType.String, 40)); paramCollection.Add(new DBParam("@UpdateTime", employee.UpdateTime, DbType.DateTime)); paramCollection.Add(new DBParam("@StartWorkDate", employee.StartWorkDate, DbType.DateTime)); paramCollection.Add(new DBParam("@JoinDate", employee.JoinDate, DbType.DateTime)); try { int effectCount = 0; if (tran != null) { DbTransaction dbTran = ((MssqlTransaction)tran).CurrentTransaction; effectCount = MssqlHelper.ExecuteNonQuery(dbTran, CommandType.Text, query.ToString(), paramCollection); } else { effectCount = MssqlHelper.ExecuteNonQuery(this.CurrentConnectionString, CommandType.Text, query.ToString(), paramCollection); } if (effectCount == 0) { employee.EmployeeId = string.Empty; throw new ResponseException((int)ResultCode.NoDataInsert, employee.EmployeeCode); } } catch (Exception ex) { employee.EmployeeId = string.Empty; throw new Exception(ex.Message, ex); } return(employee); }