| | |
| | | public string YwjlName { get; set; } |
| | | |
| | | public Boolean zhuanyi { get; set; } |
| | | |
| | | public string Weixin { get; set; } |
| | | public string Shifoutianjiaweixin { get; set; } |
| | | } |
| | | |
| | | public class CooperatecustomCustomerDTOSearch : SearchEntity |
| | |
| | | |
| | | public string Createtime { get; set; } |
| | | |
| | | public string Shifouweixin { get; set; } |
| | | |
| | | |
| | | } |
| | | } |
| | |
| | | public string DianxiaozhuanyuanName { get; set; } |
| | | public DateTime? Zuijinzhuizongtime { get; set; } |
| | | public string ZuijinzhuizongtimeName { get; set; } |
| | | |
| | | public string Weixin { get; set; } |
| | | public string Shifoutianjiaweixin { get; set; } |
| | | } |
| | | |
| | | public class IntentionCustomerDTOSearch : SearchEntity |
| | |
| | | |
| | | public string YwjlYx { get; set; } |
| | | |
| | | public string Shifouweixin { get; set; } |
| | | |
| | | } |
| | | } |
| | |
| | | public string JyName { get; set; } |
| | | public string RecStatus { get; set; } |
| | | public string Creater { get; set; } |
| | | public string CreaterName { get; set; } |
| | | public DateTime Createtime { get; set; } |
| | | public string Modifier { get; set; } |
| | | public DateTime Modifytime { get; set; } |
| | |
| | | |
| | | public string Viscustomer { get; set; } |
| | | |
| | | public string Creater { get; set; } |
| | | |
| | | } |
| | | } |
| | |
| | | public string Fbyy { get; set; } |
| | | |
| | | public string Caigourenname { get; set; } |
| | | |
| | | public string Caigourennamecunzai { get; set; } |
| | | public string Caigourenaddress { get; set; } |
| | | public string Caigourencontact { get; set; } |
| | | public string Dailiname { get; set; } |
| | | public string Dailinamecunzai { get; set; } |
| | | public string Dailiaddress { get; set; } |
| | | public string Dailicontact { get; set; } |
| | | |
| | |
| | | public List<ProjectzhongbiaoDTO> Projectzhongbiaos { get; set; } |
| | | |
| | | public string[] ZhuanjiaList { get; set; } |
| | | |
| | | public decimal? Fencha { get; set; } |
| | | public int? Shuliang { get; set; } |
| | | } |
| | | |
| | | public class ProjectDTOSearch : SearchEntity |
| | |
| | | |
| | | public string Fencha { get; set; } |
| | | |
| | | public string Caigourenname { get; set; } |
| | | |
| | | public string Dailiname { get; set; } |
| | | |
| | | public string Shuliang { get; set; } |
| | | |
| | | } |
| | | } |
| | |
| | | |
| | | ResultEntity CheckAppea(HrSalaryAppeal model); |
| | | |
| | | HrSalaryAppeal GetAppeal(string id, string user); |
| | | HrSalaryAppeal GetAppeal(string id="", string user="",string salaryId = ""); |
| | | |
| | | ResultDataEntity<HrSalaryDTO> SearchByPagingFinish(HrSalaryDTOSearch searchEntity); |
| | | |
| | |
| | | ResultEntity WfAskLeave(string DanjuId, string step, string tongguojujue , string Userid, string Content, string title, string version); |
| | | |
| | | ResultEntity WfAskLeaveOff(string DanjuId, string step, string tongguojujue, string Userid, string Content, string title, string version); |
| | | |
| | | ResultEntity WfSalaryAppeal(string DanjuId, string step, string tongguojujue, string Userid, string Content, string title, string version); |
| | | } |
| | | } |
| | |
| | | public DateTime Createtime { get; set; } |
| | | public string Modifier { get; set; } |
| | | public DateTime Modifytime { get; set; } |
| | | public string Weixin { get; set; } |
| | | public string Shifoutianjiaweixin { get; set; } |
| | | } |
| | | } |
| | |
| | | public class HrSalaryAppeal |
| | | { |
| | | [Key] |
| | | public int id { get; set; } |
| | | public string id { get; set; } |
| | | |
| | | public string salary_id { get; set; } |
| | | |
| | | public int Year { get; set; } |
| | | |
| | | public int Month { get; set; } |
| | | |
| | | public string reason { get; set; } |
| | | |
| | |
| | | public string chk_result { get; set; } |
| | | |
| | | public string status { get; set; } |
| | | |
| | | public string createrName { get; set; } |
| | | |
| | | public string tittle { get; set; } |
| | | |
| | | public string shenpi_status { get; set; } |
| | | } |
| | | |
| | | |
| | | public class HrSalaryAppealDTO: HrSalaryAppeal |
| | | { |
| | | public string Step { get; set; } |
| | | |
| | | public string Tongguojujue { get; set; } |
| | | |
| | | public string Content { get; set; } |
| | | |
| | | } |
| | | } |
| | |
| | | public string Yixiang { get; set; } |
| | | public string Dianxiaozhuanyuan { get; set; } |
| | | public DateTime? Zuijinzhuizongtime { get; set; } |
| | | public string Weixin { get; set; } |
| | | public string Shifoutianjiaweixin { get; set; } |
| | | } |
| | | } |
| | |
| | | public string Name { get; set; } |
| | | public string Drhx { get; set; } |
| | | public string DrhxPrice { get; set; } |
| | | public decimal? DrhxDefen { get; set; } |
| | | public string Dshx { get; set; } |
| | | public string DshxPrice { get; set; } |
| | | public decimal? DshxDefen { get; set; } |
| | | public string Zhuanjia { get; set; } |
| | | public string Remark { get; set; } |
| | | public string RecStatus { get; set; } |
| | |
| | | public string Dailiname { get; set; } |
| | | public string Dailiaddress { get; set; } |
| | | public string Dailicontact { get; set; } |
| | | public decimal? DrhxDefen { get; set; } |
| | | public decimal? DshxDefen { get; set; } |
| | | public decimal? Fencha { get; set; } |
| | | public int? Shuliang { get; set; } |
| | | } |
| | | } |
| | |
| | | .HasColumnName("sheng") |
| | | .HasComment("ç"); |
| | | |
| | | entity.Property(e => e.Shifoutianjiaweixin) |
| | | .HasMaxLength(1) |
| | | .HasColumnName("shifoutianjiaweixin"); |
| | | |
| | | entity.Property(e => e.ShrAddress) |
| | | .HasMaxLength(500) |
| | | .HasColumnName("shr_address") |
| | |
| | | .HasMaxLength(500) |
| | | .HasColumnName("url") |
| | | .HasComment("ç½å"); |
| | | |
| | | entity.Property(e => e.Weixin) |
| | | .HasMaxLength(50) |
| | | .HasColumnName("weixin"); |
| | | |
| | | entity.Property(e => e.YwName) |
| | | .HasMaxLength(500) |
| | |
| | | .HasColumnName("sheng") |
| | | .HasComment("ç"); |
| | | |
| | | entity.Property(e => e.Shifoutianjiaweixin) |
| | | .HasMaxLength(1) |
| | | .HasColumnName("shifoutianjiaweixin"); |
| | | |
| | | entity.Property(e => e.ShrAddress) |
| | | .HasMaxLength(500) |
| | | .HasColumnName("shr_address") |
| | |
| | | .HasMaxLength(500) |
| | | .HasColumnName("url") |
| | | .HasComment("ç½å"); |
| | | |
| | | entity.Property(e => e.Weixin) |
| | | .HasMaxLength(50) |
| | | .HasColumnName("weixin"); |
| | | |
| | | entity.Property(e => e.Yixiang).HasMaxLength(50); |
| | | |
| | |
| | | .HasMaxLength(50) |
| | | .HasColumnName("userId"); |
| | | }); |
| | | |
| | | modelBuilder.Entity<Project>(entity => |
| | | { |
| | | entity.ToTable("Project"); |
| | |
| | | .HasMaxLength(500) |
| | | .HasColumnName("drhx"); |
| | | |
| | | entity.Property(e => e.DrhxPrice) |
| | | .HasMaxLength(500) |
| | | .HasColumnName("drhx_price"); |
| | | |
| | | entity.Property(e => e.DrhxDefen) |
| | | .HasColumnType("money") |
| | | .HasColumnName("drhx_defen"); |
| | | |
| | | entity.Property(e => e.DshxDefen) |
| | | .HasColumnType("money") |
| | | .HasColumnName("dshx_defen"); |
| | | entity.Property(e => e.DrhxPrice) |
| | | .HasMaxLength(500) |
| | | .HasColumnName("drhx_price"); |
| | | |
| | | entity.Property(e => e.Dshx) |
| | | .HasMaxLength(500) |
| | | .HasColumnName("dshx"); |
| | | |
| | | entity.Property(e => e.DshxDefen) |
| | | .HasColumnType("money") |
| | | .HasColumnName("dshx_defen"); |
| | | |
| | | entity.Property(e => e.DshxPrice) |
| | | .HasMaxLength(500) |
| | |
| | | .HasMaxLength(100) |
| | | .HasColumnName("feibiaocishu"); |
| | | |
| | | entity.Property(e => e.Fencha).HasColumnType("money"); |
| | | |
| | | entity.Property(e => e.Modifier) |
| | | .IsRequired() |
| | | .HasMaxLength(50) |
| | |
| | | updateproject.RecStatus = cooperatecustomCustomer.RecStatus; |
| | | updateproject.Modifier = cooperatecustomCustomer.Modifier; |
| | | updateproject.Modifytime = cooperatecustomCustomer.Modifytime; |
| | | updateproject.Weixin = cooperatecustomCustomer.Weixin; |
| | | |
| | | updateproject.Shifoutianjiaweixin = cooperatecustomCustomer.Shifoutianjiaweixin; |
| | | } |
| | | |
| | | _context.SaveChanges(); |
| | |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Sheng) || a.Sheng == searchEntity.Sheng.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.City) || a.City == searchEntity.City.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || a.AreaId == searchEntity.AreaId.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || (searchEntity.Shifouweixin == "A" && a.Weixin != null) || (searchEntity.Shifouweixin != "A" && a.Weixin == null) ) |
| | | |
| | | |
| | | select new CooperatecustomCustomerDTO |
| | | { |
| | |
| | | Modifier = a.Modifier, |
| | | Modifytime = a.Modifytime, |
| | | CreatetimeName = a.Createtime.ToString("yyyy-MM-dd"), |
| | | Weixin = a.Weixin, |
| | | Shifoutianjiaweixin = a.Shifoutianjiaweixin, |
| | | } |
| | | ).OrderByDescending(x => x.Modifytime).ToList(); |
| | | |
| | |
| | | temp.reason = model.reason; |
| | | temp.amount = model.amount; |
| | | temp.basis = model.basis; |
| | | temp.sub_time = DateTime.Now; |
| | | temp.shenpi_status = model.shenpi_status; |
| | | |
| | | |
| | | } |
| | | else |
| | | { |
| | | model.id = Guid.NewGuid().ToString(); |
| | | model.sub_time = DateTime.Now; |
| | | model.status = "A"; |
| | | _context.HrSalaryAppeal.Add(model); |
| | |
| | | /// <param name="id"></param> |
| | | /// <param name="user"></param> |
| | | /// <returns></returns> |
| | | public HrSalaryAppeal GetAppeal(string id,string user) |
| | | public HrSalaryAppeal GetAppeal(string id = "", string user = "", string salaryId = "") |
| | | { |
| | | HrSalaryAppeal hd = new HrSalaryAppeal(); |
| | | try |
| | | { |
| | | hd = _context.HrSalaryAppeal.Where(e => e.salary_id == id && e.sub_user == user).SingleOrDefault(); |
| | | if (!string.IsNullOrEmpty(salaryId)) |
| | | { |
| | | hd = _context.HrSalaryAppeal.Where(e => e.salary_id == salaryId && e.sub_user == user && e.status == "A").FirstOrDefault(); |
| | | } |
| | | else |
| | | { |
| | | hd = _context.HrSalaryAppeal.Where(e => e.id == id && e.status == "A").FirstOrDefault(); |
| | | } |
| | | |
| | | } |
| | | catch (Exception er) |
| | | { |
| | |
| | | updateproject.Dianxiaozhuanyuan = intentionCustomer.Dianxiaozhuanyuan; |
| | | updateproject.Zuijinzhuizongtime = intentionCustomer.Zuijinzhuizongtime; |
| | | |
| | | updateproject.Weixin = intentionCustomer.Weixin; |
| | | updateproject.Shifoutianjiaweixin = intentionCustomer.Shifoutianjiaweixin; |
| | | |
| | | } |
| | | |
| | | _context.SaveChanges(); |
| | |
| | | |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Yixiangtime) || (a.Yixiangtime >= Yixiangtimestart && a.Yixiangtime <= Yixiangtimeend)) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Yixiang) || ( a.Yixiang == searchEntity.Yixiang.Trim() && (a.Ywjl == null || a.Ywjl == searchEntity.YwjlYx) )) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || (searchEntity.Shifouweixin == "A" && a.Weixin != null) || (searchEntity.Shifouweixin != "A" && a.Weixin == null)) |
| | | select new IntentionCustomerDTO |
| | | { |
| | | Id = a.Id, |
| | |
| | | ShrTel = a.ShrTel, |
| | | ShrAddress = a.ShrAddress, |
| | | Remark = a.Remark, |
| | | |
| | | Weixin = a.Weixin, |
| | | Shifoutianjiaweixin = a.Shifoutianjiaweixin, |
| | | RecStatus = a.RecStatus, |
| | | Modifier = a.Modifier, |
| | | Modifytime = a.Modifytime, |
| | |
| | | join h in _context.Areas on zz.City equals h.CodeId |
| | | join i in _context.Areas on zz.AreaId equals i.CodeId |
| | | |
| | | join zzz in _context.PltUsers.Where(x => x.RecStatus == "A") |
| | | on a.Creater equals zzz.Id |
| | | into zsssss |
| | | from zzzzz in zsssss.DefaultIfEmpty() |
| | | |
| | | |
| | | |
| | | |
| | |
| | | && (string.IsNullOrWhiteSpace(searchEntity.City) || zz.City == searchEntity.City.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || zz.AreaId == searchEntity.AreaId.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Viscustomer) || a.Viscustomer == searchEntity.Viscustomer.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Creater) || zz.Creater == searchEntity.Creater.Trim()) |
| | | select new IntentionVisitDTO |
| | | { |
| | | Id = a.Id, |
| | |
| | | Talk = a.Talk, |
| | | Khfk = a.Khfk, |
| | | Yx = a.Yx, |
| | | CreaterName = zzzzz.UserName, |
| | | |
| | | Jy = a.Jy, |
| | | Creater = a.Creater, |
| | |
| | | updateproject.Dailiname = project.Dailiname; |
| | | updateproject.Dailicontact = project.Dailicontact; |
| | | updateproject.Dailiaddress = project.Dailiaddress; |
| | | updateproject.Fencha = project.Fencha; |
| | | updateproject.Shuliang = updateproject.Shuliang; |
| | | |
| | | } |
| | | |
| | | //å表 |
| | |
| | | List<ProjectDTO> list = new List<ProjectDTO>(); |
| | | //çé |
| | | StringBuilder sql = new StringBuilder(); |
| | | sql.Append("SELECT distinct a.[Id],a.[start_time],a.[drhx_defen],a.[dshx_defen] ,b.[name] +'-'+c.[name]+'-'+d.[name] Sheng ,a.city ,a.[area_id],a.cgfs, a.[name] ,a.[number],a.creater,a.createtime,a.modifier,a.modifytime ,a.[drhx],a.[drhx_price],a.[dshx],a.[dshx_price],a.[remark],a.[rec_status] ,a.[question] ,a.[zhongbiaocishu],a.[feibiaocishu],a.[zhongbiaojine],a.[Fblx],a.[Fbyy] , a.[zhuanjia] , a.[caigourenname], a.[caigourenaddress], a.[caigourencontact], a.[dailiname], a.[dailiaddress], a.[dailicontact] ,toubiaocishu = stuff((select 'ã'+ f.[names] from [Projectzhongbiao] f where f.[ProjectId] = a.[Id] for xml path('')), 1,1, '') "); //zhuanjia = stuff((select ','+name from [Zhuanjia] f where CHARINDEX(f.id,a.[zhuanjia]) >0 for xml path('')), 1,1, '') |
| | | sql.Append("SELECT distinct a.[Id],a.[start_time],a.[drhx_defen],a.[dshx_defen] ,b.[name] +'-'+c.[name]+'-'+d.[name] Sheng ,a.city ,a.[area_id],a.cgfs, a.[name] ,a.[number],a.creater,a.createtime,a.modifier,a.modifytime ,a.[drhx],a.[drhx_price],a.[dshx],a.[dshx_price],a.[Fencha],a.[Shuliang],a.[remark],a.[rec_status] ,a.[question] ,a.[zhongbiaocishu],a.[feibiaocishu],a.[zhongbiaojine],a.[Fblx],a.[Fbyy] , a.[zhuanjia] , a.[caigourenname], a.[caigourenaddress], a.[caigourencontact], a.[dailiname], a.[dailiaddress], a.[dailicontact] ,toubiaocishu = stuff((select 'ã'+ f.[names] from [Projectzhongbiao] f where f.[ProjectId] = a.[Id] for xml path('')), 1,1, '') "); //zhuanjia = stuff((select ','+name from [Zhuanjia] f where CHARINDEX(f.id,a.[zhuanjia]) >0 for xml path('')), 1,1, '') |
| | | sql.Append("FROM [Project] a "); |
| | | sql.Append("left join [Area] b on a.[sheng] = b.[codeID] "); |
| | | sql.Append("left join [Area] c on a.[city] = c.[codeID] "); |
| | |
| | | sql.Append(" and exists ( select b.[ProjectId] from [Projectzhongbiao] b where a.[Id]=b.[ProjectId] and (b.[defen]-a.[drhx_defen]) <= " + aaaa + " ) "); |
| | | } |
| | | } |
| | | |
| | | |
| | | if (!string.IsNullOrWhiteSpace(searchEntity.Shuliang)) |
| | | { |
| | | decimal aaaa = 0; |
| | | decimal.TryParse(searchEntity.Shuliang, out aaaa); |
| | | if (aaaa > 0) |
| | | { |
| | | sql.Append(" and exists ( select * from( select ( isnull((select COUNT(*) ProjectIdshuliang from [Projectzhongbiao] b where a.[Id]=b.[ProjectId] group by b.ProjectId) ,0)+ "); |
| | | |
| | | sql.Append(" isnull( (select COUNT(*) ProjectIdshuliang from [Projectreason] b where a.[Id]=b.[ProjectId] group by b.ProjectId),0)+ "); |
| | | sql.Append(" isnull( (select COUNT(*) ProjectIdshuliang from [Projectyouxiao] b where a.[Id]=b.[ProjectId] group by b.ProjectId),0)+ "); |
| | | sql.Append(" isnull( ( select COUNT(*) ProjectIdshuliang from [Project] b where a.[Id]=b.[Id] and b.drhx is not null ),0)+ "); |
| | | sql.Append(" isnull( (select COUNT(*) ProjectIdshuliang from [Project] b where a.[Id]=b.[Id] and b.dshx is not null ),0) "); |
| | | sql.Append(" ) as sum_count ) a where a.sum_count <= " + aaaa + ""); |
| | | sql.Append(" ) "); |
| | | } |
| | | } |
| | | |
| | | |
| | | if (!string.IsNullOrWhiteSpace(searchEntity.Reasonname)) |
| | | { |
| | |
| | | |
| | | } |
| | | |
| | | if (!string.IsNullOrWhiteSpace(searchEntity.Caigourenname)) |
| | | { |
| | | sql.Append("and a.[caigourenname] like '%" + searchEntity.Caigourenname.Trim().Replace("'", "''") + "%'"); |
| | | |
| | | } |
| | | |
| | | if (!string.IsNullOrWhiteSpace(searchEntity.Dailiname)) |
| | | { |
| | | sql.Append("and a.[dailiname] like '%" + searchEntity.Dailiname.Trim().Replace("'", "''") + "%'"); |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | |
| | | |
| | | return result; |
| | | } |
| | | |
| | | public ResultEntity WfSalaryAppeal(string DanjuId, string step, string tongguojujue, string Userid, string Content, string title, string version) |
| | | { |
| | | |
| | | ResultEntity result = new ResultEntity(); |
| | | result.Result = true; |
| | | |
| | | |
| | | WfRunProcessDTO wfRunProcessDTO = this.GetList(DanjuId, "03").FirstOrDefault(); |
| | | if (wfRunProcessDTO != null) |
| | | { |
| | | version = wfRunProcessDTO.Version; |
| | | } |
| | | |
| | | |
| | | if (version == "v1") |
| | | { |
| | | if (step == "æäº¤") |
| | | { |
| | | //æ´æ°æµç¨å®ä¾ |
| | | // WfRunProcessDTO wfRunProcessDTO = this.GetList(DanjuId, "03").FirstOrDefault(); |
| | | if (wfRunProcessDTO == null) |
| | | { |
| | | //æå
¥æµç¨å®ä¾ |
| | | wfRunProcessDTO = new WfRunProcessDTO(); |
| | | //wfRunProcessDTO.Applyno = |
| | | wfRunProcessDTO.Applytime = DateTime.Now; |
| | | wfRunProcessDTO.Applytiye = "03"; |
| | | wfRunProcessDTO.DanjuId = DanjuId; |
| | | wfRunProcessDTO.Content = title; |
| | | wfRunProcessDTO.Step = "人äºå®¡æ¹"; |
| | | wfRunProcessDTO.ShenpiStatus = "D"; |
| | | wfRunProcessDTO.Version = version; |
| | | wfRunProcessDTO.RecStatus = "A"; |
| | | wfRunProcessDTO.Creater = Userid; |
| | | wfRunProcessDTO.Createtime = DateTime.Now; |
| | | wfRunProcessDTO.Modifier = Userid; |
| | | wfRunProcessDTO.Modifytime = DateTime.Now; |
| | | wfRunProcessDTO.Deelurl = "/SalaryCheck/Appeal?id=" + DanjuId; |
| | | result = this.save(wfRunProcessDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | //æ¥è¯¢å¤ç人 |
| | | var hrPositions = _context.PltRoles.Where(x => x.RecStatus == "A" && x.RoleName == "人äº").FirstOrDefault(); |
| | | if (hrPositions == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°èä½"; |
| | | return result; |
| | | } |
| | | var pltUsers = (from a in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A") |
| | | join b in _context.PltUserRoles.Where(x => x.RecStatus == "A" && x.RoleId == hrPositions.Id) on a.Id equals b.UserId |
| | | select a |
| | | ).ToList(); |
| | | |
| | | if (pltUsers == null || pltUsers.Count == 0) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°å¤ç人"; |
| | | return result; |
| | | } |
| | | foreach (var pltUser in pltUsers) |
| | | { |
| | | //æå
¥å¾
å |
| | | WfNeeddeelDTO wfNeeddeelDTO = new WfNeeddeelDTO(); |
| | | wfNeeddeelDTO.RunProcessId = wfRunProcessDTO.Id; |
| | | wfNeeddeelDTO.SendUserId = Userid; |
| | | wfNeeddeelDTO.DeelUserId = pltUser.Id; |
| | | wfNeeddeelDTO.Sendtime = DateTime.Now; |
| | | wfNeeddeelDTO.Resivetime = DateTime.Now; |
| | | wfNeeddeelDTO.Step = "人äºå®¡æ¹"; |
| | | wfNeeddeelDTO.NeeddeelType = "1"; |
| | | wfNeeddeelDTO.ChuliStatus = "0"; |
| | | wfNeeddeelDTO.Deelurl = "/SalaryCheck/Appeal?id=" + DanjuId; |
| | | wfNeeddeelDTO.Content = ""; |
| | | wfNeeddeelDTO.Sort = 1; |
| | | wfNeeddeelDTO.RecStatus = "A"; |
| | | wfNeeddeelDTO.Creater = Userid; |
| | | wfNeeddeelDTO.Createtime = DateTime.Now; |
| | | wfNeeddeelDTO.Modifier = Userid; |
| | | wfNeeddeelDTO.Modifytime = wfNeeddeelDTO.Createtime; |
| | | result = _wfNeeddeelService.save(wfNeeddeelDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | } |
| | | |
| | | //æå
¥æ°çå·²å |
| | | WfHistory wfHistoryDTO1 = new WfHistory(); |
| | | wfHistoryDTO1.Id = Guid.NewGuid().ToString(); |
| | | wfHistoryDTO1.RunProcessId = wfRunProcessDTO.Id; |
| | | wfHistoryDTO1.SendUserId = Userid; |
| | | wfHistoryDTO1.DeelUserId = wfRunProcessDTO.Creater; |
| | | wfHistoryDTO1.Sendtime = DateTime.Now; |
| | | wfHistoryDTO1.Resivetime = DateTime.Now; |
| | | wfHistoryDTO1.Step = "æäº¤"; |
| | | wfHistoryDTO1.NeeddeelType = "1"; |
| | | wfHistoryDTO1.ChuliStatus = "2"; |
| | | wfHistoryDTO1.Deelurl = "/SalaryCheck/Appeal?id=" + DanjuId; |
| | | wfHistoryDTO1.Content = ""; |
| | | wfHistoryDTO1.Sort = 1; |
| | | wfHistoryDTO1.RecStatus = "A"; |
| | | wfHistoryDTO1.Creater = Userid; |
| | | wfHistoryDTO1.Createtime = DateTime.Now; |
| | | wfHistoryDTO1.Modifier = Userid; |
| | | wfHistoryDTO1.Modifytime = wfHistoryDTO1.Createtime; |
| | | _context.WfHistories.Add(wfHistoryDTO1); |
| | | _context.SaveChanges(); |
| | | } |
| | | else |
| | | { |
| | | wfRunProcessDTO.Step = "人äºå®¡æ¹"; |
| | | wfRunProcessDTO.Modifier = Userid; |
| | | wfRunProcessDTO.Modifytime = DateTime.Now; |
| | | result = this.save(wfRunProcessDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | |
| | | //æ´æ°å¾
å |
| | | List<WfNeeddeelDTO> wfNeeddeelDTOs = _wfNeeddeelService.GetList(wfRunProcessDTO.Id, "æäº¤"); |
| | | var wfHistoryDTOs = _mapper.Map<List<WfHistoryDTO>>(wfNeeddeelDTOs); |
| | | |
| | | var wfHistoryDTO = wfHistoryDTOs.Where(x => x.DeelUserId == Userid).FirstOrDefault(); |
| | | if (wfHistoryDTO == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°ä»£å"; |
| | | return result; |
| | | } |
| | | wfHistoryDTO.Content = Content; |
| | | wfHistoryDTO.ChuliStatus = "2"; |
| | | wfHistoryDTO.Modifier = Userid; |
| | | wfHistoryDTO.Modifytime = DateTime.Now; |
| | | var wfHistories = _mapper.Map<List<WfHistory>>(wfHistoryDTOs); |
| | | foreach (var wfHistory in wfHistories) |
| | | { |
| | | _context.WfHistories.Add(wfHistory); |
| | | } |
| | | var wfNeeddeels = _mapper.Map<List<WfNeeddeel>>(wfNeeddeelDTOs); |
| | | foreach (var wfNeeddeel in wfNeeddeels) |
| | | { |
| | | //_wfNeeddeelService.ModifyStatus(wfNeeddeel.Id, Userid); |
| | | _context.WfNeeddeels.Remove(wfNeeddeel); |
| | | } |
| | | _context.SaveChanges(); |
| | | |
| | | //æ¥è¯¢å¤ç人 |
| | | var hrPositions = _context.PltRoles.Where(x => x.RecStatus == "A" && x.RoleName == "人äº").FirstOrDefault(); |
| | | if (hrPositions == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°èä½"; |
| | | return result; |
| | | } |
| | | var pltUsers = (from a in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A") |
| | | join b in _context.PltUserRoles.Where(x => x.RecStatus == "A" && x.RoleId == hrPositions.Id) on a.Id equals b.UserId |
| | | select a |
| | | ).ToList(); |
| | | |
| | | if (pltUsers == null || pltUsers.Count == 0) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°å¤ç人"; |
| | | return result; |
| | | } |
| | | |
| | | foreach (var pltUser in pltUsers) |
| | | { |
| | | //æå
¥æ°çå¾
å |
| | | WfNeeddeelDTO wfNeeddeelDTO = new WfNeeddeelDTO(); |
| | | wfNeeddeelDTO.RunProcessId = wfRunProcessDTO.Id; |
| | | wfNeeddeelDTO.SendUserId = Userid; |
| | | wfNeeddeelDTO.DeelUserId = pltUser.Id; |
| | | wfNeeddeelDTO.Sendtime = DateTime.Now; |
| | | wfNeeddeelDTO.Resivetime = DateTime.Now; |
| | | wfNeeddeelDTO.Step = "人äºå®¡æ¹"; |
| | | wfNeeddeelDTO.NeeddeelType = "1"; |
| | | wfNeeddeelDTO.ChuliStatus = "0"; |
| | | wfNeeddeelDTO.Deelurl = "/SalaryCheck/Appeal?id=" + DanjuId; |
| | | wfNeeddeelDTO.Content = ""; |
| | | wfNeeddeelDTO.Sort = 2; |
| | | wfNeeddeelDTO.RecStatus = "A"; |
| | | wfNeeddeelDTO.Creater = Userid; |
| | | wfNeeddeelDTO.Createtime = DateTime.Now; |
| | | wfNeeddeelDTO.Modifier = Userid; |
| | | wfNeeddeelDTO.Modifytime = wfNeeddeelDTO.Createtime; |
| | | result = _wfNeeddeelService.save(wfNeeddeelDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | if (step == "人äºå®¡æ¹") |
| | | { |
| | | //æ´æ°æµç¨å®ä¾ |
| | | //WfRunProcessDTO wfRunProcessDTO = this.GetList(DanjuId, "03").FirstOrDefault(); |
| | | if (wfRunProcessDTO == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°æµç¨å®ä¾"; |
| | | return result; |
| | | } |
| | | if (wfRunProcessDTO.Step != "人äºå®¡æ¹") |
| | | { |
| | | result.Result = false; |
| | | result.Message = "å½åæ¥éª¤å·²ç»å¤ç"; |
| | | return result; |
| | | } |
| | | |
| | | if (tongguojujue == "A") |
| | | { |
| | | wfRunProcessDTO.Step = "æ»ç»ç审æ¹"; |
| | | wfRunProcessDTO.Modifier = Userid; |
| | | wfRunProcessDTO.Modifytime = DateTime.Now; |
| | | result = this.save(wfRunProcessDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | |
| | | //æ´æ°å¾
å |
| | | List<WfNeeddeelDTO> wfNeeddeelDTOs = _wfNeeddeelService.GetList(wfRunProcessDTO.Id, "人äºå®¡æ¹"); |
| | | |
| | | |
| | | |
| | | var wfHistoryDTOs = _mapper.Map<List<WfHistoryDTO>>(wfNeeddeelDTOs); |
| | | |
| | | var wfHistoryDTO = wfHistoryDTOs.Where(x => x.DeelUserId == Userid).FirstOrDefault(); |
| | | if (wfHistoryDTO == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°ä»£å"; |
| | | return result; |
| | | } |
| | | |
| | | wfHistoryDTO.Content = Content; |
| | | wfHistoryDTO.ChuliStatus = "2"; |
| | | wfHistoryDTO.Modifier = Userid; |
| | | wfHistoryDTO.Modifytime = DateTime.Now; |
| | | |
| | | |
| | | var wfHistories = _mapper.Map<List<WfHistory>>(wfHistoryDTOs); |
| | | foreach (var wfHistory in wfHistories) |
| | | { |
| | | _context.WfHistories.Add(wfHistory); |
| | | } |
| | | var wfNeeddeels = _mapper.Map<List<WfNeeddeel>>(wfNeeddeelDTOs); |
| | | foreach (var wfNeeddeel in wfNeeddeels) |
| | | { |
| | | //_wfNeeddeelService.ModifyStatus(wfNeeddeel.Id, Userid); |
| | | _context.WfNeeddeels.Remove(wfNeeddeel); |
| | | } |
| | | _context.SaveChanges(); |
| | | |
| | | //æ¥è¯¢å¤ç人 |
| | | var hrPositions = _context.PltRoles.Where(x => x.RecStatus == "A" && x.RoleName == "æ»ç»ç").FirstOrDefault(); |
| | | if (hrPositions == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°èä½"; |
| | | return result; |
| | | } |
| | | var pltUsers = (from a in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A") |
| | | join b in _context.PltUserRoles.Where(x => x.RecStatus == "A" && x.RoleId == hrPositions.Id) on a.Id equals b.UserId |
| | | select a |
| | | ).ToList(); |
| | | |
| | | if (pltUsers == null || pltUsers.Count == 0) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°å¤ç人"; |
| | | return result; |
| | | } |
| | | |
| | | foreach (var pltUser in pltUsers) |
| | | { |
| | | //æå
¥æ°çå¾
å |
| | | WfNeeddeelDTO wfNeeddeelDTO = new WfNeeddeelDTO(); |
| | | wfNeeddeelDTO.RunProcessId = wfRunProcessDTO.Id; |
| | | wfNeeddeelDTO.SendUserId = Userid; |
| | | wfNeeddeelDTO.DeelUserId = pltUser.Id; |
| | | wfNeeddeelDTO.Sendtime = DateTime.Now; |
| | | wfNeeddeelDTO.Resivetime = DateTime.Now; |
| | | wfNeeddeelDTO.Step = "æ»ç»ç审æ¹"; |
| | | wfNeeddeelDTO.NeeddeelType = "1"; |
| | | wfNeeddeelDTO.ChuliStatus = "0"; |
| | | wfNeeddeelDTO.Deelurl = "/SalaryCheck/Appeal?id=" + DanjuId; |
| | | wfNeeddeelDTO.Content = ""; |
| | | wfNeeddeelDTO.Sort = 3; |
| | | wfNeeddeelDTO.RecStatus = "A"; |
| | | wfNeeddeelDTO.Creater = Userid; |
| | | wfNeeddeelDTO.Createtime = DateTime.Now; |
| | | wfNeeddeelDTO.Modifier = Userid; |
| | | wfNeeddeelDTO.Modifytime = wfNeeddeelDTO.Createtime; |
| | | result = _wfNeeddeelService.save(wfNeeddeelDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | wfRunProcessDTO.Step = "æäº¤"; |
| | | wfRunProcessDTO.Modifier = Userid; |
| | | wfRunProcessDTO.Modifytime = DateTime.Now; |
| | | result = this.save(wfRunProcessDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | |
| | | //æ´æ°å¾
å |
| | | List<WfNeeddeelDTO> wfNeeddeelDTOs = _wfNeeddeelService.GetList(wfRunProcessDTO.Id, "人äºå®¡æ¹"); |
| | | var wfHistoryDTOs = _mapper.Map<List<WfHistoryDTO>>(wfNeeddeelDTOs); |
| | | |
| | | var wfHistoryDTO = wfHistoryDTOs.Where(x => x.DeelUserId == Userid).FirstOrDefault(); |
| | | if (wfHistoryDTO == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°ä»£å"; |
| | | return result; |
| | | } |
| | | wfHistoryDTO.Content = Content; |
| | | wfHistoryDTO.ChuliStatus = "1"; |
| | | wfHistoryDTO.Modifier = Userid; |
| | | wfHistoryDTO.Modifytime = DateTime.Now; |
| | | var wfHistories = _mapper.Map<List<WfHistory>>(wfHistoryDTOs); |
| | | foreach (var wfHistory in wfHistories) |
| | | { |
| | | _context.WfHistories.Add(wfHistory); |
| | | } |
| | | var wfNeeddeels = _mapper.Map<List<WfNeeddeel>>(wfNeeddeelDTOs); |
| | | foreach (var wfNeeddeel in wfNeeddeels) |
| | | { |
| | | //_wfNeeddeelService.ModifyStatus(wfNeeddeel.Id, Userid); |
| | | _context.WfNeeddeels.Remove(wfNeeddeel); |
| | | } |
| | | _context.SaveChanges(); |
| | | |
| | | |
| | | //æå
¥æ°çå¾
å |
| | | WfNeeddeelDTO wfNeeddeelDTO = new WfNeeddeelDTO(); |
| | | wfNeeddeelDTO.RunProcessId = wfRunProcessDTO.Id; |
| | | wfNeeddeelDTO.SendUserId = Userid; |
| | | wfNeeddeelDTO.DeelUserId = wfRunProcessDTO.Creater; |
| | | wfNeeddeelDTO.Sendtime = DateTime.Now; |
| | | wfNeeddeelDTO.Resivetime = DateTime.Now; |
| | | wfNeeddeelDTO.Step = "æäº¤"; |
| | | wfNeeddeelDTO.NeeddeelType = "1"; |
| | | wfNeeddeelDTO.ChuliStatus = "0"; |
| | | wfNeeddeelDTO.Deelurl = "/SalaryCheck/Appeal?id=" + DanjuId; |
| | | wfNeeddeelDTO.Content = ""; |
| | | wfNeeddeelDTO.Sort = 1; |
| | | wfNeeddeelDTO.RecStatus = "A"; |
| | | wfNeeddeelDTO.Creater = Userid; |
| | | wfNeeddeelDTO.Createtime = DateTime.Now; |
| | | wfNeeddeelDTO.Modifier = Userid; |
| | | wfNeeddeelDTO.Modifytime = wfNeeddeelDTO.Createtime; |
| | | result = _wfNeeddeelService.save(wfNeeddeelDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | |
| | | if (step == "æ»ç»ç审æ¹") |
| | | { |
| | | //æ´æ°æµç¨å®ä¾ |
| | | //WfRunProcessDTO wfRunProcessDTO = this.GetList(DanjuId, "03").FirstOrDefault(); |
| | | if (wfRunProcessDTO == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°æµç¨å®ä¾"; |
| | | return result; |
| | | } |
| | | if (wfRunProcessDTO.Step != "æ»ç»ç审æ¹") |
| | | { |
| | | result.Result = false; |
| | | result.Message = "å½åæ¥éª¤å·²ç»å¤ç"; |
| | | return result; |
| | | } |
| | | if (tongguojujue == "A") |
| | | { |
| | | |
| | | wfRunProcessDTO.Step = "å®ç»"; |
| | | wfRunProcessDTO.ShenpiStatus = "A"; |
| | | wfRunProcessDTO.Modifier = Userid; |
| | | wfRunProcessDTO.Modifytime = DateTime.Now; |
| | | result = this.save(wfRunProcessDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | //æ´æ°åæ® |
| | | var salaryAppeal = _context.HrSalaryAppeal.Find(DanjuId); |
| | | if (wfRunProcessDTO == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°åæ®"; |
| | | return result; |
| | | } |
| | | salaryAppeal.shenpi_status = "A"; |
| | | _context.SaveChanges(); |
| | | |
| | | List<WfNeeddeelDTO> wfNeeddeelDTOs = _wfNeeddeelService.GetList(wfRunProcessDTO.Id, "æ»ç»ç审æ¹"); |
| | | |
| | | var wfHistoryDTOs = _mapper.Map<List<WfHistoryDTO>>(wfNeeddeelDTOs); |
| | | |
| | | var wfHistoryDTO = wfHistoryDTOs.Where(x => x.DeelUserId == Userid).FirstOrDefault(); |
| | | if (wfHistoryDTO == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°ä»£å"; |
| | | return result; |
| | | } |
| | | wfHistoryDTO.Content = Content; |
| | | wfHistoryDTO.ChuliStatus = "2"; |
| | | wfHistoryDTO.Modifier = Userid; |
| | | wfHistoryDTO.Modifytime = DateTime.Now; |
| | | var wfHistories = _mapper.Map<List<WfHistory>>(wfHistoryDTOs); |
| | | foreach (var wfHistory in wfHistories) |
| | | { |
| | | _context.WfHistories.Add(wfHistory); |
| | | } |
| | | var wfNeeddeels = _mapper.Map<List<WfNeeddeel>>(wfNeeddeelDTOs); |
| | | foreach (var wfNeeddeel in wfNeeddeels) |
| | | { |
| | | // _wfNeeddeelService.ModifyStatus(wfNeeddeel.Id, Userid); |
| | | _context.WfNeeddeels.Remove(wfNeeddeel); |
| | | } |
| | | _context.SaveChanges(); |
| | | } |
| | | else |
| | | { |
| | | wfRunProcessDTO.Step = "æäº¤"; |
| | | wfRunProcessDTO.Modifier = Userid; |
| | | wfRunProcessDTO.Modifytime = DateTime.Now; |
| | | result = this.save(wfRunProcessDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | |
| | | //æ´æ°å¾
å |
| | | List<WfNeeddeelDTO> wfNeeddeelDTOs = _wfNeeddeelService.GetList(wfRunProcessDTO.Id, "æ»ç»ç审æ¹"); |
| | | var wfHistoryDTOs = _mapper.Map<List<WfHistoryDTO>>(wfNeeddeelDTOs); |
| | | |
| | | var wfHistoryDTO = wfHistoryDTOs.Where(x => x.DeelUserId == Userid).FirstOrDefault(); |
| | | if (wfHistoryDTO == null) |
| | | { |
| | | result.Result = false; |
| | | result.Message = "æªæ¾å°ä»£å"; |
| | | return result; |
| | | } |
| | | wfHistoryDTO.Content = Content; |
| | | wfHistoryDTO.ChuliStatus = "1"; |
| | | wfHistoryDTO.Modifier = Userid; |
| | | wfHistoryDTO.Modifytime = DateTime.Now; |
| | | var wfHistories = _mapper.Map<List<WfHistory>>(wfHistoryDTOs); |
| | | foreach (var wfHistory in wfHistories) |
| | | { |
| | | _context.WfHistories.Add(wfHistory); |
| | | } |
| | | var wfNeeddeels = _mapper.Map<List<WfNeeddeel>>(wfNeeddeelDTOs); |
| | | foreach (var wfNeeddeel in wfNeeddeels) |
| | | { |
| | | //_wfNeeddeelService.ModifyStatus(wfNeeddeel.Id, Userid); |
| | | _context.WfNeeddeels.Remove(wfNeeddeel); |
| | | } |
| | | _context.SaveChanges(); |
| | | |
| | | |
| | | //æå
¥æ°çå¾
å |
| | | WfNeeddeelDTO wfNeeddeelDTO = new WfNeeddeelDTO(); |
| | | wfNeeddeelDTO.RunProcessId = wfRunProcessDTO.Id; |
| | | wfNeeddeelDTO.SendUserId = Userid; |
| | | wfNeeddeelDTO.DeelUserId = wfRunProcessDTO.Creater; |
| | | wfNeeddeelDTO.Sendtime = DateTime.Now; |
| | | wfNeeddeelDTO.Resivetime = DateTime.Now; |
| | | wfNeeddeelDTO.Step = "æäº¤"; |
| | | wfNeeddeelDTO.NeeddeelType = "1"; |
| | | wfNeeddeelDTO.ChuliStatus = "0"; |
| | | wfNeeddeelDTO.Deelurl = "/SalaryCheck/Appeal?id=" + DanjuId; |
| | | wfNeeddeelDTO.Content = ""; |
| | | wfNeeddeelDTO.Sort = 1; |
| | | wfNeeddeelDTO.RecStatus = "A"; |
| | | wfNeeddeelDTO.Creater = Userid; |
| | | wfNeeddeelDTO.Createtime = DateTime.Now; |
| | | wfNeeddeelDTO.Modifier = Userid; |
| | | wfNeeddeelDTO.Modifytime = wfNeeddeelDTO.Createtime; |
| | | result = _wfNeeddeelService.save(wfNeeddeelDTO); |
| | | if (result.Result == false) |
| | | { |
| | | return result; |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | return result; |
| | | } |
| | | } |
| | | } |
| | |
| | | ViewBag.khlx = _liaotianService.GetSYScode("CooperatecustomCustomer", "khlx").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList(); |
| | | ViewBag.khly = _liaotianService.GetSYScode("CooperatecustomCustomer", "khly").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList(); |
| | | ViewBag.hyfl = _liaotianService.GetSYScode("CooperatecustomCustomer", "hyfl").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList(); |
| | | |
| | | ViewBag.shifou = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList(); |
| | | ViewBag.users = _userService.GetList().Where(x => x.IsYwjl == "A").Select(x => new { code = x.Id, label = x.UserName }).ToList(); |
| | | |
| | | |
| | |
| | | var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); |
| | | ViewData["curentuser"] = curentuser; |
| | | data.RecStatus = "A"; |
| | | if (string.IsNullOrEmpty(data.Shifoutianjiaweixin)) |
| | | { |
| | | data.Shifoutianjiaweixin = "D"; |
| | | } |
| | | if (String.IsNullOrEmpty(data.Id)) |
| | | { |
| | | data.Creater = curentuser.Id; |
| | |
| | | |
| | | ViewBag.Creater = _userService.GetList().Select(x => new { code = x.Id, label = x.UserName }).ToList(); |
| | | |
| | | |
| | | ViewBag.shifou = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList(); |
| | | |
| | | |
| | | ViewBag.ShengDropDown = _projectService.Getsheng().Select(x => new { code = x.CodeId, label = x.Name }).ToList(); |
| | |
| | | var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); |
| | | ViewData["curentuser"] = curentuser; |
| | | data.RecStatus = "A"; |
| | | if (string.IsNullOrEmpty(data.Shifoutianjiaweixin)) |
| | | { |
| | | data.Shifoutianjiaweixin = "D"; |
| | | } |
| | | if (String.IsNullOrEmpty(data.Id)) |
| | | { |
| | | data.Creater = curentuser.Id; |
| | |
| | | |
| | | ViewBag.users = _userService.GetList().Where(x => x.IsYwjl == "A").Select(x => new { code = x.Id, label = x.UserName }).ToList(); |
| | | |
| | | ViewBag.creater = _userService.GetList().Select(x => new { code = x.Id, label = x.UserName }).ToList(); |
| | | |
| | | ViewBag.Viscustomer = Viscustomer; |
| | | ViewBag.IsYwjl = IsYwjl; |
| | | |
| | |
| | | { |
| | | dto.Viscustomer = Viscustomer; |
| | | } |
| | | |
| | | dto.VisType = "01"; |
| | | dto.Jtype = "02"; |
| | | dto.Jdr = "02"; |
| | | dto.Talk = "ä»ç»å
¬å¸ä¸å¡å
容å产åã"; |
| | | dto.Yx = "03"; |
| | | dto.Jy = "02"; |
| | | |
| | | } |
| | | |
| | | |
| | |
| | | List<FiServiceDTO> fiServiceDTOs = _fiServiceService.GetList(); |
| | | List<FiMemberDTO> fiMemberDTOs = _fiMemberService.GetList(); |
| | | List<FiBookDTO> fiBookDTOs = _fiBookService.GetList(); |
| | | foreach (var fiBookDTO in fiBookDTOs) |
| | | { |
| | | if (fiBookDTO.Chubantime.HasValue) |
| | | { |
| | | fiBookDTO.ChubantimeName = fiBookDTO.Chubantime.Value.ToString("yyyy-MM-dd"); |
| | | } |
| | | |
| | | } |
| | | |
| | | ServiceChargeDTO serviceChargeDTO = new ServiceChargeDTO(); |
| | | decimal? Dianhuazixun = fiServiceDTOs.Where(x => x.ServiceType == "çµè¯å¨è¯¢").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Dianhuazixun = Dianhuazixun.HasValue? Dianhuazixun.Value.ToString("F2"): ""; |
| | |
| | | decimal? Xuqiulunzheng5 = fiServiceDTOs.Where(x => x.ServiceType == "éæ±è®ºè¯" && x.ServiceTypeTwo == "1000ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Xuqiulunzheng5 = Xuqiulunzheng5.HasValue ? Xuqiulunzheng5.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Zhudaotoubiaowenjian1 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Zhudaotoubiaowenjian1 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Zhudaotoubiaowenjian1 = Zhudaotoubiaowenjian1.HasValue ? Zhudaotoubiaowenjian1.Value.ToString("F2") : ""; |
| | | decimal? Zhudaotoubiaowenjian2 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Zhudaotoubiaowenjian2 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Zhudaotoubiaowenjian2 = Zhudaotoubiaowenjian2.HasValue ? Zhudaotoubiaowenjian2.Value.ToString("F2") : ""; |
| | | decimal? Zhudaotoubiaowenjian3 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Zhudaotoubiaowenjian3 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Zhudaotoubiaowenjian3 = Zhudaotoubiaowenjian3.HasValue ? Zhudaotoubiaowenjian3.Value.ToString("F2") : ""; |
| | | decimal? Zhudaotoubiaowenjian4 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Zhudaotoubiaowenjian4 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Zhudaotoubiaowenjian4 = Zhudaotoubiaowenjian4.HasValue ? Zhudaotoubiaowenjian4.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Daishuzhiyi1 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Daishuzhiyi1 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daishuzhiyi1 = Daishuzhiyi1.HasValue ? Daishuzhiyi1.Value.ToString("F2") : ""; |
| | | decimal? Daishuzhiyi2 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Daishuzhiyi2 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daishuzhiyi2 = Daishuzhiyi2.HasValue ? Daishuzhiyi2.Value.ToString("F2") : ""; |
| | | decimal? Daishuzhiyi3 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Daishuzhiyi3 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daishuzhiyi3 = Daishuzhiyi3.HasValue ? Daishuzhiyi3.Value.ToString("F2") : ""; |
| | | decimal? Daishuzhiyi4 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Daishuzhiyi4 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daishuzhiyi4 = Daishuzhiyi4.HasValue ? Daishuzhiyi4.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Daushutousu1 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Daushutousu1 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daushutousu1 = Daushutousu1.HasValue ? Daushutousu1.Value.ToString("F2") : ""; |
| | | decimal? Daushutousu2 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Daushutousu2 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daushutousu2 = Daushutousu2.HasValue ? Daushutousu2.Value.ToString("F2") : ""; |
| | | decimal? Daushutousu3 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Daushutousu3 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daushutousu3 = Daushutousu3.HasValue ? Daushutousu3.Value.ToString("F2") : ""; |
| | | decimal? Daushutousu4 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Daushutousu4 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daushutousu4 = Daushutousu4.HasValue ? Daushutousu4.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Dainizhiyiwenda = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨ççå¤").FirstOrDefault().Feiyong; |
| | |
| | | decimal? Dainitousuchulijueding = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯å¤çå³å®").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Dainitousuchulijueding = Dainitousuchulijueding.HasValue ? Dainitousuchulijueding.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Jinzhengfuishou = fiServiceDTOs.Where(x => x.ServiceType == "ç«äºå¯¹æåè¯å®¡ä¸å®¶æ¥è¯¢").FirstOrDefault().Feiyong; |
| | | decimal? Jinzhengfuishou = fiServiceDTOs.Where(x => x.ServiceType == "ç«äºå¯¹æåè¯å®¡ä¸å®¶åå æ¿åºéè´æ°æ®ä¿¡æ¯æ¥è¯¢").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Jinzhengfuishou = Jinzhengfuishou.HasValue ? Jinzhengfuishou.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Zhengcaidai = fiServiceDTOs.Where(x => x.ServiceType == "æ¿éè´·").FirstOrDefault().Feiyong; |
| | |
| | | Xuqiulunzheng5.Feiyong = Xuqiulunzheng5decimal; |
| | | resultEntity = _fiServiceService.save(Xuqiulunzheng5); |
| | | |
| | | FiServiceDTO Zhudaotoubiaowenjian1 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault(); |
| | | FiServiceDTO Zhudaotoubiaowenjian1 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault(); |
| | | decimal Zhudaotoubiaowenjian1decimal; |
| | | decimal.TryParse(data.Zhudaotoubiaowenjian1, out Zhudaotoubiaowenjian1decimal); |
| | | Zhudaotoubiaowenjian1.Feiyong = Zhudaotoubiaowenjian1decimal; |
| | | resultEntity = _fiServiceService.save(Zhudaotoubiaowenjian1); |
| | | FiServiceDTO Zhudaotoubiaowenjian2 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault(); |
| | | FiServiceDTO Zhudaotoubiaowenjian2 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault(); |
| | | decimal Zhudaotoubiaowenjian2decimal; |
| | | decimal.TryParse(data.Zhudaotoubiaowenjian2, out Zhudaotoubiaowenjian2decimal); |
| | | Zhudaotoubiaowenjian2.Feiyong = Zhudaotoubiaowenjian2decimal; |
| | | resultEntity = _fiServiceService.save(Zhudaotoubiaowenjian2); |
| | | FiServiceDTO Zhudaotoubiaowenjian3 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault(); |
| | | FiServiceDTO Zhudaotoubiaowenjian3 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault(); |
| | | decimal Zhudaotoubiaowenjian3decimal; |
| | | decimal.TryParse(data.Zhudaotoubiaowenjian3, out Zhudaotoubiaowenjian3decimal); |
| | | Zhudaotoubiaowenjian3.Feiyong = Zhudaotoubiaowenjian3decimal; |
| | | resultEntity = _fiServiceService.save(Zhudaotoubiaowenjian3); |
| | | FiServiceDTO Zhudaotoubiaowenjian4 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault(); |
| | | FiServiceDTO Zhudaotoubiaowenjian4 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault(); |
| | | decimal Zhudaotoubiaowenjian4decimal; |
| | | decimal.TryParse(data.Zhudaotoubiaowenjian4, out Zhudaotoubiaowenjian4decimal); |
| | | Zhudaotoubiaowenjian4.Feiyong = Zhudaotoubiaowenjian4decimal; |
| | | resultEntity = _fiServiceService.save(Zhudaotoubiaowenjian4); |
| | | |
| | | FiServiceDTO Daishuzhiyi1 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault(); |
| | | FiServiceDTO Daishuzhiyi1 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault(); |
| | | decimal Daishuzhiyi1decimal; |
| | | decimal.TryParse(data.Daishuzhiyi1, out Daishuzhiyi1decimal); |
| | | Daishuzhiyi1.Feiyong = Daishuzhiyi1decimal; |
| | | resultEntity = _fiServiceService.save(Daishuzhiyi1); |
| | | FiServiceDTO Daishuzhiyi2 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault(); |
| | | FiServiceDTO Daishuzhiyi2 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault(); |
| | | decimal Daishuzhiyi2decimal; |
| | | decimal.TryParse(data.Daishuzhiyi2, out Daishuzhiyi2decimal); |
| | | Daishuzhiyi2.Feiyong = Daishuzhiyi2decimal; |
| | | resultEntity = _fiServiceService.save(Daishuzhiyi2); |
| | | FiServiceDTO Daishuzhiyi3 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault(); |
| | | FiServiceDTO Daishuzhiyi3 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault(); |
| | | decimal Daishuzhiyi3decimal; |
| | | decimal.TryParse(data.Daishuzhiyi3, out Daishuzhiyi3decimal); |
| | | Daishuzhiyi3.Feiyong = Daishuzhiyi3decimal; |
| | | resultEntity = _fiServiceService.save(Daishuzhiyi3); |
| | | FiServiceDTO Daishuzhiyi4 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault(); |
| | | FiServiceDTO Daishuzhiyi4 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault(); |
| | | decimal Daishuzhiyi4decimal; |
| | | decimal.TryParse(data.Daishuzhiyi4, out Daishuzhiyi4decimal); |
| | | Daishuzhiyi4.Feiyong = Daishuzhiyi4decimal; |
| | | resultEntity = _fiServiceService.save(Daishuzhiyi4); |
| | | |
| | | FiServiceDTO Daushutousu1 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault(); |
| | | FiServiceDTO Daushutousu1 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault(); |
| | | decimal Daushutousu1decimal; |
| | | decimal.TryParse(data.Daushutousu1, out Daushutousu1decimal); |
| | | Daushutousu1.Feiyong = Daushutousu1decimal; |
| | | resultEntity = _fiServiceService.save(Daushutousu1); |
| | | FiServiceDTO Daushutousu2 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault(); |
| | | FiServiceDTO Daushutousu2 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault(); |
| | | decimal Daushutousu2decimal; |
| | | decimal.TryParse(data.Daushutousu2, out Daushutousu2decimal); |
| | | Daushutousu2.Feiyong = Daushutousu2decimal; |
| | | resultEntity = _fiServiceService.save(Daushutousu2); |
| | | FiServiceDTO Daushutousu3 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault(); |
| | | FiServiceDTO Daushutousu3 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault(); |
| | | decimal Daushutousu3decimal; |
| | | decimal.TryParse(data.Daushutousu3, out Daushutousu3decimal); |
| | | Daushutousu3.Feiyong = Daushutousu3decimal; |
| | | resultEntity = _fiServiceService.save(Daushutousu3); |
| | | FiServiceDTO Daushutousu4 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault(); |
| | | FiServiceDTO Daushutousu4 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault(); |
| | | decimal Daushutousu4decimal; |
| | | decimal.TryParse(data.Daushutousu4, out Daushutousu4decimal); |
| | | Daushutousu4.Feiyong = Daushutousu4decimal; |
| | |
| | | Dainitousuchulijueding.Feiyong = Dainitousuchulijuedingdecimal; |
| | | resultEntity = _fiServiceService.save(Dainitousuchulijueding); |
| | | |
| | | FiServiceDTO Jinzhengfuishou = fiServiceDTOs.Where(x => x.ServiceType == "ç«äºå¯¹æåè¯å®¡ä¸å®¶æ¥è¯¢").FirstOrDefault(); |
| | | FiServiceDTO Jinzhengfuishou = fiServiceDTOs.Where(x => x.ServiceType == "ç«äºå¯¹æåè¯å®¡ä¸å®¶åå æ¿åºéè´æ°æ®ä¿¡æ¯æ¥è¯¢").FirstOrDefault(); |
| | | decimal Jinzhengfuishoudecimal; |
| | | decimal.TryParse(data.Jinzhengfuishou, out Jinzhengfuishoudecimal); |
| | | Jinzhengfuishou.Feiyong = Jinzhengfuishoudecimal; |
| | |
| | | if (!string.IsNullOrEmpty(id)) |
| | | { |
| | | dto = _fiBookService.Get(id); |
| | | dto.DanjiaName = dto.Danjia.Value.ToString("F2"); ; |
| | | dto.DanjiaName = dto.Danjia.Value.ToString("F2"); |
| | | if(dto.Chubantime.HasValue) |
| | | dto.ChubantimeName = dto.Chubantime.Value.ToString("yyyy-MM-dd"); |
| | | } |
| | | ViewData.Model = dto; |
| | |
| | | List<FiServiceDTO> fiServiceDTOs = _fiServiceService.GetList(); |
| | | List<FiMemberDTO> fiMemberDTOs = _fiMemberService.GetList(); |
| | | List<FiBookDTO> fiBookDTOs = _fiBookService.GetList(); |
| | | foreach (var fiBookDTO in fiBookDTOs) |
| | | { |
| | | if (fiBookDTO.Chubantime.HasValue) |
| | | { |
| | | fiBookDTO.ChubantimeName = fiBookDTO.Chubantime.Value.ToString("yyyy-MM-dd"); |
| | | } |
| | | |
| | | } |
| | | ServiceChargeDTO serviceChargeDTO = new ServiceChargeDTO(); |
| | | decimal? Dianhuazixun = fiServiceDTOs.Where(x => x.ServiceType == "çµè¯å¨è¯¢").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Dianhuazixun = Dianhuazixun.HasValue ? Dianhuazixun.Value.ToString("F2") : ""; |
| | |
| | | decimal? Xuqiulunzheng5 = fiServiceDTOs.Where(x => x.ServiceType == "éæ±è®ºè¯" && x.ServiceTypeTwo == "1000ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Xuqiulunzheng5 = Xuqiulunzheng5.HasValue ? Xuqiulunzheng5.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Zhudaotoubiaowenjian1 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Zhudaotoubiaowenjian1 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Zhudaotoubiaowenjian1 = Zhudaotoubiaowenjian1.HasValue ? Zhudaotoubiaowenjian1.Value.ToString("F2") : ""; |
| | | decimal? Zhudaotoubiaowenjian2 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Zhudaotoubiaowenjian2 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Zhudaotoubiaowenjian2 = Zhudaotoubiaowenjian2.HasValue ? Zhudaotoubiaowenjian2.Value.ToString("F2") : ""; |
| | | decimal? Zhudaotoubiaowenjian3 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Zhudaotoubiaowenjian3 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Zhudaotoubiaowenjian3 = Zhudaotoubiaowenjian3.HasValue ? Zhudaotoubiaowenjian3.Value.ToString("F2") : ""; |
| | | decimal? Zhudaotoubiaowenjian4 = fiServiceDTOs.Where(x => x.ServiceType == "æå¯¼ææ æä»¶" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Zhudaotoubiaowenjian4 = fiServiceDTOs.Where(x => x.ServiceType == "æ 书æå¯¼" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Zhudaotoubiaowenjian4 = Zhudaotoubiaowenjian4.HasValue ? Zhudaotoubiaowenjian4.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Daishuzhiyi1 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Daishuzhiyi1 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daishuzhiyi1 = Daishuzhiyi1.HasValue ? Daishuzhiyi1.Value.ToString("F2") : ""; |
| | | decimal? Daishuzhiyi2 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Daishuzhiyi2 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daishuzhiyi2 = Daishuzhiyi2.HasValue ? Daishuzhiyi2.Value.ToString("F2") : ""; |
| | | decimal? Daishuzhiyi3 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Daishuzhiyi3 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daishuzhiyi3 = Daishuzhiyi3.HasValue ? Daishuzhiyi3.Value.ToString("F2") : ""; |
| | | decimal? Daishuzhiyi4 = fiServiceDTOs.Where(x => x.ServiceType == "代书质ç" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Daishuzhiyi4 = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨çå½" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daishuzhiyi4 = Daishuzhiyi4.HasValue ? Daishuzhiyi4.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Daushutousu1 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Daushutousu1 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "30ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daushutousu1 = Daushutousu1.HasValue ? Daushutousu1.Value.ToString("F2") : ""; |
| | | decimal? Daushutousu2 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Daushutousu2 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "30-200ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daushutousu2 = Daushutousu2.HasValue ? Daushutousu2.Value.ToString("F2") : ""; |
| | | decimal? Daushutousu3 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | decimal? Daushutousu3 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "200-500ä¸å
").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daushutousu3 = Daushutousu3.HasValue ? Daushutousu3.Value.ToString("F2") : ""; |
| | | decimal? Daushutousu4 = fiServiceDTOs.Where(x => x.ServiceType == "代书æè¯" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | decimal? Daushutousu4 = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯ä¹¦" && x.ServiceTypeTwo == "500ä¸å
以ä¸").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Daushutousu4 = Daushutousu4.HasValue ? Daushutousu4.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Dainizhiyiwenda = fiServiceDTOs.Where(x => x.ServiceType == "代æè´¨ççå¤").FirstOrDefault().Feiyong; |
| | |
| | | decimal? Dainitousuchulijueding = fiServiceDTOs.Where(x => x.ServiceType == "代ææè¯å¤çå³å®").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Dainitousuchulijueding = Dainitousuchulijueding.HasValue ? Dainitousuchulijueding.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Jinzhengfuishou = fiServiceDTOs.Where(x => x.ServiceType == "ç«äºå¯¹æåè¯å®¡ä¸å®¶æ¥è¯¢").FirstOrDefault().Feiyong; |
| | | decimal? Jinzhengfuishou = fiServiceDTOs.Where(x => x.ServiceType == "ç«äºå¯¹æåè¯å®¡ä¸å®¶åå æ¿åºéè´æ°æ®ä¿¡æ¯æ¥è¯¢").FirstOrDefault().Feiyong; |
| | | serviceChargeDTO.Jinzhengfuishou = Jinzhengfuishou.HasValue ? Jinzhengfuishou.Value.ToString("F2") : ""; |
| | | |
| | | decimal? Zhengcaidai = fiServiceDTOs.Where(x => x.ServiceType == "æ¿éè´·").FirstOrDefault().Feiyong; |
| | |
| | | private readonly IHrDeptService _hrDeptService; |
| | | private readonly ILogger<SalaryCheckController> _logger; |
| | | private readonly IHrSalaryService _hrSalaryService; |
| | | private readonly IWfRunProcessService _wfRunProcessService; |
| | | private readonly IWfHistoryService _wfHistoryService; |
| | | private readonly IWfNeeddeelService _wfNeeddeelService; |
| | | |
| | | public SalaryCheckController(ILogger<SalaryCheckController> logger, IHrSalaryService hrSalaryService, IHrDeptService hrDeptService) |
| | | public SalaryCheckController(ILogger<SalaryCheckController> logger, IHrSalaryService hrSalaryService, IHrDeptService hrDeptService, IWfRunProcessService wfRunProcessService |
| | | , IWfHistoryService wfHistoryService, IWfNeeddeelService wfNeeddeelService) |
| | | { |
| | | _logger = logger; |
| | | _hrDeptService = hrDeptService; |
| | | _hrSalaryService = hrSalaryService; |
| | | _wfRunProcessService = wfRunProcessService; |
| | | _wfHistoryService = wfHistoryService; |
| | | _wfNeeddeelService = wfNeeddeelService; |
| | | } |
| | | |
| | | public IActionResult Index() |
| | |
| | | } |
| | | |
| | | |
| | | public IActionResult Appeal(string id) |
| | | public IActionResult Appeal(string id="",string salaryId = "") |
| | | { |
| | | HrSalaryAppeal dto = new HrSalaryAppeal(); |
| | | var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); |
| | | if (!string.IsNullOrEmpty(id)) |
| | | { |
| | | dto = _hrSalaryService.GetAppeal(id, curentuser.Id); |
| | | dto = _hrSalaryService.GetAppeal(id, curentuser.Id, salaryId); |
| | | |
| | | //æµç¨ç¸å
³ |
| | | string shifoubiaoji = "A"; |
| | | string sifoudangqian = "A"; |
| | | string dangqianbuzhou = "æäº¤"; |
| | | var lishiyijian = new List<WfHistoryDTO>(); |
| | | |
| | | if(dto==null) |
| | | { |
| | | var salaryDTO = _hrSalaryService.Get(salaryId); |
| | | dto = new HrSalaryAppeal(); |
| | | dto.salary_id = id; |
| | | dto.salary_id = salaryId; |
| | | dto.Year = salaryDTO.Year; |
| | | dto.Month = salaryDTO.Month; |
| | | dto.createrName = curentuser.UserName; |
| | | dto.tittle = "å·¥èµç³è¯ï¼" + curentuser.UserName + "ï¼"; |
| | | } |
| | | else if (dto != null) |
| | | { |
| | | var wfRunProcessDTO = _wfRunProcessService.GetList(dto.id, "03").FirstOrDefault(); |
| | | if (wfRunProcessDTO == null) |
| | | { |
| | | shifoubiaoji = "D"; |
| | | sifoudangqian = "D"; |
| | | } |
| | | else |
| | | { |
| | | dangqianbuzhou = wfRunProcessDTO.Step; |
| | | //æ¥è¯¢åå²æè§ |
| | | lishiyijian = _wfHistoryService.GetListshenpi(wfRunProcessDTO.Id); |
| | | if (wfRunProcessDTO.Step != "æäº¤") |
| | | { |
| | | shifoubiaoji = "D"; |
| | | } |
| | | |
| | | //æ¥è¯¢å¾
å |
| | | var chaxundaiban = _wfNeeddeelService.GetListTracking(wfRunProcessDTO.Id, wfRunProcessDTO.Step).Where(x => x.DeelUserId == curentuser.Id).ToList(); |
| | | if (chaxundaiban != null && chaxundaiban.Count > 0) |
| | | { |
| | | sifoudangqian = "A"; |
| | | } |
| | | else |
| | | { |
| | | sifoudangqian = "D"; |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | |
| | | ViewBag.shifoubiaoji = shifoubiaoji; |
| | | ViewBag.sifoudangqian = sifoudangqian; |
| | | ViewBag.lishiyijian = lishiyijian; |
| | | ViewBag.dangqianbuzhou = dangqianbuzhou; |
| | | |
| | | ViewData.Model = dto; |
| | | return View(); |
| | | } |
| | |
| | | /// <param name="data"></param> |
| | | /// <returns></returns> |
| | | [HttpPost] |
| | | public IActionResult SaveAppeal(HrSalaryAppeal data) |
| | | public IActionResult SaveAppeal(HrSalaryAppealDTO data) |
| | | { |
| | | var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); |
| | | ResultEntity resultEntity = new ResultEntity(); |
| | | using (TransactionScope scope = new TransactionScope()) |
| | | { |
| | | if (data.Step == "æäº¤") |
| | | { |
| | | data.sub_user = curentuser.Id; |
| | | data.shenpi_status = "D"; |
| | | data.status = "A"; |
| | | resultEntity = _hrSalaryService.CheckAppea(data); |
| | | } |
| | | |
| | | |
| | | //åèµ·æµç¨ç¸å
³ |
| | | |
| | | resultEntity = _wfRunProcessService.WfSalaryAppeal(data.id, data.Step, data.Tongguojujue, curentuser.Id, data.Content, data.tittle, "v1"); |
| | | scope.Complete(); |
| | | } |
| | | return new JsonResult(resultEntity); |
| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// ä¿å |
| | | /// æäº¤å¹¶å®¡æ ¸ |
| | | /// </summary> |
| | | /// <param name="data">å²ä½å®ä½ç±»å¯¹è±¡</param> |
| | | /// <returns></returns> |
| | | [HttpPost] |
| | | [CheckLogin] |
| | | public async Task<string> TijiaobingshenheAsync(LiaotianDTO data) |
| | | { |
| | | ResultEntity resultEntity = new ResultEntity(); |
| | | resultEntity.Result = false; |
| | | var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); |
| | | ViewData["curentuser"] = curentuser; |
| | | data.RecStatus = "A"; |
| | | data.Clientid = "A"; |
| | | if (String.IsNullOrEmpty(data.Id)) |
| | | { |
| | | data.Creater = curentuser.Id; |
| | | data.Createtime = DateTime.Now; |
| | | } |
| | | data.Modifier = curentuser.Id; |
| | | data.Modifytime = DateTime.Now; |
| | | |
| | | |
| | | |
| | | resultEntity = _liaotianService.saveLiaotian(data); |
| | | |
| | | string api_domain = _configuration.GetSection("Elasticsearchurl").Value; |
| | | string url = $"{api_domain}/liaotian/person/" + data.Id; |
| | | LiaotianElasticsearchDTO liaotianElasticsearchDTO = new LiaotianElasticsearchDTO(); |
| | | liaotianElasticsearchDTO.id = data.Id; |
| | | liaotianElasticsearchDTO.question = data.Question; |
| | | liaotianElasticsearchDTO.anwser = data.Anwser; |
| | | |
| | | |
| | | string requestJson = JsonConvert.SerializeObject(liaotianElasticsearchDTO); ; |
| | | try |
| | | { |
| | | string result = string.Empty; |
| | | Uri postUrl = new Uri(url); |
| | | |
| | | using (HttpContent httpContent = new StringContent(requestJson)) |
| | | { |
| | | httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); |
| | | |
| | | var httpClient = _clientFactory.CreateClient(); |
| | | httpClient.Timeout = new TimeSpan(0, 0, 60); |
| | | var Result = await httpClient.PutAsync(postUrl, httpContent); |
| | | result = Result.Content.ReadAsStringAsync().Result; |
| | | |
| | | |
| | | |
| | | } |
| | | |
| | | Newtonsoft.Json.Linq.JObject jobject = (Newtonsoft.Json.Linq.JObject)JsonConvert.DeserializeObject(result); |
| | | |
| | | if (jobject["error"] == null && jobject["_shards"]["successful"].ToString() == "1") |
| | | { |
| | | resultEntity.Result = true; |
| | | } |
| | | else |
| | | { |
| | | resultEntity.Result = false; |
| | | } |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | resultEntity.Result = false; |
| | | throw e; |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | return JsonConvert.SerializeObject(resultEntity); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸ |
| | | /// </summary> |
| | | /// <param name="data">å²ä½å®ä½ç±»å¯¹è±¡</param> |
| | | /// <returns></returns> |
| | |
| | | |
| | | public IActionResult Index() |
| | | { |
| | | ViewBag.wfApplytypeDTOs = _wfApplytypeService.GetList(); |
| | | |
| | | |
| | | ViewBag.wfApplytypeDTOs = _wfApplytypeService.GetList().Where(x => x.Applyno != "03").ToList(); |
| | | return View(); |
| | | } |
| | | } |
| | |
| | | private readonly ILiaotianService _liaotianService; |
| | | private readonly IIntentionCustomerService _intentionCustomerService; |
| | | private readonly IUserService _userService; |
| | | private readonly ICooperatecustomCustomerService _cooperatecustomCustomerService; |
| | | |
| | | |
| | | public ProjectController(ILogger<ProjectController> logger, IProjectService projectService, ILiaotianService liaotianService,IIntentionCustomerService intentionCustomerService, IUserService userService) |
| | | public ProjectController(ILogger<ProjectController> logger, IProjectService projectService, ILiaotianService liaotianService,IIntentionCustomerService intentionCustomerService, IUserService userService |
| | | , ICooperatecustomCustomerService cooperatecustomCustomerService) |
| | | { |
| | | _logger = logger; |
| | | _projectService = projectService; |
| | | _liaotianService = liaotianService; |
| | | _intentionCustomerService = intentionCustomerService; |
| | | _userService = userService; |
| | | _cooperatecustomCustomerService = cooperatecustomCustomerService; |
| | | } |
| | | [CheckLogin] |
| | | public IActionResult Index() |
| | |
| | | { |
| | | projectDTO = _projectService.GetLiaotianEntity(id); |
| | | var intentionCustomerDTOs = _intentionCustomerService.GetList(); |
| | | var cooperatecustomCustomerDTOs = _cooperatecustomCustomerService.GetList(); |
| | | |
| | | if (projectDTO.Projectzhongbiaos!=null && projectDTO.Projectzhongbiaos.Count > 0) |
| | | { |
| | |
| | | { |
| | | var intt = intentionCustomerDTOs.Count(x=>x.Name == projectDTO.Projectzhongbiaos[i].Names); |
| | | |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Projectzhongbiaos[i].ProjectId = "yes"; |
| | | } |
| | | intt = cooperatecustomCustomerDTOs.Count(x => x.Name == projectDTO.Projectzhongbiaos[i].Names); |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Projectzhongbiaos[i].ProjectId = "yes"; |
| | |
| | | { |
| | | projectDTO.Drcunzai = "yes"; |
| | | } |
| | | intt = cooperatecustomCustomerDTOs.Count(x => x.Name == projectDTO.Drhx); |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Drcunzai = "yes"; |
| | | } |
| | | } |
| | | |
| | | if (!string.IsNullOrWhiteSpace(projectDTO.Dshx)) |
| | | { |
| | | var intt = intentionCustomerDTOs.Count(x => x.Name == projectDTO.Dshx); |
| | | |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Dscunzai = "yes"; |
| | | } |
| | | intt = cooperatecustomCustomerDTOs.Count(x => x.Name == projectDTO.Dshx); |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Dscunzai = "yes"; |
| | |
| | | { |
| | | var intt = intentionCustomerDTOs.Count(x => x.Name == projectDTO.projectreasons[i].Reasonname); |
| | | |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.projectreasons[i].ProjectId = "yes"; |
| | | } |
| | | intt = cooperatecustomCustomerDTOs.Count(x => x.Name == projectDTO.projectreasons[i].Reasonname); |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.projectreasons[i].ProjectId = "yes"; |
| | |
| | | { |
| | | projectDTO.Projectyouxiaos[i].ProjectId = "yes"; |
| | | } |
| | | intt = cooperatecustomCustomerDTOs.Count(x => x.Name == projectDTO.Projectyouxiaos[i].Namesyouxiao); |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Projectyouxiaos[i].ProjectId = "yes"; |
| | | } |
| | | } |
| | | } |
| | | |
| | | if (!string.IsNullOrWhiteSpace(projectDTO.Caigourenname)) |
| | | { |
| | | var intt = intentionCustomerDTOs.Count(x => x.Name == projectDTO.Caigourenname); |
| | | |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Caigourennamecunzai = "yes"; |
| | | } |
| | | intt = cooperatecustomCustomerDTOs.Count(x => x.Name == projectDTO.Caigourenname); |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Caigourennamecunzai = "yes"; |
| | | } |
| | | } |
| | | |
| | | if (!string.IsNullOrWhiteSpace(projectDTO.Dailiname)) |
| | | { |
| | | var intt = intentionCustomerDTOs.Count(x => x.Name == projectDTO.Dailiname); |
| | | |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Dailinamecunzai = "yes"; |
| | | } |
| | | intt = cooperatecustomCustomerDTOs.Count(x => x.Name == projectDTO.Dailiname); |
| | | if (intt > 0) |
| | | { |
| | | projectDTO.Dailinamecunzai = "yes"; |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | string s = @"^([A-Fa-f0-9]{2}[-,:]){5}[A-Fa-f0-9]{2}$"; |
| | | Regex rStr = new Regex(s); |
| | | if (rStr.IsMatch(userdata.IpMac)) |
| | | { |
| | | //if (rStr.IsMatch(userdata.IpMac)) |
| | | //{ |
| | | using (TransactionScope scope = new TransactionScope()) |
| | | { |
| | | bool charujues = false; |
| | |
| | | } |
| | | scope.Complete(); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | resultEntity.Message = "MACå°åæ ¼å¼é误"; |
| | | } |
| | | //} |
| | | //else |
| | | //{ |
| | | // resultEntity.Message = "MACå°åæ ¼å¼é误"; |
| | | //} |
| | | return JsonConvert.SerializeObject(resultEntity); |
| | | } |
| | | #endregion |
| | |
| | | <input class="form-control" label="客æ·åä½" name="Name" id="Name" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Name"> |
| | | </div> |
| | | |
| | | <label class="text-right col-sm-1 col-md-1 control-label">客æ·å¾®ä¿¡</label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input class="form-control" label="客æ·å¾®ä¿¡" name="Weixin" id="Weixin" labtype="txt" addvisible="true" editvisible="true" maxlength="50" reg="" ismust="true" type="text" value="@Model.Weixin"> |
| | | </div> |
| | | <div class="col-sm-2 col-md-2"> |
| | | æ¯å¦æ·»å 微信 |
| | | @if (Model.Shifoutianjiaweixin == "A") |
| | | { |
| | | <input id="Shifoutianjiaweixin" name="Shifoutianjiaweixin" type="radio" checked="checked" value="A" class="type_b"> |
| | | } |
| | | else |
| | | { |
| | | <input id="Shifoutianjiaweixin" name="Shifoutianjiaweixin" type="radio" value="A" class="type_b"> |
| | | |
| | | |
| | | } |
| | | </div> |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | |
| | | var hyfls = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.hyfl))'; |
| | | var users = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.users))'; |
| | | var shengDropDown = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShengDropDown))'; |
| | | var shifou = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.shifou))'; |
| | | |
| | | loseherght = 60; |
| | | gridConfig = { multiselect: true, selectcol: "Id" }; |
| | | dataCol = [ |
| | |
| | | return "<a onclick=\"OpenWindow('" + cellvalue.replace(/'/g, '') + "','98%','100%', '/CooperatecustomCustomer/Edit?id=" + rowObject.Id + "')\" >" + cellvalue + "</a>"; |
| | | } |
| | | }, |
| | | |
| | | { label: 'èç³»çµè¯', name: 'Tel', labtype: 'txt', hidden: false, width: 100 }, |
| | | { label: 'æå±åºå', name: 'ShengName', labtype: 'txt', hidden: false, width: 100 }, |
| | | { label: 'å®¢æ·æ¥æº', name: 'KhlyName', labtype: 'txt', hidden: false, width: 100 }, |
| | | { label: 'è¡ä¸åç±»', name: 'HyflName', labtype: 'txt', hidden: false, width: 100 }, |
| | |
| | | { label: 'åºå¿', name: 'AreaId', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '2%', cccwidth: '8%' }, |
| | | { label: '客æ·åä½', name: 'Name', labtype: 'txt', hidden: false }, |
| | | { label: '建档æ¶é´', name: 'Createtime', labtype: 'datearea', hidden: false }, |
| | | |
| | | { label: 'æ¯å¦æå¾®ä¿¡', name: 'Shifouweixin', labtype: 'combox', hidden: false, data: JSON.parse(shifou), cwidth: '5%', cccwidth: '8%' }, |
| | | |
| | | ]; |
| | | var _pageAdd = function () { |
| | |
| | | <div class="col-sm-6 col-md-6"> |
| | | <input class="form-control" label="客æ·åä½" name="Name" id="Name" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Name"> |
| | | </div> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">客æ·å¾®ä¿¡</label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input class="form-control" label="客æ·å¾®ä¿¡" name="Weixin" id="Weixin" labtype="txt" addvisible="true" editvisible="true" maxlength="50" reg="" ismust="true" type="text" value="@Model.Weixin"> |
| | | </div> |
| | | <div class="col-sm-2 col-md-2"> |
| | | æ¯å¦æ·»å 微信 |
| | | @if (Model.Shifoutianjiaweixin == "A") |
| | | { |
| | | <input id="Shifoutianjiaweixin" name="Shifoutianjiaweixin" type="radio" checked="checked" value="A" class="type_b"> |
| | | } |
| | | else |
| | | { |
| | | <input id="Shifoutianjiaweixin" name="Shifoutianjiaweixin" type="radio" value="A" class="type_b"> |
| | | |
| | | } |
| | | </div> |
| | | |
| | | |
| | | </div> |
| | |
| | | var users = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.users))'; |
| | | var shengDropDown = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShengDropDown))'; |
| | | var Creater = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.Creater))'; |
| | | var shifou = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.shifou))'; |
| | | loseherght = 60; |
| | | gridConfig = { multiselect: true, selectcol: "Id" }; |
| | | dataCol = [ |
| | |
| | | { label: '客æ·åä½', name: 'Name', labtype: 'txt', hidden: false }, |
| | | { label: '建档æ¶é´', name: 'Createtime', labtype: 'datearea', hidden: false }, |
| | | { label: 'å½å
¥äºº', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(Creater), cwidth: '5%', cccwidth: '8%' }, |
| | | { label: 'æ¯å¦æå¾®ä¿¡', name: 'Shifouweixin', labtype: 'combox', hidden: false, data: JSON.parse(shifou), cwidth: '5%', cccwidth: '8%' }, |
| | | |
| | | |
| | | |
| | |
| | | var khlys = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.khly))'; |
| | | var hyfls = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.hyfl))'; |
| | | var users = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.users))'; |
| | | var creater = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.creater))'; |
| | | |
| | | var shengDropDown = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShengDropDown))'; |
| | | loseherght = 60; |
| | | gridConfig = { multiselect: true, selectcol: "Id" }; |
| | |
| | | { label: '客æ·åé¦', name: 'Khfk', labtype: 'txt', hidden: false, width: 100 }, |
| | | { label: 'æäº¤æå', name: 'YxName', labtype: 'txt', hidden: false, width: 100 }, |
| | | { label: 'è·è¸ªå»ºè®®', name: 'JyName', labtype: 'txt', hidden: false, width: 100 }, |
| | | { label: 'å½å
¥äºº', name: 'CreaterName', labtype: 'txt', hidden: false, width: 100 }, |
| | | |
| | | ]; |
| | | dataUrl = "/IntentionVisit/GetList?Viscustomer=@Viscustomer"; |
| | |
| | | { label: 'åºå¿', name: 'AreaId', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '2%', cccwidth: '8%' }, |
| | | { label: '客æ·åä½', name: 'Name', labtype: 'txt', hidden: false }, |
| | | { label: 'æè®¿æ¶é´', name: 'Vistime', labtype: 'datearea', hidden: false }, |
| | | { label: 'å½å
¥äºº', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(creater), cwidth: '5%', cccwidth: '8%'}, |
| | | |
| | | |
| | | |
| | | |
| | |
| | | List<SysCodeDtl> questiontype = ViewData["questiontype"] as List<SysCodeDtl>; //é®é¢ç±»å |
| | | |
| | | List<DTO.PageEntity> pageEntities = ViewData["pageEntities"] as List<DTO.PageEntity>; //é®é¢ç±»å |
| | | var shenhesto = pageEntities.Where(x => x.PageName == "å®¡æ ¸").FirstOrDefault(); |
| | | string shenhe = ""; |
| | | if (shenhesto != null) |
| | | { |
| | | shenhe = shenhesto.PageName; |
| | | } |
| | | var tijiaobingshenhesto = pageEntities.Where(x => x.PageName == "æäº¤å¹¶å®¡æ ¸").FirstOrDefault(); |
| | | string tijiaobingshenhe = ""; |
| | | if (tijiaobingshenhesto != null) |
| | | { |
| | | tijiaobingshenhe = tijiaobingshenhesto.PageName; |
| | | } |
| | | |
| | | |
| | | } |
| | | <!DOCTYPE html> |
| | | <html> |
| | |
| | | |
| | | <div class="ibox-content" id="top" style="z-index:100; position:fixed; height:50px; width:100%;bottom:0; text-align: right; padding-top:8px "> |
| | | <div class="" style="float:right;" data-bootstro-width="500px" data-bootstro-content="åè½æé®ï¼âä¿åâï¼âå é¤â"> |
| | | <a class="btn btn-success" id="tijiaobingshenhebtn" href="javascript:void(0)" onclick="tijiaobingshenhePosition();" style="margin-left:4px; border-radius:4px;"> |
| | | <i class="glyphicon glyphicon-ok"></i> <span class="bold">æäº¤å¹¶å®¡æ ¸</span> |
| | | </a> |
| | | |
| | | <a class="btn btn-success" href="javascript:void(0)" onclick="delPosition();" style="margin-left:4px; border-radius:4px;"> |
| | | <i class="glyphicon glyphicon-remove"></i> <span class="bold">å é¤</span> |
| | | </a> |
| | |
| | | $("#div_content").height(hh); |
| | | |
| | | var id = '@Model.Id'; |
| | | var pageEntities = @pageEntities.Count; |
| | | var shenhe = '@shenhe'; |
| | | var tijiaobingshenhe = '@tijiaobingshenhe'; |
| | | var Clientid = '@Model.Clientid'; |
| | | if (id == null || id == '') { |
| | | $("#shenhebtn").hide(); |
| | | } else if (pageEntities <= 0 || Clientid == "A") { |
| | | } else if (shenhe == "" || Clientid == "A") { |
| | | $("#shenhebtn").hide(); |
| | | } else { |
| | | $("#shenhebtn").show(); |
| | | } |
| | | |
| | | if (tijiaobingshenhe == "") { |
| | | $("#tijiaobingshenhebtn").hide(); |
| | | } else { |
| | | $("#tijiaobingshenhebtn").show(); |
| | | } |
| | | |
| | | toastr.options = { |
| | | "closeButton": true, |
| | | "debug": false, |
| | |
| | | |
| | | |
| | | |
| | | // ä¿åå²ä½ä¿¡æ¯ |
| | | var tijiaobingshenhePosition = function () { |
| | | if (Verify.isNull($("#Questiontype").val())) { |
| | | toastr.warning("é®é¢ç±»å«ä¸è½ä¸ºç©º"); |
| | | return; |
| | | } |
| | | if (Verify.isNull($("#Problemtype").val())) { |
| | | toastr.warning("é¢ç®ç±»å«ä¸è½ä¸ºç©º"); |
| | | return; |
| | | } |
| | | if (Verify.isNull($("#Question").val())) { |
| | | toastr.warning("é®é¢ä¸è½ä¸ºç©º"); |
| | | return; |
| | | } |
| | | |
| | | if (Verify.isNull($("#Anwser").val())) { |
| | | toastr.warning("çæ¡ä¸è½ä¸ºç©º"); |
| | | return; |
| | | } |
| | | |
| | | imgLoad = parent.layer.load(2, { shade: [0.2, '#fff'] }); |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: "/Liaotian/Tijiaobingshenhe", |
| | | dataType: "json", |
| | | global: false, |
| | | data: { Id: id, Question: $("#Question").val(), Anwser: $("#Anwser").val(), Questiontype: $("#Questiontype").val(), Problemtype: $("#Problemtype").val(), Shiyongfatiao: $("#Shiyongfatiao").val() }, |
| | | success: function (data) { |
| | | |
| | | |
| | | if (data.Result) { |
| | | // parent._afterSave(true); |
| | | parent.layer.msg('ä¿åæå', { icon: 6 }); |
| | | _pageAutoClose();//èªå¨å
³é页颿¹æ³ |
| | | } |
| | | else { |
| | | if ($.isNumber(imgLoad)) { |
| | | parent.layer.close(imgLoad); |
| | | } |
| | | // toastr.error(""); |
| | | parent.layer.msg(data.Message, { icon: 5 }); |
| | | } |
| | | |
| | | }, |
| | | error: function () { |
| | | if ($.isNumber(imgLoad)) { |
| | | parent.layer.close(imgLoad); |
| | | } |
| | | //toastr.error("ä¿å失败"); |
| | | |
| | | parent.layer.msg('ä¿å失败', { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | $("#Questiontype").change(function () { |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | function sendHuidaStatus() { |
| | | |
| | | var msg = $("#PBSShifoushenhe"); |
| | | |
| | | |
| | | if (msg.length > 0) { |
| | | $("#PBSShifoushenhe").val("D"); |
| | | $("#PBSShifoushenhe").trigger('chosen:updated');//æ´æ°é项 |
| | | _pageSearch(); |
| | | } else { |
| | | setTimeout(sendHuidaStatus, 1000); |
| | | } |
| | | } |
| | | |
| | | send(); |
| | | sendHuidaStatus(); |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | |
| | | <div class="col-sm-3 col-md-3"> |
| | | <input id="Caigourenname" class="form-control" label="éè´äººåç§°" name="Caigourenname" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Caigourenname"> |
| | | </div> |
| | | <div class="col-sm-1 col-md-1" style="width:100px;"> |
| | | @if (Model.Caigourennamecunzai != null && Model.Caigourennamecunzai == "yes") |
| | | { |
| | | <button type="button" data-type="1">æ·»å ä¾åºå</button> |
| | | } |
| | | else |
| | | { |
| | | <button type="button" onclick="_pageAdd('@Model.Caigourenname')" data-type="1" style="color:red;">æ·»å ä¾åºå</button> |
| | | } |
| | | |
| | | |
| | | </div> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">å°å</label> |
| | | <div class="col-sm-3 col-md-3"> |
| | | <input id="Caigourenaddress" class="form-control" label="å°å" name="Caigourenaddress" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Caigourenaddress"> |
| | | </div> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">èç³»æ¹å¼</label> |
| | | <div class="col-sm-3 col-md-3"> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input id="Caigourencontact" class="form-control" label="èç³»æ¹å¼" name="Caigourencontact" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Caigourencontact"> |
| | | </div> |
| | | </div> |
| | |
| | | <div class="col-sm-3 col-md-3"> |
| | | <input id="Dailiname" class="form-control" label="éè´äººåç§°" name="Dailiname" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Dailiname"> |
| | | </div> |
| | | <div class="col-sm-1 col-md-1" style="width:100px;"> |
| | | @if (Model.Dailinamecunzai != null && Model.Dailinamecunzai == "yes") |
| | | { |
| | | <button type="button" data-type="1">æ·»å ä¾åºå</button> |
| | | } |
| | | else |
| | | { |
| | | <button type="button" onclick="_pageAdd('@Model.Dailiname')" data-type="1" style="color:red;">æ·»å ä¾åºå</button> |
| | | } |
| | | |
| | | |
| | | </div> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">å°å</label> |
| | | <div class="col-sm-3 col-md-3"> |
| | | <input id="Dailiaddress" class="form-control" label="å°å" name="Dailiaddress" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Dailiaddress"> |
| | | </div> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">èç³»æ¹å¼</label> |
| | | <div class="col-sm-3 col-md-3"> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input id="Dailicontact" class="form-control" label="èç³»æ¹å¼" name="Dailicontact" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Dailicontact"> |
| | | </div> |
| | | </div> |
| | |
| | | var ShiFouyReasonname = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShiFouyReasonname))'; |
| | | |
| | | |
| | | loseherght = 70; |
| | | loseherght = 90; |
| | | dataCol = [ |
| | | { label: 'id', name: 'Id', labtype: 'txt', hidden: true }, |
| | | |
| | |
| | | //{ label: 'å
¬åæ¶é´', name: 'StartTimestar', labtype: 'date', hidden: false }, |
| | | //{ label: '--', name: 'StartTimeend', labtype: 'date', hidden: false, cwidth: '1%', cccwidth: '15%' }, |
| | | { label: 'å
¬åæ¶é´', name: 'StartTimestar', labtype: 'datearea', hidden: false }, |
| | | { label: '项ç®ç¼å·', name: 'Number', labtype: 'txt', hidden: false }, |
| | | { label: 'ç', name: 'Sheng', labtype: 'combox', hidden: false, data: JSON.parse(shengDropDown), cwidth: '2%', cccwidth: '6%' }, |
| | | { label: '', name: 'City', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '0%', cccwidth: '6%' }, |
| | | { label: '', name: 'AreaId', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '0%', cccwidth: '6%' }, |
| | | //{ label: '项ç®ç¼å·', name: 'Number', labtype: 'txt', hidden: false }, |
| | | { label: '项ç®åç§°', name: 'Name', labtype: 'txt', hidden: false }, |
| | | { label: 'è¯å®¡ä¸å®¶', name: 'Zhuanjia', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */}, |
| | | { label: 'ç', name: 'Sheng', labtype: 'combox', hidden: false, data: JSON.parse(shengDropDown), cwidth: '5%', cccwidth: '10%' }, |
| | | { label: 'å¸', name: 'City', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '2%', cccwidth: '10%' }, |
| | | { label: 'åºå¿', name: 'AreaId', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '2.5%', cccwidth: '10%' }, |
| | | |
| | | { label: 'éè´ä»£ç人', name: 'Caigourenname', labtype: 'txt', hidden: false }, |
| | | { label: 'éè´ä»£çæºæ', name: 'Dailiname', labtype: 'txt', hidden: false }, |
| | | |
| | | { label: 'éè´æ¹å¼', name: 'Cgfs', labtype: 'combox', hidden: false, data: JSON.parse(projectDropDown) }, |
| | | { label: 'æ¯å¦åºæ ', name: 'fblx', labtype: 'combox', hidden: false, data: JSON.parse(flbx)/*, cwidth: '5%', cccwidth: '8%' */ }, |
| | | { label: '䏿 ä¾åºå', name: 'Names', labtype: 'txt', hidden: false }, |
| | |
| | | { label: 'å½å
¥äºº', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(Creater)/*, cwidth: '5%', cccwidth: '8%'*/ }, |
| | | |
| | | { label: 'åå·®å°äº', name: 'Fencha', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */ }, |
| | | |
| | | { label: 'ä¾åºåæ°é', name: 'Shuliang', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */ }, |
| | | |
| | | ]; |
| | | var _pageAdd = function () { |
| | |
| | | |
| | | |
| | | $(function () { |
| | | |
| | | |
| | | $("#PBSfblx").parent().prev().prev().remove(); |
| | | $("#PBSAreaId").parent().next().remove(); |
| | | $("#PBSZhuanjia").parent().after("<br>"); |
| | | $("#PBSDailiname").parent().next().remove(); |
| | | $("#PBSfblx").parent().after("<br>"); |
| | | $("#PBSShiFouyReasonname").parent().next().remove(); |
| | | $("#PBSNamesToubiao").parent().next().remove(); |
| | | $("#PBSReasonname").parent().after("<br>"); |
| | | $("#PBSFencha").parent().next().remove(); |
| | | $("#PBSCreater").parent().next().remove(); |
| | | |
| | | }); |
| | | |
| | |
| | | @using zhengcaioa.Models; |
| | | @{ |
| | | Layout = null; |
| | | |
| | | //æµç¨ç¸å
³ |
| | | string shifoubiaoji = ViewBag.shifoubiaoji as string; |
| | | string sifoudangqian = ViewBag.sifoudangqian as string; |
| | | string dangqianbuzhou = ViewBag.dangqianbuzhou as string; |
| | | |
| | | List<WfHistoryDTO> lishiyijian = ViewData["lishiyijian"] as List<WfHistoryDTO>; //åå²æè§ |
| | | } |
| | | |
| | | <!DOCTYPE html> |
| | |
| | | <div id="div_content" class="ibox-content" style="background-color:white;"> |
| | | <div class="row"> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">ç³è¯çç±<i class="red">*</i></label> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">åæ®åç§°<i class="red">*</i></label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input type="text" class="form-control" value="@Model.tittle" name="tittle" id="tittle" validate="RequiredField" autocomplete="off" readonly="readonly"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">ç³è¯·äºº<i class="red">*</i></label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input type="text" class="form-control" value="@Model.createrName" name="createrName" id="createrName" validate="RequiredField" autocomplete="off" readonly="readonly"> |
| | | |
| | | </div> |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">å·¥èµæä»½<i class="red">*</i></label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input class="form-control" id="YearMonth" name="YearMonth" type="text" value="@Model.Year-@Model.Month" readonly="readonly"> |
| | | <input type="hidden" name="Year" value="@Model.Year" /> |
| | | <input type="hidden" name="Month" value="@Model.Month" /> |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">ç³è¯çç±<i class="red">*</i></label> |
| | | <div class="col-sm-6 col-md-6"> |
| | | <textarea class="form-control bt" id="ssly" name="reason" maxlength="4000" length="long" style="resize:none;overflow-y:hidden; height:80px;">@Model.reason</textarea> |
| | | </div> |
| | | </div> |
| | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">å¶åº¦ä¾æ®<i class="red">*</i></label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <div class="col-sm-6 col-md-6"> |
| | | <input type="hidden" name="salary_id" value="@Model.salary_id" /> |
| | | <input class="form-control" id="zdyj" name="basis" labtype="txt" addvisible="true" editvisible="true" type="text" value="@Model.basis"> |
| | | </div> |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;" id="shenpiyijian" > |
| | | <label class="text-right col-sm-1 col-md-1 control-label">å®¡æ¹æè§</label> |
| | | <div class="col-sm-6 col-md-6"> |
| | | <textarea class="form-control data" id="Content" name="Content" style="resize:none;overflow-y:hidden; height:80px;" maxlength="500"></textarea> |
| | | </div> |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">å岿è§</label> |
| | | <div class="col-sm-6 col-md-6"> |
| | | <table> |
| | | @if (lishiyijian.Count > 0) |
| | | { |
| | | <tr> |
| | | <td style="border:1px solid #ccc;width:150px;">æ¥éª¤ </td> |
| | | <td style="border:1px solid #ccc;width:150px;"> æ¹å¤ç¶æ</td> |
| | | <td style="border:1px solid #ccc;width:150px;">æ¹å¤æ¶é´</td> |
| | | <td style="border:1px solid #ccc;width:300px;"> å®¡æ¹æè§</td> |
| | | <td style="border:1px solid #ccc;width:100px;"> æ¹å¤äºº</td> |
| | | </tr> |
| | | } |
| | | |
| | | @foreach (var wfHistory in lishiyijian) |
| | | { |
| | | <tr> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.Step</td> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.ChuliStatusName</td> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.ModifytimeName</td> |
| | | <td style="border:1px solid #ccc;width:300px;">@wfHistory.Content</td> |
| | | <td style="border:1px solid #ccc;width:100px;">@wfHistory.DeelUserIdName</td> |
| | | </tr> |
| | | } |
| | | </table> |
| | | </div> |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:60px;"> |
| | | |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | <a class="btn btn-success" href="javascript:void(0)" onclick="_pageAutoClose();" style="margin-left:4px; border-radius:4px;"> |
| | | <i class="glyphicon glyphicon-remove"></i> <span class="bold">åæ¶</span> |
| | | </a> |
| | | <a class="btn btn-success" href="javascript:void(0)" onclick="saveSimCost();" style="margin-left:4px; border-radius:4px;"> |
| | | <a class="btn btn-success" id="tijiao" href="javascript:void(0)" onclick="saveSimCost('');" style="margin-left:4px; border-radius:4px;"> |
| | | <i class="glyphicon glyphicon-ok"></i> <span class="bold">æäº¤</span> |
| | | </a> |
| | | |
| | | <a class="btn btn-success" id="tongyi" href="javascript:void(0)" onclick="saveSimCost('A');" style="margin-left:4px; border-radius:4px;"> |
| | | <span class="bold">åæ</span> |
| | | </a> |
| | | |
| | | <a class="btn btn-success" id="jujue" href="javascript:void(0)" onclick="saveSimCost('D');" style="margin-left:4px; border-radius:4px;"> |
| | | <span class="bold">æç»</span> |
| | | </a> |
| | | <input type="hidden" id="id" name="id" value="@Model.id" /> |
| | | <input type="hidden" id="Tongguojujue" name="Tongguojujue" value="" /> |
| | | <input type="hidden" id="Step" name="Step" value="@dangqianbuzhou" /> |
| | | </div> |
| | | </div> |
| | | |
| | |
| | | "hideMethod": "fadeOut" |
| | | }; |
| | | |
| | | |
| | | $(function () { |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | if ("@shifoubiaoji" != "A") { |
| | | $("input").attr('readonly', true); |
| | | $("textarea").attr('readonly', true); |
| | | $(':radio').attr('disabled', true); |
| | | $(':checkbox').attr('disabled', true); |
| | | $(':button').attr('disabled', true); |
| | | //$('a').removeAttr('onclick'); |
| | | $('select').attr('disabled', true); |
| | | $("#fileUp").attr('disabled', true); |
| | | |
| | | $('.fujianshanchu').removeAttr('onclick'); |
| | | |
| | | |
| | | if ("@sifoudangqian" == "A") { |
| | | $("#Content").attr('readonly', false); |
| | | $('#tijiao').hide(); |
| | | } else { |
| | | $('#tongyi').hide(); |
| | | $('#jujue').hide(); |
| | | $('#tijiao').hide(); |
| | | $('#shenpiyijian').hide(); |
| | | } |
| | | |
| | | } else { |
| | | |
| | | |
| | | //审æ¹ç¸å
³ |
| | | $('#shenpiyijian').hide(); |
| | | if ("@sifoudangqian" == "A") { |
| | | $('#tongyi').hide(); |
| | | $('#jujue').hide(); |
| | | } else { |
| | | $('#tongyi').hide(); |
| | | $('#jujue').hide(); |
| | | $('#tijiao').hide(); |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | }) |
| | | |
| | | |
| | | // ä¿å |
| | | function saveSimCost() { |
| | | function saveSimCost(tongyi) { |
| | | if ($("#salary_id").val() == '') { |
| | | toastr.warning("å¿
é¡»åå·¥èµæé©"); |
| | | return; |
| | | } |
| | | |
| | | |
| | | if ($("#ssly").val() == '') { |
| | | toastr.warning("ç³è¯çç±ä¸è½ä¸ºç©º"); |
| | |
| | | toastr.warning("å¶åº¦ä¾æ®ä¸è½ä¸ºç©º"); |
| | | return; |
| | | } |
| | | $("#Tongguojujue").val(tongyi); |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | |
| | | _pageAutoClose();//èªå¨å
³é页颿¹æ³ |
| | | } |
| | | catch (err) { |
| | | parent._CloseTab1("/SalaryCheck/Appeal/"); |
| | | var pathname = window.location.pathname; |
| | | var search = window.location.search; |
| | | parent._CloseTab1(pathname + search); |
| | | } |
| | | } |
| | | else { |
| | |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | <label class="text-right col-sm-3 col-md-3 control-label">çº é</label> |
| | | <div class="col-sm-9 col-md-9"> |
| | | <input class="form-control" id="Jiucuo" name="Jiucuo" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Jiucuo" oninput="if(value.length>10)value=value.slice(0,10)" onkeyup="value=value.toString().match(/^\d+(?:\.\d{0,2})?/)"> |
| | | <input class="form-control" id="Jiucuo" name="Jiucuo" labtype="txt" addvisible="true" maxlength="500" editvisible="true" reg="" ismust="true" type="text" value="@Model.Jiucuo" oninput="if(value.length>10)value=value.slice(0,10)" onkeyup="CheckNum(this);"> |
| | | </div> |
| | | </div> |
| | | |
| | |
| | | parent.layer.close(index); |
| | | return false; |
| | | } |
| | | |
| | | //ç¨æ·åªè½è¾å
¥æ£è´æ°ä¸å°æ° |
| | | function CheckNum(obj) { |
| | | |
| | | if (isNaN(obj.value) && !/^-$/.test(obj.value)) { |
| | | obj.value = ""; |
| | | } |
| | | if (!/^[+-]?\d*\.{0,1}\d{0,1}$/.test(obj.value)) { |
| | | obj.value = obj.value.replace(/\.\d{2,}$/, obj.value.substr(obj.value.indexOf('.'), 3)); |
| | | } |
| | | |
| | | } |
| | | </script> |
| | | </body> |
| | | </html> |
| | |
| | | toastr.error("é误æç¤ºï¼æ¤æä»½å·²å®æç¡®è®¤,ä¸è½ç³è¯ï¼"); |
| | | } |
| | | else { |
| | | OpenWindow('ç³è¯', '40%', '50%', '/SalaryCheck/Appeal?id=' + dt); |
| | | OpenWindow('ç³è¯', '80%', '80%', '/SalaryCheck/Appeal?salaryId=' + dt); |
| | | } |
| | | } |
| | | else { |
| | |
| | | return; |
| | | } |
| | | |
| | | if ($.trim($("#Chubanshe").val()) == '') { |
| | | toastr.warning("åºç社ä¸è½ä¸ºç©º"); |
| | | return; |
| | | } |
| | | if ($.trim($("#Chubantime").val()) == '') { |
| | | toastr.warning("åºçæ¶é´ä¸è½ä¸ºç©º"); |
| | | return; |
| | | } |
| | | //if ($.trim($("#Chubanshe").val()) == '') { |
| | | // toastr.warning("åºç社ä¸è½ä¸ºç©º"); |
| | | // return; |
| | | //} |
| | | //if ($.trim($("#Chubantime").val()) == '') { |
| | | // toastr.warning("åºçæ¶é´ä¸è½ä¸ºç©º"); |
| | | // return; |
| | | //} |
| | | if ($.trim($("#Danjia").val()) == '') { |
| | | toastr.warning("åä»·ä¸è½ä¸ºç©º"); |
| | | return; |
| | |
| | | <th style="width:15%;"> |
| | | è´§å· |
| | | </th> |
| | | <th style="width:15%;"> |
| | | <th style="width:20%;"> |
| | | 书å |
| | | </th> |
| | | <th style="width:15%;"> |
| | |
| | | <td>@Book[i].BookNo</td> |
| | | <td>@Book[i].BookName</td> |
| | | <td>@Book[i].Chubanshe</td> |
| | | <td>@Book[i].Chubantime.Value.ToString("yyyy-MM-dd")</td> |
| | | |
| | | <td>@Book[i].ChubantimeName </td> |
| | | |
| | | |
| | | <td>@Book[i].Danjia.Value.ToString("F2")</td> |
| | | <td> |
| | | <a href="javascript:void(0)" onclick="OpenWindow('@Book[i].BookName','98%','100%', '/ServiceCharge/Edit?id=@Book[i].Id');" style="margin-left:4px; border-radius:4px;"> |
| | |
| | | |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | <label class="text-left col-sm-1 col-md-1 control-label">4ãæå¯¼ææ æä»¶ï¼</label> |
| | | <label class="text-left col-sm-1 col-md-1 control-label">4ãæ ä¹¦æå¯¼ï¼</label> |
| | | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | <label class="text-left col-sm-1 col-md-1 control-label">5ã代书质çï¼</label> |
| | | <label class="text-left col-sm-1 col-md-1 control-label">5ã代æè´¨çå½ï¼</label> |
| | | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | <label class="text-left col-sm-1 col-md-1 control-label">6ã代书æè¯ï¼</label> |
| | | <label class="text-left col-sm-1 col-md-1 control-label">6ã代ææè¯ä¹¦ï¼</label> |
| | | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | <label class="text-left col-sm-1 col-md-1 control-label">8ã代ææè¯å¤çå³å®ï¼</label> |
| | | <label class="text-left col-sm-1 col-md-1 control-label" style="width:10%;">8ã代ææè¯å¤çå³å®ï¼</label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input class="form-control" label="8ãç«äºå¯¹æåè¯å®¡ä¸å®¶æ¥è¯¢ï¼" name="Dainitousuchulijueding" id="Dainitousuchulijueding" labtype="txt" addvisible="true" editvisible="true" reg="" ismust="true" type="text" value="@Model.Dainitousuchulijueding" oninput="if(value.length>8)value=value.slice(0,18)" onkeyup="value=value.toString().match(/^\d+(?:\.\d{0,2})?/)"> |
| | | <input class="form-control" label="8ã代ææè¯å¤çå³å®ï¼" name="Dainitousuchulijueding" id="Dainitousuchulijueding" labtype="txt" addvisible="true" editvisible="true" reg="" ismust="true" type="text" value="@Model.Dainitousuchulijueding" oninput="if(value.length>8)value=value.slice(0,18)" onkeyup="value=value.toString().match(/^\d+(?:\.\d{0,2})?/)"> |
| | | </div> |
| | | <label class="text-left col-sm-1 col-md-1 control-label">å
</label> |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | <label class="text-left col-sm-1 col-md-1 control-label">9ãç«äºå¯¹æåè¯å®¡ä¸å®¶æ¥è¯¢ï¼</label> |
| | | <label class="text-left col-sm-1 col-md-1 control-label" style="width:20%;">9ãç«äºå¯¹æåè¯å®¡ä¸å®¶åå æ¿åºéè´æ°æ®ä¿¡æ¯æ¥è¯¢ï¼</label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input class="form-control" label="9ãç«äºå¯¹æåè¯å®¡ä¸å®¶æ¥è¯¢ï¼" name="Jinzhengfuishou" id="Jinzhengfuishou" labtype="txt" addvisible="true" editvisible="true" reg="" ismust="true" type="text" value="@Model.Jinzhengfuishou" oninput="if(value.length>8)value=value.slice(0,18)" onkeyup="value=value.toString().match(/^\d+(?:\.\d{0,2})?/)"> |
| | | <input class="form-control" label="9ãç«äºå¯¹æåè¯å®¡ä¸å®¶åå æ¿åºéè´æ°æ®ä¿¡æ¯æ¥è¯¢ï¼" name="Jinzhengfuishou" id="Jinzhengfuishou" labtype="txt" addvisible="true" editvisible="true" reg="" ismust="true" type="text" value="@Model.Jinzhengfuishou" oninput="if(value.length>8)value=value.slice(0,18)" onkeyup="value=value.toString().match(/^\d+(?:\.\d{0,2})?/)"> |
| | | </div> |
| | | <label class="text-left col-sm-1 col-md-1 control-label">å
/å¹´</label> |
| | | </div> |
| | |
| | | <td>@Book[i].BookNo</td> |
| | | <td>@Book[i].BookName</td> |
| | | <td>@Book[i].Chubanshe</td> |
| | | <td>@Book[i].Chubantime.Value.ToString("yyyy-MM-dd")</td> |
| | | <td>@Book[i].ChubantimeName</td> |
| | | <td>@Book[i].Danjia.Value.ToString("F2")</td> |
| | | |
| | | </tr> |
| | |
| | | |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | <label class="text-left col-sm-1 col-md-1 control-label">4ãæå¯¼ææ æä»¶ï¼</label> |
| | | <label class="text-left col-sm-1 col-md-1 control-label">4ãæ ä¹¦æå¯¼ï¼</label> |
| | | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | <label class="text-left col-sm-1 col-md-1 control-label">5ã代书质çï¼</label> |
| | | <label class="text-left col-sm-1 col-md-1 control-label">5ã代æè´¨çå½ï¼</label> |
| | | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | <label class="text-left col-sm-1 col-md-1 control-label">6ã代书æè¯ï¼</label> |
| | | <label class="text-left col-sm-1 col-md-1 control-label">6ã代ææè¯ä¹¦ï¼</label> |
| | | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | | 9ãç«äºå¯¹æåè¯å®¡ä¸å®¶æ¥è¯¢ï¼ @Model.Jinzhengfuishou å
/å¹´ |
| | | 9ãç«äºå¯¹æåè¯å®¡ä¸å®¶åå æ¿åºéè´æ°æ®ä¿¡æ¯æ¥è¯¢ï¼ @Model.Jinzhengfuishou å
/å¹´ |
| | | </div> |
| | | <div class="clearfix layer-area" style="padding-bottom:15px;"> |
| | | |
| | |
| | | </tr> |
| | | <tr> |
| | | <td colspan="10"> <table> |
| | | @if (lishiyijian.Count > 0) |
| | | { |
| | | <tr> |
| | | <td style="border:1px solid #ccc;width:150px;">æ¥éª¤ </td> |
| | | <td style="border:1px solid #ccc;width:150px;"> æ¹å¤ç¶æ</td> |
| | | <td style="border:1px solid #ccc;width:150px;">æ¹å¤æ¶é´</td> |
| | | <td style="border:1px solid #ccc;width:300px;"> å®¡æ¹æè§</td> |
| | | <td style="border:1px solid #ccc;width:100px;"> æ¹å¤äºº</td> |
| | | </tr> |
| | | } |
| | | @foreach (var wfHistory in lishiyijian) |
| | | { |
| | | <tr> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.Step</td> |
| | | <td style="border:1px solid #ccc;width:50px;">@wfHistory.ChuliStatusName</td> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.ChuliStatusName</td> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.ModifytimeName</td> |
| | | <td style="border:1px solid #ccc;width:300px;">@wfHistory.Content</td> |
| | | <td style="border:1px solid #ccc;width:100px;">@wfHistory.DeelUserIdName</td> |
| | |
| | | <tr> |
| | | <td colspan="10"> |
| | | <table> |
| | | @if (lishiyijian.Count > 0) |
| | | { |
| | | <tr> |
| | | <td style="border:1px solid #ccc;width:150px;">æ¥éª¤ </td> |
| | | <td style="border:1px solid #ccc;width:150px;"> æ¹å¤ç¶æ</td> |
| | | <td style="border:1px solid #ccc;width:150px;">æ¹å¤æ¶é´</td> |
| | | <td style="border:1px solid #ccc;width:300px;"> å®¡æ¹æè§</td> |
| | | <td style="border:1px solid #ccc;width:100px;"> æ¹å¤äºº</td> |
| | | </tr> |
| | | } |
| | | @foreach (var wfHistory in lishiyijian) |
| | | { |
| | | <tr> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.Step</td> |
| | | <td style="border:1px solid #ccc;width:50px;">@wfHistory.ChuliStatusName</td> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.ChuliStatusName</td> |
| | | <td style="border:1px solid #ccc;width:150px;">@wfHistory.ModifytimeName</td> |
| | | <td style="border:1px solid #ccc;width:300px;">@wfHistory.Content</td> |
| | | <td style="border:1px solid #ccc;width:100px;">@wfHistory.DeelUserIdName</td> |
| | |
| | | </div> |
| | | |
| | | |
| | | <label class="text-right col-sm-1 col-md-1 control-label">å·¥ä½çµèMAC<i class="red">*</i> </label> |
| | | <label class="text-right col-sm-1 col-md-1 control-label">å·¥ä½çµèMAC</label> |
| | | <div class="col-sm-2 col-md-2"> |
| | | <input id="IpMac" class="form-control" label="å·¥ä½çµèMAC" name="IpMac" labtype="txt" addvisible="true" maxlength="30" editvisible="true" reg="" ismust="true" type="text" value="@Model.IpMac"> |
| | | </div> |
| | |
| | | return; |
| | | } |
| | | |
| | | if ($.trim($("#IpMac").val()) == '') { |
| | | toastr.warning("å·¥ä½çµèMACä¸è½ä¸ºç©º"); |
| | | return; |
| | | } |
| | | //if ($.trim($("#IpMac").val()) == '') { |
| | | // toastr.warning("å·¥ä½çµèMACä¸è½ä¸ºç©º"); |
| | | // return; |
| | | //} |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | |
| | | USE [zhengcaioa] |
| | | GO |
| | | |
| | | /****** Object: Table [dbo].[fi_member] Script Date: 2021/7/5 14:33:24 ******/ |
| | | SET ANSI_NULLS ON |
| | | GO |
| | | |
| | | SET QUOTED_IDENTIFIER ON |
| | | GO |
| | | IF EXISTS(Select 1 From Sysobjects Where Name='fi_member') --æ¥è¯¢è¡¨åcostSeparateConfigæ¯å¦åå¨ |
| | | drop table [fi_member] |
| | | GO |
| | | CREATE TABLE [dbo].[fi_member]( |
| | | [Id] [nvarchar](50) NOT NULL, |
| | | [member_type] [nvarchar](50) NULL, |
| | | [member_authority] [nvarchar](500) NULL, |
| | | [huifei] [money] NULL, |
| | | [rec_status] [nvarchar](1) NOT NULL, |
| | | [creater] [nvarchar](50) NOT NULL, |
| | | [createtime] [datetime] NOT NULL, |
| | | [modifier] [nvarchar](50) NOT NULL, |
| | | [modifytime] [datetime] NOT NULL, |
| | | CONSTRAINT [PK_fi_member] PRIMARY KEY CLUSTERED |
| | | ( |
| | | [Id] ASC |
| | | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
| | | ) ON [PRIMARY] |
| | | GO |
| | | |
| | | ALTER TABLE [dbo].[fi_member] ADD CONSTRAINT [DF_fi_member_rec_status] DEFAULT ('A') FOR [rec_status] |
| | | GO |
| | | |
| | | ALTER TABLE [dbo].[fi_member] ADD CONSTRAINT [DF_fi_member_creater] DEFAULT ('1') FOR [creater] |
| | | GO |
| | | |
| | | ALTER TABLE [dbo].[fi_member] ADD CONSTRAINT [DF_fi_member_createtime] DEFAULT (getdate()) FOR [createtime] |
| | | GO |
| | | |
| | | ALTER TABLE [dbo].[fi_member] ADD CONSTRAINT [DF_fi_member_modifier] DEFAULT ('1') FOR [modifier] |
| | | GO |
| | | |
| | | ALTER TABLE [dbo].[fi_member] ADD CONSTRAINT [DF_fi_member_modifytime] DEFAULT (getdate()) FOR [modifytime] |
| | | GO |
| | | |
| | | EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ä¼åç±»å' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'fi_member', @level2type=N'COLUMN',@level2name=N'member_type' |
| | | GO |
| | | |
| | | EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ä¼åæé' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'fi_member', @level2type=N'COLUMN',@level2name=N'member_authority' |
| | | GO |
| | | |
| | | EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ä¼è´¹' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'fi_member', @level2type=N'COLUMN',@level2name=N'huifei' |
| | | GO |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | ALTER TABLE [dbo].[CooperatecustomCustomer] ADD [weixin] [nvarchar](50) NULL; |
| | | GO |
| | | |
| | | |
| | | ALTER TABLE [dbo].[CooperatecustomCustomer] ADD [shifoutianjiaweixin] [nvarchar](1) NULL; |
| | | GO |
| | | |
| | | |
| | | update [CooperatecustomCustomer] set [shifoutianjiaweixin]='D' |
| | | |
| | | GO |
| | | |
| | | |
| | | |
| | | |
| | | ALTER TABLE [dbo].[IntentionCustomer] ADD [weixin] [nvarchar](50) NULL; |
| | | GO |
| | | |
| | | |
| | | ALTER TABLE [dbo].[IntentionCustomer] ADD [shifoutianjiaweixin] [nvarchar](1) NULL; |
| | | GO |
| | | |
| | | |
| | | update [IntentionCustomer] set [shifoutianjiaweixin]='D' |
| | | |
| | | GO |
| | | |
| | | |
| | | |
| | | |
| | | USE [zhengcaioa] |
| | | GO |
| | | delete from [dbo].[fi_books] |
| | | GO |
| | | INSERT [dbo].[fi_books] ([Id], [book_no], [book_name], [chubanshe], [chubantime], [danjia], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'b7b78ceb-d3d5-484a-bfd3-12118ce7d8ac', N'1001', N'ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ã', NULL, NULL, 98.0000, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:02:12.253' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:20:26.563' AS DateTime)) |
| | | INSERT [dbo].[fi_books] ([Id], [book_no], [book_name], [chubanshe], [chubantime], [danjia], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'b7b78ceb-d3d5-484a-bfd3-12118ce7d8ad', N'2001', N'ã3天å¦ä¼æ¿åºéè´ã', NULL, NULL, 49.0000, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:02:12.253' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:20:32.160' AS DateTime)) |
| | | INSERT [dbo].[fi_books] ([Id], [book_no], [book_name], [chubanshe], [chubantime], [danjia], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'b7b78ceb-d3d5-484a-bfd3-12118ce7d8ae', N'2002', N'ã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ã', NULL, NULL, 88.0000, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:02:12.253' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:20:34.183' AS DateTime)) |
| | | GO |
| | | delete from [dbo].[fi_member] |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'0d513d92-41fd-e33f-a55f-47780e03d26d', N'AA1ä¼å', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãæ 书å¶ä½3ä»¶ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼ãå
¶ä»ä¸å¡8æ', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:10.103' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.730' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'1dcfd55f-b172-855e-bcad-a83869d200b1', N'AAA2ä¼å', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãè´¨çæè¯6ä»¶ãå±¥çº¦çº çº·5ä»¶ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼ãå
¶ä»ä¸å¡6æ', 50000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:29.513' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.737' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'2ab09dee-6244-e410-fcc9-36dd6152851c', N'AA2ä¼å', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãæ 书å¶ä½5ä»¶ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼ãå
¶ä»ä¸å¡8æ', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:13.670' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.730' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'34166043-a10f-7767-9b6c-5774dfa39c43', N'æ®éä¼å1', N'å°éé®ç', 98.0000, N'A', N'1', CAST(N'2021-05-28T10:45:20.293' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.653' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'34166043-a10f-7767-9b6c-5774dfa39c44', N'æ®éä¼å2', N'æ¿é课å ', 398.0000, N'A', N'1', CAST(N'2021-05-28T10:45:20.297' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.723' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'34166043-a10f-7767-9b6c-5774dfa39c45', N'æ®éä¼å3', N'å°éé®çãæ¿é课å ', 498.0000, N'A', N'1', CAST(N'2021-05-28T10:45:20.300' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.727' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'34166043-a10f-7767-9b6c-5774dfa39c46', N'æ®éä¼å4', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:45:20.400' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.727' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'c9c8068f-7630-e5ee-eebc-71e6e63cdfab', N'A1ä¼å', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãæ 书å¶ä½1ä»¶ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:45:56.243' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.727' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'd0e3abf0-8f22-5291-d605-c95cbb7ed53c', N'AA4ä¼å', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãæ 书å¶ä½10个项ç®ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼ãå
¶ä»ä¸å¡8æ', 30000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:20.487' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.733' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'e7238216-3448-83d9-798c-ba71a3da6424', N'AA3ä¼å', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãè´¨çæè¯5ä»¶ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼ãå
¶ä»ä¸å¡8æ', 30000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:16.823' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.733' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'eeb9c016-e265-aa9d-e56f-498387f7a7fe', N'AAA1ä¼å', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãæ 书å¶ä½10个项ç®ãè´¨çæè¯5ä»¶ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼ãå
¶ä»ä¸å¡6æ', 50000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:25.980' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.733' AS DateTime)) |
| | | INSERT [dbo].[fi_member] ([Id], [member_type], [member_authority], [huifei], [rec_status], [creater], [createtime], [modifier], [modifytime]) VALUES (N'fab8d7f7-f807-9d10-8d99-0f8f16dce2d1', N'A2ä¼å', N'å°éé®çãæ¿é课å ãé®é¢å¨è¯¢ï¼çµè¯å¨è¯¢ãå½é¢å¨è¯¢ï¼ãè´¨çæè¯1ä»¶ãææ°æ¿éå¾ä¹¦ï¼ãåå·çæ¿åºéè´æ¿çæä»¶æ±ç¼ããã3天å¦ä¼æ¿åºéè´ããã2022å¹´æ¿åºéè´100大å
¸åæè¯æ¡ä¾ ãï¼', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:46:06.653' AS DateTime), N'e4c93811-b9b1-4998-89f5-c416ebab0c07', CAST(N'2021-07-05T14:41:33.730' AS DateTime)) |
| | | GO |
| | | delete from [dbo].[fi_service] |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'01204ed4-c825-2f6e-d19a-870683c12e56', N'æ 书æå¯¼', N'200-500ä¸å
', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:54.090' AS DateTime), N'1', CAST(N'2021-05-28T10:52:54.090' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'0bbc9d36-3827-29b2-bbc2-96a1dce615e9', N'ç«äºå¯¹æåè¯å®¡ä¸å®¶åå æ¿åºéè´æ°æ®ä¿¡æ¯æ¥è¯¢', NULL, 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:20.923' AS DateTime), N'1', CAST(N'2021-05-28T10:54:20.923' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'0c9559cc-2feb-4f01-4446-91568194538d', N'ä¸å
·å¤æ¡ä»¶', NULL, 50000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:15.643' AS DateTime), N'1', CAST(N'2021-05-28T11:06:15.643' AS DateTime), N'06') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1565b317-e3e7-65eb-abbb-0607b1f2d28e', N'æ 书æå¯¼', N'30-200ä¸å
', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:51.117' AS DateTime), N'1', CAST(N'2021-05-28T10:52:51.117' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1650e01e-dace-5036-5395-a56ef7c3a3a7', N'èªå¨æ 书å¶ä½è½¯ä»¶', NULL, 20000.0000, N'A', N'1', CAST(N'2021-05-28T11:08:08.043' AS DateTime), N'1', CAST(N'2021-05-28T11:08:08.043' AS DateTime), N'09') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'17471db7-f6b8-5448-9917-495e1306f77d', N'代ææè¯ä¹¦', N'30ä¸å
以ä¸', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:09.620' AS DateTime), N'1', CAST(N'2021-05-28T10:53:09.620' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1913662b-acfc-5a82-2bcc-782139e90908', N'éæ±è®ºè¯', N'500-1000ä¸å
', 8000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:40.247' AS DateTime), N'1', CAST(N'2021-05-28T10:52:40.247' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1a7fbc0e-89da-88f5-6bbe-a19a6f0eeaa1', N'ææ ä¿¡æ¯ç®¡çç³»ç»', NULL, 50000.0000, N'A', N'1', CAST(N'2021-05-28T11:08:11.290' AS DateTime), N'1', CAST(N'2021-05-28T11:08:11.290' AS DateTime), N'09') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'1ebde632-88d2-039e-7325-2062c122da67', N'å±¥çº¦çº çº·', N'1000ä¸å
以ä¸', 100000.0000, N'A', N'1', CAST(N'2021-05-28T11:07:01.997' AS DateTime), N'1', CAST(N'2021-05-28T11:07:01.997' AS DateTime), N'07') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'24d25b49-de97-8f9f-81d4-decdcf30bdb7', N'代æè´¨çå½', N'200-500ä¸å
', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:04.540' AS DateTime), N'1', CAST(N'2021-05-28T10:53:04.540' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'2872e063-a4c3-4c83-2c92-a94e7f333bb4', N'线ä¸è®²åº§', NULL, 998.0000, N'A', N'1', CAST(N'2021-05-28T10:54:38.953' AS DateTime), N'1', CAST(N'2021-05-28T10:54:38.953' AS DateTime), N'04') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'396c50c4-fd7a-66de-c0e9-b50020fc9e8f', N'代ææè¯ä¹¦', N'500ä¸å
以ä¸', 30000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:17.717' AS DateTime), N'1', CAST(N'2021-05-28T10:53:17.717' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'3d892e90-d52b-3d6d-9910-9f0c3b5dfe8a', N'æ 书æå¯¼', N'30ä¸å
以ä¸', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:48.263' AS DateTime), N'1', CAST(N'2021-05-28T10:52:48.263' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'48694773-2045-43cc-7340-dcc8fca74ab6', N'æ 书å¶ä½', N'30ä¸å
以ä¸', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:26.083' AS DateTime), N'1', CAST(N'2021-05-28T10:54:26.083' AS DateTime), N'03') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'4dbac1ab-d980-40a1-8035-b08e386a2f77', N'代æè´¨ççå¤', NULL, 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:14.410' AS DateTime), N'1', CAST(N'2021-05-28T10:54:14.410' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'521aaa43-f2e6-4113-7d50-73695e80768f', N'éæ±è®ºè¯', N'200-500ä¸å
', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:30.837' AS DateTime), N'1', CAST(N'2021-05-28T10:52:30.837' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'56c7a576-26cc-3a1b-4ed7-6832e001ffa9', N'æ 书æå¯¼', N'500ä¸å
以ä¸', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:56.680' AS DateTime), N'1', CAST(N'2021-05-28T10:52:56.680' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'600688d7-24c4-4ff8-5bc9-b86c17ad4c0b', N'代ææè¯å¤çå³å®', NULL, 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:18.210' AS DateTime), N'1', CAST(N'2021-05-28T10:54:18.210' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'606fb37a-9db2-26c8-b0fa-b1e8ebdb3c08', N'å±¥çº¦çº çº·', N'30-200ä¸å
', 20000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:21.513' AS DateTime), N'1', CAST(N'2021-05-28T11:06:21.513' AS DateTime), N'07') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'7034105f-9a0e-c122-4106-2608272f132e', N'å±¥çº¦çº çº·', N'30ä¸å
以ä¸', 10000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:18.257' AS DateTime), N'1', CAST(N'2021-05-28T11:06:18.257' AS DateTime), N'07') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'772c660a-3f45-0977-1720-1f3598a029d0', N'æ 书å¶ä½', N'200-500ä¸å
', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:30.943' AS DateTime), N'1', CAST(N'2021-05-28T10:54:30.943' AS DateTime), N'03') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'7be6965b-e08a-6e01-9409-14592b06354b', N'éè´äººå¹è®', NULL, 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:44.113' AS DateTime), N'1', CAST(N'2021-05-28T10:54:44.113' AS DateTime), N'04') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'7fa99d1a-995f-7b49-6127-2ebeef823104', N'æ¿éè´·', NULL, 1.0000, N'A', N'1', CAST(N'2021-05-28T10:54:23.563' AS DateTime), N'1', CAST(N'2021-05-28T10:54:23.563' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'81839b9a-4c55-5fcd-426a-4e9535509af0', N'å±¥çº¦çº çº·', N'500-1000ä¸å
', 50000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:35.410' AS DateTime), N'1', CAST(N'2021-05-28T11:06:35.410' AS DateTime), N'07') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'9337f9e5-ab86-2be9-72d4-9b1db3078e33', N'å¢å åç®', NULL, 10000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:12.417' AS DateTime), N'1', CAST(N'2021-05-28T11:06:12.417' AS DateTime), N'06') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'94f7a7c6-a73a-f845-9345-28bd8de79ae2', N'代æè´¨çå½', N'30-200ä¸å
', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:01.920' AS DateTime), N'1', CAST(N'2021-05-28T10:53:01.920' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'9934cb44-3aa8-1dda-093e-5d8a2aa6963f', N'éæ±è®ºè¯', N'30ä¸å
以ä¸', 2000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:19.827' AS DateTime), N'1', CAST(N'2021-05-28T10:52:19.827' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'994491fa-c74d-7df2-f4d1-cfdba128ab35', N'ä¾åºåå¹è®', NULL, 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:41.513' AS DateTime), N'1', CAST(N'2021-05-28T10:54:41.513' AS DateTime), N'04') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'9c5f799f-176a-787b-82b9-321aa16422f3', N'å½é¢å¨è¯¢', NULL, 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:17.007' AS DateTime), N'1', CAST(N'2021-05-28T10:52:17.007' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'9ff378fd-dba7-315c-9a3b-ec9cd07ba597', N'å±¥çº¦çº çº·', N'200-500ä¸å
', 30000.0000, N'A', N'1', CAST(N'2021-05-28T11:06:25.220' AS DateTime), N'1', CAST(N'2021-05-28T11:06:25.220' AS DateTime), N'07') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'a4971acc-b09d-c56e-f612-e6ca79c374fe', N'å¨çº¿è®²åº§', NULL, 20.0000, N'A', N'1', CAST(N'2021-05-28T10:54:36.463' AS DateTime), N'1', CAST(N'2021-05-28T10:54:36.463' AS DateTime), N'04') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'b4b5bf29-6887-19d0-695b-e022b207b6cf', N'çµè¯å¨è¯¢', NULL, 1000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:11.850' AS DateTime), N'1', CAST(N'2021-05-28T10:52:11.850' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'b9d9fd86-da94-3a03-3714-bf962a2af5fd', N'æ 书å¶ä½', N'500ä¸å
以ä¸', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:33.800' AS DateTime), N'1', CAST(N'2021-05-28T10:54:33.800' AS DateTime), N'03') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'ca4ef6e0-bab8-e61e-d209-1e9a08fca42e', N'å
·å¤æ¡ä»¶', NULL, 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:46.593' AS DateTime), N'1', CAST(N'2021-05-28T10:54:46.593' AS DateTime), N'06') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'd945d55b-9392-c97c-71ee-5e83cc1d9c80', N'éæ±è®ºè¯', N'30-200ä¸å
', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:23.660' AS DateTime), N'1', CAST(N'2021-05-28T10:52:23.660' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'de752562-a4a3-bf20-04f8-06f2e320b8db', N'代æè´¨çå½', N'30ä¸å
以ä¸', 3000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:59.240' AS DateTime), N'1', CAST(N'2021-05-28T10:52:59.240' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'e39f6ba7-70c7-822d-c104-fe4a562e0b2a', N'代æè´¨çå½', N'500ä¸å
以ä¸', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:07.117' AS DateTime), N'1', CAST(N'2021-05-28T10:53:07.117' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'e510300a-b278-cc48-3f56-6b98b6b685dd', N'代ææè¯ä¹¦', N'30-200ä¸å
', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:12.380' AS DateTime), N'1', CAST(N'2021-05-28T10:53:12.380' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'ecb0bd60-3653-3ac4-8584-c330a66f6637', N'éæ±è®ºè¯', N'1000ä¸å
以ä¸', 10000.0000, N'A', N'1', CAST(N'2021-05-28T10:52:45.873' AS DateTime), N'1', CAST(N'2021-05-28T10:52:45.873' AS DateTime), N'02') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'eeec65e5-94f4-4a7a-4159-d2d1ae83c5c4', N'æ 书å¶ä½', N'30-200ä¸å
', 5000.0000, N'A', N'1', CAST(N'2021-05-28T10:54:28.513' AS DateTime), N'1', CAST(N'2021-05-28T10:54:28.513' AS DateTime), N'03') |
| | | INSERT [dbo].[fi_service] ([Id], [service_type], [service_type_two], [feiyong], [rec_status], [creater], [createtime], [modifier], [modifytime], [service_type_top]) VALUES (N'fd9cbc17-dbbb-2e54-215c-a87da04603e2', N'代ææè¯ä¹¦', N'200-500ä¸å
', 20000.0000, N'A', N'1', CAST(N'2021-05-28T10:53:14.987' AS DateTime), N'1', CAST(N'2021-05-28T10:53:14.987' AS DateTime), N'02') |
| | | GO |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | ALTER TABLE [dbo].[Project] ADD [Fencha] [money] NULL; |
| | | GO |
| | | |
| | | |
| | | |
| | | |
| | | ALTER TABLE [dbo].[Project] ADD [Shuliang] [int] NULL; |
| | | GO |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | USE [zhengcaioa] |
| | | GO |
| | | |
| | | /****** Object: Table [dbo].[t_salary_appeal] Script Date: 2021/7/2 9:06:14 ******/ |
| | | SET ANSI_NULLS ON |
| | | GO |
| | | |
| | | SET QUOTED_IDENTIFIER ON |
| | | GO |
| | | |
| | | IF EXISTS(Select 1 From Sysobjects Where Name='t_salary_appeal') --æ¥è¯¢è¡¨åcostSeparateConfigæ¯å¦åå¨ |
| | | drop table [t_salary_appeal] |
| | | GO |
| | | |
| | | CREATE TABLE [dbo].[t_salary_appeal]( |
| | | [id] [nvarchar](50) NOT NULL, |
| | | [salary_id] [nvarchar](50) NULL, |
| | | [year] [int] NOT NULL, |
| | | [month] [int] NOT NULL, |
| | | [reason] [nvarchar](1000) NULL, |
| | | [amount] [decimal](10, 2) NULL, |
| | | [basis] [nvarchar](500) NULL, |
| | | [sub_user] [nvarchar](50) NULL, |
| | | [sub_time] [datetime] NULL, |
| | | [chk_user] [nvarchar](50) NULL, |
| | | [chk_time] [datetime] NULL, |
| | | [chk_result] [nvarchar](1000) NULL, |
| | | [status] [nvarchar](1) NULL, |
| | | [createrName] [nvarchar](50) NULL, |
| | | [tittle] [nvarchar](50) NULL, |
| | | [shenpi_status] [nvarchar](1) NULL, |
| | | CONSTRAINT [PK_T_SALARY_APPEAL] PRIMARY KEY CLUSTERED |
| | | ( |
| | | [id] ASC |
| | | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
| | | ) ON [PRIMARY] |
| | | GO |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | USE [zhengcaioa] |