/// <summary>
/// 修改组织机构
/// </summary>
/// <param name="orgEntity"></param>
/// <param name="tran"></param>
/// <returns></returns>
public static int UpdateOrg(OrgEntity orgEntity, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@OrgID", orgEntity.OrgID),
new SqlParameter("@OrgName", orgEntity.OrgName),
new SqlParameter("@Coperson", orgEntity.Coperson),
new SqlParameter("@CardType", orgEntity.CardType),
new SqlParameter("@CardNum", orgEntity.CardNum),
new SqlParameter("@ParentOrgID", orgEntity.ParentOrgId),
new SqlParameter("@ParentOrgName", orgEntity.ParentOrgName),
new SqlParameter("@Reperson", orgEntity.Reperson),
new SqlParameter("@PhoneNum", orgEntity.PhoneNum),
// new SqlParameter("@TelePhone",orgEntity.TelePhone),//组织编码不能修改
new SqlParameter("@Email", orgEntity.Email),
new SqlParameter("@Address", orgEntity.Address),
new SqlParameter("@AddTime", orgEntity.AddTime),
new SqlParameter("@Status", (int)orgEntity.Status)
};
StringBuilder strSql = new StringBuilder();
// strSql.AppendFormat(@"UPDATE Base_Org SET
// OrgName = @OrgName,Coperson = @Coperson,CardType =@CardType,CardNum = @CardNum,ParentOrgID = @ParentOrgID,ParentOrgName=@ParentOrgName,Reperson = @Reperson,
// PhoneNum = @PhoneNum,TelePhone = @TelePhone,Email = @Email,Address =@Address,AddTime = @AddTime,Status = @Status
// WHERE OrgID = @OrgID", Fields.Org_FIELD_List);
strSql.AppendFormat(@"UPDATE Base_Org SET
OrgName = @OrgName,Coperson = @Coperson,CardType =@CardType,CardNum = @CardNum,ParentOrgID = @ParentOrgID,ParentOrgName=@ParentOrgName,Reperson = @Reperson,
PhoneNum = @PhoneNum,Email = @Email,Address =@Address,AddTime = @AddTime,Status = @Status
WHERE OrgID = @OrgID", Fields.Org_FIELD_List);
object obj = DbHelper.ExecuteNonQuery(strSql.ToString(), parms, tran.Transaction);
return(obj == null || obj == DBNull.Value ? 0 : Convert.ToInt32(obj));
}
/// <summary>
/// 删除用户角色
/// </summary>
/// <param name="userId">用户角色ID</param>
/// <param name="tran"></param>
/// <returns>影响记录数</returns>
public static int DeleteUserRole(string userId, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@userId", userId)
};
string sqlCommand = string.Format(@"delete from Base_Org where userId=@userId");
return(DbHelper.ExecuteNonQuery(sqlCommand, parms, tran.Transaction));
}
/// <summary>
/// 删除组织机构
/// </summary>
/// <param name="orgId">组织机构ID</param>
/// <param name="tran"></param>
/// <returns>影响记录数</returns>
public static int DeleteOrg(string orgId, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@OrgID", orgId)
};
string sqlCommand = string.Format(@"delete from Base_Org where orgID=@OrgID");
return(DbHelper.ExecuteNonQuery(sqlCommand, parms, tran.Transaction));
}
/// <summary>
/// 根据角色对象删除角色权限关系
/// </summary>
/// <param name="roleID">ID</param>
/// <param name="tran"></param>
/// <returns></returns>
public static int DeleteRolePrivilege(string roleID, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@RoleID", roleID)
};
string sqlCommand = string.Format(@"DELETE Base_RolePrivilege where RoleID=@RoleID");
return(DbHelper.ExecuteNonQuery(sqlCommand, parms, tran.Transaction));
}
/// <summary>
/// 修改用户角色
/// </summary>
/// <param name="roleEntity"></param>
/// <param name="tran"></param>
/// <returns></returns>
public static int UpdateUserRole(UserRoleEntity roleEntity, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@userId", roleEntity.UserId),
new SqlParameter("@RoleID", roleEntity.RoleID)
};
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"UPDATE Base_UserRole SET RoleID = @RoleID WHERE userId = @userId", Fields.UserRole_FIELD_List);
object obj = DbHelper.ExecuteNonQuery(strSql.ToString(), parms, tran.Transaction);
return(obj == null || obj == DBNull.Value ? 0 : Convert.ToInt32(obj));
}
public static int UpdateChileOrg(OrgEntity orgEntity, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@ParentOrgID", orgEntity.ParentOrgId),
new SqlParameter("@ParentOrgName", orgEntity.ParentOrgName)
};
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"UPDATE Base_Org SET ParentOrgName=@ParentOrgName WHERE ParentOrgID = @ParentOrgID");
object obj = DbHelper.ExecuteNonQuery(strSql.ToString(), parms, tran.Transaction);
return(obj == null || obj == DBNull.Value ? 0 : Convert.ToInt32(obj));
}
/// <summary>
/// 新增角色权限
/// </summary>
/// <param name="roleEntity"></param>
/// <param name="tran"></param>
/// <returns></returns>
public static int AddRolePrivilege(RolePrivilegeEntity roleEntity, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@PrivilegeId", roleEntity.PrivilegeId),
new SqlParameter("@RoleID", roleEntity.RoleID)
};
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("insert into Base_RolePrivilege({0})", Fields.RolePrivilege_FIELD_List);
strSql.AppendFormat(" values ({0})", "@" + Fields.RolePrivilege_FIELD_List.Replace(",", ",@"));
object obj = DbHelper.ExecuteNonQuery(strSql.ToString(), parms, tran.Transaction);
return(obj == null || obj == DBNull.Value ? 0 : Convert.ToInt32(obj));
}
/// <summary>
/// 新增组织机构
/// </summary>
/// <param name="orgEntity"></param>
/// <param name="tran"></param>
/// <returns></returns>
public static int AddOrg(OrgEntity orgEntity, YicelTransaction tran)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@OrgID", orgEntity.OrgID),
new SqlParameter("@OrgName", orgEntity.OrgName),
new SqlParameter("@Coperson", orgEntity.Coperson),
new SqlParameter("@CardType", orgEntity.CardType),
new SqlParameter("@CardNum", orgEntity.CardNum),
new SqlParameter("@ParentOrgId", orgEntity.ParentOrgId),
new SqlParameter("@ParentOrgName", orgEntity.ParentOrgName),
new SqlParameter("@Reperson", orgEntity.Reperson),
new SqlParameter("@PhoneNum", orgEntity.PhoneNum),
new SqlParameter("@TelePhone", orgEntity.TelePhone),
new SqlParameter("@Email", orgEntity.Email),
new SqlParameter("@Address", orgEntity.Address),
new SqlParameter("@AddTime", orgEntity.AddTime),
new SqlParameter("@Status", (int)orgEntity.Status)
};
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("insert into Base_Org({0})", Fields.Org_FIELD_List);
strSql.AppendFormat(" values ({0})", "@" + Fields.Org_FIELD_List.Replace(",", ",@"));
object obj = DbHelper.ExecuteNonQuery(strSql.ToString(), parms, tran.Transaction);
StringBuilder strbld = new StringBuilder();
string strdt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//构造新增组织用户信息的sql语句
strbld.AppendFormat(@"insert into Base_User([userId],[userName],[status],[Accounttype],[Account],[LoginPwd],
[CardType],[CardNum],[OrgId],[PhoneNum],[TelNum],[Email],[LinkAdress],[sex],[OpenTime],
[LastUpdateTime],[LastUpdateID],[Online],[UserType],[BindAccount])
values('{0}','{1}','{2}','{3}','{4}','{5}',",
orgEntity.OrgID, string.IsNullOrEmpty(orgEntity.OrgName) ? string.Empty : orgEntity.OrgName,
1, 1, orgEntity.TelePhone, com.individual.helper.Des3.Des3EncodeCBC("123456"));
strbld.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}',", 1, string.IsNullOrEmpty(orgEntity.CardNum) ? string.Empty : orgEntity.CardNum, orgEntity.OrgID,
orgEntity.PhoneNum, string.Empty, string.IsNullOrEmpty(orgEntity.Email) ? string.Empty : orgEntity.Email);
strbld.AppendFormat("'{0}','{1}','{2}','{3}','{4}',{5},{6},'{7}')",
string.IsNullOrEmpty(orgEntity.Address) ? string.Empty : orgEntity.Address, 1, strdt, strdt,
string.Empty, 0, 2, string.Empty);
obj = DbHelper.ExecuteNonQuery(strbld.ToString(), null, tran.Transaction);
return(obj == null || obj == DBNull.Value ? 0 : Convert.ToInt32(obj));
}
