/// <summary> /// 查询人才代理信息 /// </summary> /// <param name="proxyID">人才代理ID</param> /// <returns></returns> public static DataTable SearchProxyInfo(HRProxyModel model) { #region 查询语句 StringBuilder searchSql = new StringBuilder(); searchSql.AppendLine(" SELECT "); searchSql.AppendLine(" ID "); searchSql.AppendLine(" ,isnull(ProxyCompanyCD,'')ProxyCompanyCD "); searchSql.AppendLine(" ,isnull(ProxyCompanyName,'')ProxyCompanyName "); searchSql.AppendLine(" ,CASE Important "); searchSql.AppendLine(" WHEN '1' THEN '不重要' "); searchSql.AppendLine(" WHEN '2' THEN '普通' "); searchSql.AppendLine(" WHEN '3' THEN '重要' "); searchSql.AppendLine(" WHEN '4' THEN '关键' "); searchSql.AppendLine(" ELSE '' "); searchSql.AppendLine(" END AS Important "); searchSql.AppendLine(" ,CASE Cooperation "); searchSql.AppendLine(" WHEN '1' THEN '付费服务' "); searchSql.AppendLine(" WHEN '2' THEN '一般服务' "); searchSql.AppendLine(" ELSE '' "); searchSql.AppendLine(" END AS Cooperation "); searchSql.AppendLine(" ,ISNULL(ContactName,'') AS ContactName"); searchSql.AppendLine(" ,ISNULL(ContactTel,'') AS ContactTel"); searchSql.AppendLine(" ,ISNULL(ContactMobile,'') AS ContactMobile"); searchSql.AppendLine(" ,ISNULL(ContactWeb,'') AS ContactWeb"); searchSql.AppendLine(" ,CASE WHEN "); searchSql.AppendLine(" UsedStatus = '1'"); searchSql.AppendLine(" THEN '已启用' "); searchSql.AppendLine(" ELSE '未启用' "); searchSql.AppendLine(" END AS UsedStatus "); searchSql.AppendLine(" FROM officedba.HRProxy "); searchSql.AppendLine(" WHERE CompanyCD = @CompanyCD "); //searchSql.AppendLine(" AND UsedStatus='1' "); #endregion //定义查询的命令 SqlCommand comm = new SqlCommand(); //添加公司代码参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //企业编号 if (!string.IsNullOrEmpty(model.ProxyCompanyCD)) { searchSql.AppendLine(" AND ProxyCompanyCD LIKE '%' + @ProxyCompanyCD + '%' "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProxyCompanyCD", model.ProxyCompanyCD)); } //企业名称 if (!string.IsNullOrEmpty(model.ProxyCompanyName)) { searchSql.AppendLine(" AND ProxyCompanyName LIKE '%' + @ProxyCompanyName + '%' "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProxyCompanyName", model.ProxyCompanyName)); } //重要程度 if (!string.IsNullOrEmpty(model.Important)) { searchSql.AppendLine(" AND Important = @Important "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@Important", model.Important)); } //合作关系 if (!string.IsNullOrEmpty(model.Cooperation)) { searchSql.AppendLine(" AND Cooperation = @Cooperation "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@Cooperation", model.Cooperation)); } //启用状态 if (!string.IsNullOrEmpty(model.UsedStatus)) { searchSql.AppendLine(" AND UsedStatus = @UsedStatus "); comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus)); } //指定命令的SQL文 comm.CommandText = searchSql.ToString(); //执行查询 return SqlHelper.ExecuteSearch(comm); }
/// <summary> /// 保存时参数设置 /// </summary> /// <param name="comm">命令</param> /// <param name="model">人才代理信息</param> private static void SetSaveParameter(SqlCommand comm, HRProxyModel model) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProxyCompanyCD", model.ProxyCompanyCD));//代理公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));//公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProxyCompanyName", model.ProxyCompanyName));//代理公司名称 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Nature", model.Nature));//代理公司性质 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Address", model.Address));//地址 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Corporate", model.Corporate));//企业法人 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Telephone", model.Telephone));//电话 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Fax", model.Fax));//传真 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Email", model.Email));//邮箱 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Website", model.Website));//网址 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Important", model.Important));//重要程度(1不重要,2普通,3重要,4关键) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Cooperation", model.Cooperation));//合作关系(1 付费服务,2 一般服务) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Standard", model.Standard));//收费标准 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ContactName", model.ContactName));//联系人姓名 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ContactTel", model.ContactTel));//联系人固定电话 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ContactMobile", model.ContactMobile));//联系人移动电话 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ContactWeb", model.ContactWeb));//联系人网络通讯 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ContactPosition ", model.ContactPosition));//联系人公司职务 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ContactCardNo", model.ContactCardNo));//联系人工号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ContactRemark", model.ContactRemark));//联系人备注 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));//附加信息 comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));//启用标识(0 停用,1 启用) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID));//更新用户ID }
/// <summary> /// 更新人才代理信息 /// </summary> /// <param name="model">人才代理信息</param> /// <returns></returns> public static bool UpdateHRProxyInfo(HRProxyModel model) { #region SQL文拼写 StringBuilder updateSql = new StringBuilder(); updateSql.AppendLine(" UPDATE officedba.HRProxy "); updateSql.AppendLine(" SET "); updateSql.AppendLine(" ProxyCompanyName = @ProxyCompanyName "); updateSql.AppendLine(" ,Nature = @Nature "); updateSql.AppendLine(" ,Address = @Address "); updateSql.AppendLine(" ,Corporate = @Corporate "); updateSql.AppendLine(" ,Telephone = @Telephone "); updateSql.AppendLine(" ,Fax = @Fax "); updateSql.AppendLine(" ,Email = @Email "); updateSql.AppendLine(" ,Website = @Website "); updateSql.AppendLine(" ,Important = @Important "); updateSql.AppendLine(" ,Cooperation = @Cooperation "); updateSql.AppendLine(" ,Standard = @Standard "); updateSql.AppendLine(" ,ContactName = @ContactName "); updateSql.AppendLine(" ,ContactTel = @ContactTel "); updateSql.AppendLine(" ,ContactMobile = @ContactMobile "); updateSql.AppendLine(" ,ContactWeb = @ContactWeb "); updateSql.AppendLine(" ,ContactPosition = @ContactPosition "); updateSql.AppendLine(" ,ContactCardNo = @ContactCardNo "); updateSql.AppendLine(" ,ContactRemark = @ContactRemark "); updateSql.AppendLine(" ,Remark = @Remark "); updateSql.AppendLine(" ,UsedStatus = @UsedStatus "); updateSql.AppendLine(" ,ModifiedDate = getdate() "); updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); updateSql.AppendLine(" WHERE ProxyCompanyCD = @ProxyCompanyCD "); updateSql.AppendLine(" AND CompanyCD = @CompanyCD "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = updateSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //定义更新列表 ArrayList lstInsert = new ArrayList(); //添加插入命令 lstInsert.Add(comm); //执行插入并返回插入结果 return SqlHelper.ExecuteTransWithArrayList(lstInsert); }
/// <summary> /// 新建人才代理信息 /// </summary> /// <param name="model">人才代理信息</param> /// <returns></returns> public static bool InsertHRProxyInfo(HRProxyModel model) { #region SQL文拼写 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine(" INSERT INTO officedba.HRProxy "); insertSql.AppendLine(" (CompanyCD "); insertSql.AppendLine(" ,ProxyCompanyCD "); insertSql.AppendLine(" ,ProxyCompanyName "); insertSql.AppendLine(" ,Nature "); insertSql.AppendLine(" ,Address "); insertSql.AppendLine(" ,Corporate "); insertSql.AppendLine(" ,Telephone "); insertSql.AppendLine(" ,Fax "); insertSql.AppendLine(" ,Email "); insertSql.AppendLine(" ,Website "); insertSql.AppendLine(" ,Important "); insertSql.AppendLine(" ,Cooperation "); insertSql.AppendLine(" ,Standard "); insertSql.AppendLine(" ,ContactName "); insertSql.AppendLine(" ,ContactTel "); insertSql.AppendLine(" ,ContactMobile "); insertSql.AppendLine(" ,ContactWeb "); insertSql.AppendLine(" ,ContactPosition "); insertSql.AppendLine(" ,ContactCardNo "); insertSql.AppendLine(" ,ContactRemark "); insertSql.AppendLine(" ,Remark "); insertSql.AppendLine(" ,UsedStatus "); insertSql.AppendLine(" ,ModifiedDate "); insertSql.AppendLine(" ,ModifiedUserID) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@CompanyCD "); insertSql.AppendLine(" ,@ProxyCompanyCD "); insertSql.AppendLine(" ,@ProxyCompanyName "); insertSql.AppendLine(" ,@Nature "); insertSql.AppendLine(" ,@Address "); insertSql.AppendLine(" ,@Corporate "); insertSql.AppendLine(" ,@Telephone "); insertSql.AppendLine(" ,@Fax "); insertSql.AppendLine(" ,@Email "); insertSql.AppendLine(" ,@Website "); insertSql.AppendLine(" ,@Important "); insertSql.AppendLine(" ,@Cooperation "); insertSql.AppendLine(" ,@Standard "); insertSql.AppendLine(" ,@ContactName "); insertSql.AppendLine(" ,@ContactTel "); insertSql.AppendLine(" ,@ContactMobile "); insertSql.AppendLine(" ,@ContactWeb "); insertSql.AppendLine(" ,@ContactPosition "); insertSql.AppendLine(" ,@ContactCardNo "); insertSql.AppendLine(" ,@ContactRemark "); insertSql.AppendLine(" ,@Remark "); insertSql.AppendLine(" ,@UsedStatus "); insertSql.AppendLine(" ,getdate() "); insertSql.AppendLine(" ,@ModifiedUserID) "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = insertSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //定义更新列表 ArrayList lstInsert = new ArrayList(); //添加插入命令 lstInsert.Add(comm); //执行插入并返回插入结果 return SqlHelper.ExecuteTransWithArrayList(lstInsert); }
/// <summary> /// 编辑人才代理信息 /// </summary> /// <param name="model">人才代理信息</param> /// <returns></returns> public static bool SaveHRProxyInfo(HRProxyModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; model.ModifiedUserID = userInfo.UserID; //定义返回变量 bool isSucc = false; //操作日志 LogInfoModel logModel = InitLogInfo(model.ProxyCompanyCD); //ID存在时,更新 if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag)) { try { logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //执行更新操作 isSucc = HRProxyDBHelper.UpdateHRProxyInfo(model); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } } //插入 else { try { logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //执行插入操作 isSucc = HRProxyDBHelper.InsertHRProxyInfo(model); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } } //更新成功时,删除原来文件 if (isSucc) { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } //更新不成功 else { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; }
/// <summary> /// 查询人才代理信息 /// </summary> /// <param name="proxyID">人才代理ID</param> /// <returns></returns> public static DataTable SearchProxyInfo(HRProxyModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; return HRProxyDBHelper.SearchProxyInfo(model); }