/// <summary>
        /// 更新工资标准信息
        /// </summary>
        /// <param name="model">保存信息</param>
        /// <returns></returns>
        public static bool UpdateSalaryStandard(SalaryStandardModel model)
        {
            #region 更新SQL拼写
            StringBuilder updateSql = new StringBuilder();
            updateSql.AppendLine(" UPDATE officedba.SalaryStandard ");
            updateSql.AppendLine(" SET CompanyCD = @CompanyCD      ");
            updateSql.AppendLine("   ,QuarterID = @QuarterID       ");
            updateSql.AppendLine("   ,AdminLevel = @AdminLevel     ");
            updateSql.AppendLine("   ,ItemNo = @ItemNo             ");
            updateSql.AppendLine("   ,UnitPrice = @UnitPrice       ");
            updateSql.AppendLine("   ,Remark = @Remark             ");
            updateSql.AppendLine("   ,UsedStatus = @UsedStatus     ");
            updateSql.AppendLine(" WHERE                           ");
            updateSql.AppendLine(" 	ID = @StandardID               ");
            #endregion

            //定义更新基本信息的命令
            SqlCommand comm = new SqlCommand();
            comm.CommandText = updateSql.ToString();
            //设置保存的参数
            SetSaveParameter(comm, model);
            //ID
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@StandardID", model.ID));

            //执行插入操作并返回更新结果
            return(SqlHelper.ExecuteTransWithCommand(comm));
        }
示例#2
0
        public List <SalaryStandardModel> SalaryStandardSelect()
        {
            List <SalaryStandard>      list  = Select();
            List <SalaryStandardModel> list2 = new List <SalaryStandardModel>();

            foreach (SalaryStandard item in list)
            {
                SalaryStandardModel ckm = new SalaryStandardModel()
                {
                    Id           = item.Id,
                    Standardid   = item.Standardid,
                    Standardname = item.Standardname,
                    Designer     = item.Designer,
                    Register     = item.Register,
                    Checker      = item.Checker,
                    Changer      = item.Changer,
                    Registtime   = item.Registtime,
                    Checktime    = item.Checktime,
                    Changetime   = item.Changetime,
                    Salarysum    = item.Salarysum,
                    Checkstatus  = item.Checkstatus,
                    Changestatus = item.Changestatus,
                    Checkcomment = item.Checkcomment,
                    Remark       = item.Remark
                };
                list2.Add(ckm);
            }
            return(list2);
        }
示例#3
0
        public List <SalaryStandardModel> SalaryStandardSelectFY(int currentPage, int pageSize, out int rows)
        {
            string sql = "select * from dbo.SalaryStandard where Checkstatus = 0";

            var list = CreateContext().SalaryStandard.SqlQuery(sql).OrderBy(e => e.Id).ToList();

            rows = list.Count();
            var data = list.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList();
            List <SalaryStandardModel> list2 = new List <SalaryStandardModel>();

            foreach (var p in data)
            {
                SalaryStandardModel sm = new SalaryStandardModel()
                {
                    Id           = p.Id,
                    Standardid   = p.Standardid,
                    Standardname = p.Standardname,
                    Designer     = p.Designer,
                    Register     = p.Register,
                    Checker      = p.Checker,
                    Changer      = p.Changer,
                    Registtime   = p.Registtime,
                    Checktime    = p.Checktime,
                    Changetime   = p.Changetime,
                    Salarysum    = p.Salarysum,
                    Checkstatus  = p.Checkstatus,
                    Changestatus = p.Changestatus,
                    Checkcomment = p.Checkcomment,
                    Remark       = p.Remark
                };
                list2.Add(sm);
            }
            return(list2);
        }
示例#4
0
        public int SalaryStandardUpdate(SalaryStandardModel ck)
        {
            MyDbContext db  = CreateContext();
            string      sql = string.Format(@"update dbo.SalaryStandard set Checker='{0}',Checktime='{1}',Checkcomment='{2}',Checkstatus=1,Salarysum={3} where Id ={4}", ck.Checker, ck.Checktime, ck.Checkcomment, ck.Salarysum, ck.Id);

            // int list = db.Database.ExecuteSqlCommand(sql);
            int list = db.Database.ExecuteSqlCommand(sql);

            return(list);
            //SalaryStandard ssd = new SalaryStandard();
            //ssd.Id = ck.Id;
            //ssd.Standardid = ck.Standardid;
            //ssd.Standardname = ck.Standardname;
            //ssd.Designer = ck.Designer;
            //ssd.Register = ck.Register;
            //ssd.Checker = ck.Checker;
            //ssd.Changer = ck.Changer;
            //ssd.Registtime = ck.Registtime;
            //ssd.Checktime = ck.Checktime;
            //ssd.Changetime = ck.Changetime;
            //ssd.Salarysum = ck.Salarysum;
            //ssd.Checkstatus = ck.Checkstatus;
            //ssd.Changestatus = ck.Changestatus;
            //ssd.Checkcomment = ck.Checkcomment;
            //ssd.Remark = ck.Remark;
            //return Update(ssd);
        }
示例#5
0
    protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
    {
        //获取数据
        SalaryStandardModel searchModel = new SalaryStandardModel();

        //设置查询条件
        //岗位
        searchModel.QuarterID = Request.Form["ddlSearchQuarter"].ToString();
        //岗位职等
        //string I= Request.Form.AllKeys.ToString();
        searchModel.AdminLevel = Request.Form["ctSearchQuaterAdmin$ddlCodeType"].ToString();
        //启用状态
        searchModel.UsedStatus = Request.Form["ddlSearchUsedStatus"].ToString();

        //查询数据
        DataTable dtNotify = SalaryStandardBus.SearchSalaryStandardInfo(searchModel);

        //导出标题
        string headerTitle = "岗位|岗位职等|工资项名称|金额|启用状态";

        string[] header = headerTitle.Split('|');

        //导出标题所对应的列字段名称
        string columnFiled = "QuarterName|AdminLevelName|ItemName|UnitPrice|UsedStatusName";

        string[] field = columnFiled.Split('|');

        XBase.Common.OutputToExecl.ExportToTable(this.Page, dtNotify, header, field, "岗位工资设置");
    }
示例#6
0
        /// <summary>
        ///  薪酬标准登记点击提交的方法
        /// </summary>
        /// <returns></returns>
        public ActionResult xg()
        {
            SalaryStandardModel sg = new SalaryStandardModel();

            sg.Id           = Convert.ToInt32(Request["Id"]);
            sg.Salarysum    = Request["Salarysum"] == null || Request["Salarysum"] == "" ? sg.Salarysum : Convert.ToDecimal(Request["Salarysum"]);
            sg.Checker      = Request["Checker"];
            sg.Checktime    = Convert.ToDateTime(Request["Checktime"]);
            sg.Checkcomment = Request["Checkcomment"];

            int r1 = isb.SalaryStandardUpdate(sg);

            string arry = Request["arry"];
            List <Dictionary <string, object> > sdm = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(arry);
            int r2 = 0;

            foreach (var item in sdm)
            {
                SalaryStandardDetailsModel sm = new SalaryStandardDetailsModel();
                sm.Id     = int.Parse(item["Id"].ToString());
                sm.Salary = item["money"] == null || item["money"] == "" ? sm.Salary : Convert.ToDecimal(item["money"]);

                if (isd.SalaryStandardDetailsUpdate(sm) > 0)
                {
                    r2++;
                }
            }
            string flag = "false";

            if (r1 > 0 && r2 == sdm.Count)
            {
                flag = "true";
            }
            return(Content(flag));
        }
示例#7
0
        public List <SalaryStandardModel> SalaryStandardSelectBy(int id)
        {
            MyDbContext           db   = CreateContext();
            List <SalaryStandard> list = db.SalaryStandard.AsNoTracking()
                                         .Where(e => e.Id == id)
                                         .Select(e => e)
                                         .ToList();
            List <SalaryStandardModel> list2 = new List <SalaryStandardModel>();

            foreach (SalaryStandard item in list)
            {
                SalaryStandardModel sm = new SalaryStandardModel()
                {
                    Id           = item.Id,
                    Standardid   = item.Standardid,
                    Standardname = item.Standardname,
                    Designer     = item.Designer,
                    Register     = item.Register,
                    Checker      = item.Checker,
                    Changer      = item.Changer,
                    Registtime   = item.Registtime,
                    Checktime    = item.Checktime,
                    Changetime   = item.Changetime,
                    Salarysum    = item.Salarysum,
                    Checkstatus  = item.Checkstatus,
                    Changestatus = item.Changestatus,
                    Checkcomment = item.Checkcomment,
                    Remark       = item.Remark
                };
                list2.Add(sm);
            }
            return(list2);
        }
        /// <summary>
        /// 查询工资标准信息
        /// </summary>
        /// <param name="model">查询条件</param>
        /// <returns></returns>
        public static DataTable SearchSalarySummaryReport(SalaryStandardModel model)
        {
            #region 查询语句
            StringBuilder searchSql = new StringBuilder();
            searchSql.AppendLine(" select c.DeptID as Remark,Substring(a.ReportMonth, 1, 4) + '年'+ Substring(a.ReportMonth, 5, 2) + '月' as itemNo,count( distinct(b.EmployeeID)) as CompanyCD,sum(b.SalaryMoney) as UnitPrice                                    ");
            searchSql.AppendLine(" from officedba.SalaryReport a left outer join officedba. SalaryReportSummary  b ");
            searchSql.AppendLine(" on b.companyCD=a.companyCD and a.ReprotNo =b.ReprotNo                                   ");
            searchSql.AppendLine(" 	left outer join officedba.EmployeeInfo c             ");
            searchSql.AppendLine(" 	on  c.companyCD=a.companyCD and b.EmployeeID=C.ID         ");
            searchSql.AppendLine(" 	left outer join officedba.DeptInfo d                ");
            searchSql.AppendLine(" on d.companyCD=a.companyCD and c.DeptID=d.ID    ");
            searchSql.AppendLine(" 	where   a. CompanyCD=@CompanyCD   and     a.Status='3'      ");

            #endregion



            //定义查询的命令
            SqlCommand comm = new SqlCommand();

            #region 设置参数
            //公司代码
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
            //岗位ID
            if (!string.IsNullOrEmpty(model.QuarterID))
            {
                searchSql.AppendLine("	AND c.DeptID = @DeptID ");
                comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", model.QuarterID));
            }
            if (!string.IsNullOrEmpty(model.AdminLevel))//开始月份
            {
                searchSql.AppendLine("	AND Substring(a.ReportMonth, 5, 2)>=@StartMonth ");
                comm.Parameters.Add(SqlHelper.GetParameterFromString("@StartMonth", model.AdminLevel));
            }
            if (!string.IsNullOrEmpty(model.AdminLevelName))//结束月份
            {
                searchSql.AppendLine("	AND Substring(a.ReportMonth, 5, 2)<=@EndMonth");
                comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndMonth", model.AdminLevelName));
            }
            if (!string.IsNullOrEmpty(model.UnitPrice))//年度
            {
                searchSql.AppendLine("	AND Substring(a.ReportMonth, 1, 4)=@year");
                comm.Parameters.Add(SqlHelper.GetParameterFromString("@year", model.UnitPrice));
            }
            //岗位职等
            //if (!string.IsNullOrEmpty(model.AdminLevel))
            //{
            //    searchSql.AppendLine("	AND A.AdminLevel = @AdminLevel ");
            //    comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdminLevel", model.AdminLevel));
            //}

            #endregion
            searchSql.AppendLine(" 	group by c.DeptID,a.ReportMonth        ");
            //指定命令的SQL文
            comm.CommandText = searchSql.ToString();
            //执行查询
            return(SqlHelper.ExecuteSearch(comm));
        }
    private void Search()
    {
        SalaryStandardModel searchModel = new SalaryStandardModel();

        //设置查询条件
        //岗位

        if (ddlDeptName.SelectedValue != "0")//部门
        {
            searchModel.QuarterID = ddlDeptName.SelectedValue;
        }
        if (this.ddlStartMonth.SelectedValue != "0") //起始月份
        {
            searchModel.AdminLevel = ddlStartMonth.SelectedValue;
        }
        if (this.ddlEndMonth.SelectedValue != "0") //结束月份
        {
            searchModel.AdminLevelName = ddlEndMonth.SelectedValue;
        }
        if (this.ddlYear.SelectedValue != "0") //结束月份
        {
            searchModel.UnitPrice = ddlYear.SelectedValue;
        }
        UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
        //查询数据
        DataTable dtNewTable = SalaryStandardBus.SearchSalarySummaryReport(searchModel);
        DataTable dtData     = new DataTable();

        dtData.Columns.Add("Remark");
        dtData.Columns.Add("itemNo");
        dtData.Columns.Add("CompanyCD");
        dtData.Columns.Add("UnitPrice");
        for (int i = 0; i < dtNewTable.Rows.Count; i++)
        {
            DataRow newRow = dtData.NewRow();
            newRow["Remark"]    = getDeptName(dtNewTable.Rows[i]["Remark"] == null ? "" : dtNewTable.Rows[i]["Remark"].ToString());
            newRow["itemNo"]    = dtNewTable.Rows[i]["itemNo"] == null ? "" : dtNewTable.Rows[i]["itemNo"].ToString();
            newRow["CompanyCD"] = dtNewTable.Rows[i]["CompanyCD"] == null ? "" : dtNewTable.Rows[i]["CompanyCD"].ToString();
            newRow["UnitPrice"] = dtNewTable.Rows[i]["UnitPrice"] == null ? "" : dtNewTable.Rows[i]["UnitPrice"].ToString();
            dtData.Rows.Add(newRow);
        }


        ReportDocument oRpt = new ReportDocument();

        CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalarySummeryReport.rpt"));
        // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名
        CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary"));
        //查询数据
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text         = "\"" + "制表人:" + userInfo.EmployeeName + "\"";
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text        = "\"" + "起始年月:" + ddlYear.SelectedValue + "." + ddlStartMonth.SelectedValue + "\"";
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "结束年月:" + ddlYear.SelectedValue + "." + ddlEndMonth.SelectedValue + "\"";
        CrystalReportSource1.ReportDocument.SetDataSource(dtData);
        CrystalReportSource1.DataBind();
        // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像
        CrystalReportViewer1.ReportSource = CrystalReportSource1;
        //CrystalReportViewer1.DataBind();
    }
    private void Search()
    {
        SalaryStandardModel searchModel = new SalaryStandardModel();

        //设置查询条件
        //岗位
        if (ddlSearchQuarter.SelectedValue != "0")
        {
            searchModel.QuarterID = ddlSearchQuarter.SelectedValue;
        }
        //岗位职等
        if (ddlSearchQuaterAdmin.SelectedValue != "0")
        {
            searchModel.AdminLevel = ddlSearchQuaterAdmin.SelectedValue;
        }
        //启用状态·
        searchModel.UsedStatus = "1";
        UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
        //查询数据
        DataTable dtData = SalaryStandardBus.SearchSalaryStandardReport(searchModel);

        ReportDocument oRpt = new ReportDocument();

        CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalaryStandardReport.rpt"));
        // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名
        CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryStandard"));

        //查询数据
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text        = "\"" + "" + "\"";
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "" + "\"";
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text         = "\"" + "制表人:" + userInfo.EmployeeName + "\"";

        if (ddlSearchQuarter.SelectedValue != "0" && ddlSearchQuarter.SelectedIndex != -1)
        {
            CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "岗位:" + ddlSearchQuarter.Items[ddlSearchQuarter.SelectedIndex].Text + "\"";
        }
        else
        {
            CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text = "\"" + "岗位:" + "全部" + "\"";
        }
        if (this.ddlSearchQuaterAdmin.SelectedValue != "0" && ddlSearchQuaterAdmin.SelectedIndex != -1)
        {
            CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "职等:" + ddlSearchQuaterAdmin.Items[ddlSearchQuaterAdmin.SelectedIndex].Text + "\"";
        }
        else
        {
            CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "职等:" + "全部" + "\"";
        }



        CrystalReportSource1.ReportDocument.SetDataSource(dtData);
        CrystalReportSource1.DataBind();
        // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像
        CrystalReportViewer1.ReportSource = CrystalReportSource1;
        // CrystalReportViewer1.DataBind();
    }
示例#11
0
        /// <summary>
        /// 校验工资标准信息
        /// </summary>
        /// <param name="model">查询条件</param>
        /// <returns></returns>
        public static bool CheckSalaryStandardInfo(SalaryStandardModel model)
        {
            //获取登陆用户信息
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];

            //设置公司代码
            model.CompanyCD = userInfo.CompanyCD;
            //执行查询
            return(SalaryStandardDBHelper.CheckSalaryStandardInfo(model));
        }
示例#12
0
        public int SalaryStandardUpdate2(SalaryStandardModel ck)
        {
            MyDbContext db  = CreateContext();
            string      sql = string.Format(@"update dbo.SalaryStandard set Changer='{0}',Changetime='{1}',Remark='{2}',Checkstatus=0,Salarysum={3} where Id ={4}", ck.Changer, ck.Changetime, ck.Remark, ck.Salarysum, ck.Id);

            // int list = db.Database.ExecuteSqlCommand(sql);
            int list = db.Database.ExecuteSqlCommand(sql);

            return(list);
        }
示例#13
0
        /// <summary>
        /// 查询工资标准信息
        /// </summary>
        /// <param name="model">查询条件</param>
        /// <returns></returns>
        public static DataTable SearchSalaryDetailsReport(SalaryStandardModel model)
        {
            //获取登陆用户信息
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];

            //设置公司代码
            model.CompanyCD = userInfo.CompanyCD;
            //执行查询
            return(SalaryStandardDBHelper.SearchSalaryDetailsReport(model));
        }
示例#14
0
        //薪酬标准登记查询打印的页面
        public ActionResult SalarystandardQuery(int id)
        {
            List <SalaryStandardModel> list = isb.SalaryStandardSelectBy(id);
            SalaryStandardModel        ck   = list[0];
            string dh = ck.Standardid;
            List <SalaryStandardDetailsModel> list2 = isd.SalaryGrantdetailsSelectSID(dh);

            ViewBag.list2 = list2;
            return(View(ck));
        }
 /// <summary>
 /// 保存时基本信息参数设置
 /// </summary>
 /// <param name="comm">命令</param>
 /// <param name="model">保存信息</param>
 private static void SetSaveParameter(SqlCommand comm, SalaryStandardModel model)
 {
     //设置参数
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));   //公司代码
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@QuarterID", model.QuarterID));   //岗位ID
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdminLevel", model.AdminLevel)); //岗位职等
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", model.ItemNo));         //工资项编号
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@UnitPrice", model.UnitPrice));   //金额
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark));         //备注
     comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus)); //启用状态
 }
示例#16
0
        public List <SalaryStandardModel> SalaryStandardFYW(int currentPage, int pageSize, out int rows, string cs, string xcid, string gjz, DateTime?startTime, DateTime?endTime)
        {
            string sql = string.Format("select * from dbo.SalaryStandard where 1=1");

            if (xcid != null && xcid != "")
            {
                sql += string.Format(" and Standardid='{0}'", xcid);
            }
            if (cs != null && cs != "")
            {
                sql += string.Format(" and Checkstatus='{0}'", cs);
            }
            if (gjz != null && gjz != "")
            {
                sql += string.Format(" and Standardname like '%{0}%' or Designer like '%{0}%' or Changer like '%{0}%' or Checker like '%{0}%'", gjz);
            }
            if (startTime != null && endTime != null)
            {
                sql += string.Format(" and Registtime>='{0}' and Registtime<='{1}'", startTime, endTime);
            }
            var list = CreateContext().SalaryStandard.SqlQuery(sql).OrderBy(e => e.Id).ToList();

            rows = list.Count();
            var data = list.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList();
            List <SalaryStandardModel> list2 = new List <SalaryStandardModel>();

            foreach (var p in data)
            {
                SalaryStandardModel sm = new SalaryStandardModel()
                {
                    Id           = p.Id,
                    Standardid   = p.Standardid,
                    Standardname = p.Standardname,
                    Designer     = p.Designer,
                    Register     = p.Register,
                    Checker      = p.Checker,
                    Changer      = p.Changer,
                    Registtime   = p.Registtime,
                    Checktime    = p.Checktime,
                    Changetime   = p.Changetime,
                    Salarysum    = p.Salarysum,
                    Checkstatus  = p.Checkstatus,
                    Changestatus = p.Changestatus,
                    Checkcomment = p.Checkcomment,
                    Remark       = p.Remark
                };
                list2.Add(sm);
            }
            return(list2);
        }
        /// <summary>
        /// 查询工资标准信息
        /// </summary>
        /// <param name="model">查询条件</param>
        /// <returns></returns>
        public static DataTable SearchSalaryStandardReport(SalaryStandardModel model)
        {
            #region 查询语句
            StringBuilder searchSql = new StringBuilder();
            searchSql.AppendLine(" SELECT                                     ");
            searchSql.AppendLine(" 	 ISNULL(A.QuarterID, '') AS QuarterID     ,ISNULL(A.AdminLevel, '') AS AdminLevel   ,ISNULL(D.ItemName, '') AS CompanyCD   ,ISNULL(C.TypeName, '') AS ItemNo  ,sum(A.UnitPrice)AS UnitPrice , ISNULL( b.QuarterName, '') AS Remark ");
            searchSql.AppendLine(" FROM                                       ");
            searchSql.AppendLine(" 	officedba.SalaryStandard A                ");
            searchSql.AppendLine(" 	LEFT JOIN officedba.DeptQuarter B         ");
            searchSql.AppendLine(" 		ON B.companyCD=A.companyCD AND B.ID = A.QuarterID                 ");
            searchSql.AppendLine(" 	LEFT JOIN officedba.CodePublicType C      ");
            searchSql.AppendLine(" 		ON C.companyCD=A.companyCD AND C.ID = A.AdminLevel                ");
            searchSql.AppendLine(" 	LEFT JOIN officedba.SalaryItem D          ");
            searchSql.AppendLine(" 		ON D.companyCD=A.companyCD AND D.ItemNo = A.ItemNo                ");
            searchSql.AppendLine(" WHERE                                      ");
            searchSql.AppendLine(" 	A.CompanyCD = @CompanyCD                  ");
            #endregion

            //定义查询的命令
            SqlCommand comm = new SqlCommand();

            #region 设置参数
            //公司代码
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
            //岗位ID
            if (!string.IsNullOrEmpty(model.QuarterID))
            {
                searchSql.AppendLine("	AND A.QuarterID = @QuarterID ");
                comm.Parameters.Add(SqlHelper.GetParameterFromString("@QuarterID", model.QuarterID));
            }
            //岗位职等
            if (!string.IsNullOrEmpty(model.AdminLevel))
            {
                searchSql.AppendLine("	AND A.AdminLevel = @AdminLevel ");
                comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdminLevel", model.AdminLevel));
            }
            //启用状态
            if (!string.IsNullOrEmpty(model.UsedStatus))
            {
                searchSql.AppendLine("	AND A.UsedStatus = @UsedStatus ");
                comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedStatus", model.UsedStatus));
            }
            #endregion
            searchSql.AppendLine("	group by A.QuarterID,A.AdminLevel,A.ItemNo,D.ItemName ,C.TypeName,b.QuarterName");
            //指定命令的SQL文
            comm.CommandText = searchSql.ToString();
            //执行查询
            return(SqlHelper.ExecuteSearch(comm));
        }
        /// <summary>
        /// 查询工资标准信息
        /// </summary>
        /// <param name="model">查询条件</param>
        /// <returns></returns>
        public static bool CheckSalaryStandardInfo(SalaryStandardModel model)
        {
            #region 查询语句
            StringBuilder searchSql = new StringBuilder();
            searchSql.AppendLine(" SELECT                        ");
            searchSql.AppendLine(" 	 ID                          ");
            searchSql.AppendLine(" FROM                          ");
            searchSql.AppendLine(" 	officedba.SalaryStandard     ");
            searchSql.AppendLine(" WHERE                         ");
            searchSql.AppendLine(" 	CompanyCD = @CompanyCD       ");
            searchSql.AppendLine(" 	AND ItemNo = @ItemNo         ");
            searchSql.AppendLine(" 	AND QuarterID = @QuarterID   ");
            searchSql.AppendLine(" 	AND AdminLevel = @AdminLevel ");

            #endregion

            //定义查询的命令
            SqlCommand comm = new SqlCommand();

            #region 设置参数
            //公司代码
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
            //岗位ID
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@QuarterID", model.QuarterID));
            //岗位职等
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdminLevel", model.AdminLevel));
            //工资编号
            comm.Parameters.Add(SqlHelper.GetParameterFromString("@ItemNo", model.ItemNo));
            #endregion

            //指定命令的SQL文
            comm.CommandText = searchSql.ToString();
            //执行查询

            DataTable dtStandard = SqlHelper.ExecuteSearch(comm);
            if (dtStandard == null || dtStandard.Rows.Count < 1)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
        /// <summary>
        /// 新建工资标准信息
        /// </summary>
        /// <param name="model">工资标准信息</param>
        /// <returns></returns>
        public static bool InsertSalaryStandard(SalaryStandardModel model)
        {
            #region 登陆SQL文
            StringBuilder insertSql = new StringBuilder();
            insertSql.AppendLine(" INSERT INTO             ");
            insertSql.AppendLine(" officedba.SalaryStandard");
            insertSql.AppendLine(" 	(CompanyCD             ");
            insertSql.AppendLine(" 	,QuarterID             ");
            insertSql.AppendLine(" 	,AdminLevel            ");
            insertSql.AppendLine(" 	,ItemNo                ");
            insertSql.AppendLine(" 	,UnitPrice             ");
            insertSql.AppendLine(" 	,Remark                ");
            insertSql.AppendLine(" 	,UsedStatus)           ");
            insertSql.AppendLine(" VALUES                  ");
            insertSql.AppendLine(" 	(@CompanyCD            ");
            insertSql.AppendLine(" 	,@QuarterID            ");
            insertSql.AppendLine(" 	,@AdminLevel           ");
            insertSql.AppendLine(" 	,@ItemNo               ");
            insertSql.AppendLine(" 	,@UnitPrice            ");
            insertSql.AppendLine(" 	,@Remark               ");
            insertSql.AppendLine(" 	,@UsedStatus)          ");
            insertSql.AppendLine("   SET @StandardID= @@IDENTITY  ");
            #endregion

            //定义更新基本信息的命令
            SqlCommand comm = new SqlCommand();
            //设置存储过程名
            comm.CommandText = insertSql.ToString();
            //设置保存的参数
            SetSaveParameter(comm, model);

            //添加返回参数
            comm.Parameters.Add(SqlHelper.GetOutputParameter("@StandardID", SqlDbType.Int));

            //执行登陆操作
            bool isSucc = SqlHelper.ExecuteTransWithCommand(comm);
            //设置ID
            model.ID = comm.Parameters["@StandardID"].Value.ToString();

            //执行插入并返回插入结果
            return(isSucc);
        }
示例#20
0
        public int SalaryStandardDelete(SalaryStandardModel ck)
        {
            SalaryStandard ssd = new SalaryStandard();

            ssd.Standardid   = ck.Standardid;
            ssd.Standardname = ck.Standardname;
            ssd.Designer     = ck.Designer;
            ssd.Register     = ck.Register;
            ssd.Checker      = ck.Checker;
            ssd.Changer      = ck.Changer;
            ssd.Registtime   = ck.Registtime;
            ssd.Checktime    = ck.Checktime;
            ssd.Changetime   = ck.Changetime;
            ssd.Salarysum    = ck.Salarysum;
            ssd.Checkstatus  = ck.Checkstatus;
            ssd.Changestatus = ck.Changestatus;
            ssd.Checkcomment = ck.Checkcomment;
            ssd.Remark       = ck.Remark;
            ssd.Id           = ck.Id;
            return(Delete(ssd));
        }
示例#21
0
        public ActionResult Add()
        {
            //基本信息
            SalaryStandardModel ssm = new SalaryStandardModel();

            ssm.Standardid   = Request["Standardid"];
            ssm.Standardname = Request["Standardname"];
            ssm.Salarysum    = Request["Salarysum"] == null || Request["Salarysum"] == "" ? ssm.Salarysum : Convert.ToDecimal(Request["Salarysum"]);
            ssm.Designer     = Request["Designer"];
            ssm.Register     = Request["Register"];
            ssm.Registtime   = DateTime.Parse(Request["Registtime"]);
            ssm.Remark       = Request["Remark"];
            int r1 = isb.SalaryStandardAdd(ssm);
            //详情信息
            string arry = Request["arry"];
            List <Dictionary <string, object> > sdm = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(arry);
            int r2 = 0;

            foreach (var item in sdm)
            {
                SalaryStandardDetailsModel sd = new SalaryStandardDetailsModel();
                sd.Itemid       = int.Parse(item["id"].ToString());
                sd.Itemname     = item["names"].ToString();
                sd.Standardid   = Request["Standardid"];
                sd.Standardname = Request["Standardname"];
                sd.Salary       = item["money"] == null || item["money"] == "" ? sd.Salary : Convert.ToDecimal(item["money"]);
                if (isd.SalaryStandardDetailsAdd(sd) > 0)
                {
                    r2++;
                }
            }
            string flag = "false";

            if (r1 > 0 && r2 == sdm.Count)
            {
                flag = "true";
            }
            return(Content(flag));
        }
示例#22
0
 public int SalaryStandardAdd(SalaryStandardModel ckm)
 {
     return(isd.SalaryStandardAdd(ckm));
 }
示例#23
0
 public int SalaryStandardUpdate2(SalaryStandardModel ck)
 {
     return(isd.SalaryStandardUpdate2(ck));
 }
示例#24
0
    private void Search()
    {
        SalaryStandardModel searchModel = new SalaryStandardModel();

        //设置查询条件
        //岗位

        if (ddlDeptName.SelectedValue != "0")
        {
            searchModel.QuarterID = ddlDeptName.SelectedValue;
        }
        if (this.ddlStartMonth.SelectedValue != "0")//起始月份
        {
            searchModel.AdminLevel = ddlStartMonth.SelectedValue;
        }
        if (this.ddlEndMonth.SelectedValue != "0")//结束月份
        {
            searchModel.AdminLevelName = ddlEndMonth.SelectedValue;
        }
        if (this.ddlYear.SelectedValue != "0")//结束月份
        {
            searchModel.UnitPrice = ddlYear.SelectedValue;
        }
        searchModel.UsedStatus = txtSearchEmployee.Value;
        UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
        //查询数据
        DataTable dtNewTable = SalaryStandardBus.SearchSalaryDetailsReport(searchModel);
        DataTable dtData     = new DataTable();

        dtData.Columns.Add("WorkMoney");    //部门
        dtData.Columns.Add("CompanyCD");    //月份
        dtData.Columns.Add("EmployeeID");   //人员编号
        dtData.Columns.Add("ReprotNo");     //人员姓名
        dtData.Columns.Add("FixedMoney");   //岗位
        dtData.Columns.Add("TimeMoney");    //职等
        dtData.Columns.Add("AllGetMoney");  //应发工资
        dtData.Columns.Add("AllKillMoney"); //应扣工资
        dtData.Columns.Add("SalaryMoney");  //实发工资

        for (int i = 0; i < dtNewTable.Rows.Count; i++)
        {
            DataTable dt     = SalaryStandardBus.GetEmployeeDetailsOutTime(dtNewTable.Rows[i]["EmployeeID"] == null ? "" : dtNewTable.Rows[i]["EmployeeID"].ToString(), dtNewTable.Rows[i]["DeptID"] == null ? "" : dtNewTable.Rows[i]["DeptID"].ToString(), dtNewTable.Rows[i]["ReprotNo"] == null ? "" : dtNewTable.Rows[i]["ReprotNo"].ToString());
            DataRow   newRow = dtData.NewRow();
            newRow["WorkMoney"]  = dt.Rows[0]["DeptName"] == null ? "" : dt.Rows[0]["DeptName"].ToString();
            newRow["CompanyCD"]  = dtNewTable.Rows[i]["ReportMonth"] == null ? "" : dtNewTable.Rows[i]["ReportMonth"].ToString();
            newRow["EmployeeID"] = dt.Rows[0]["EmployeeName"] == null ? "" : dt.Rows[0]["EmployeeName"].ToString();
            newRow["FixedMoney"] = dt.Rows[0]["TimeMoney"] == null ? "" : dt.Rows[0]["TimeMoney"].ToString();
            dtData.Rows.Add(newRow);
        }


        ReportDocument oRpt = new ReportDocument();

        CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/SalaryWorkByTime.rpt"));
        // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名
        CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary"));
        //查询数据
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text         = "\"" + "制表人:" + userInfo.EmployeeName + "\"";
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["DeptName"].Text        = "\"" + "起始年月:" + ddlYear.SelectedValue + "." + ddlStartMonth.SelectedValue + "\"";
        CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["PerformanceType"].Text = "\"" + "结束年月:" + ddlYear.SelectedValue + "." + ddlEndMonth.SelectedValue + "\"";
        CrystalReportSource1.ReportDocument.SetDataSource(dtData);
        CrystalReportSource1.DataBind();
        // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像
        CrystalReportViewer1.ReportSource = CrystalReportSource1;
        //  CrystalReportViewer1.DataBind();
    }
示例#25
0
        /// <summary>
        /// 编辑工资标准信息
        /// </summary>
        /// <param name="model">保存信息</param>
        /// <returns></returns>
        public static bool SaveSalaryStandard(SalaryStandardModel model)
        {
            //获取登陆用户信息
            UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];

            //设置公司代码
            model.CompanyCD = userInfo.CompanyCD;
            //定义返回变量
            bool isSucc = false;
            //操作日志
            LogInfoModel logModel = InitLogInfo(model.ID);

            //更新
            if (!string.IsNullOrEmpty(model.ID))
            {
                try
                {
                    logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
                    //执行更新操作
                    isSucc = SalaryStandardDBHelper.UpdateSalaryStandard(model);
                }
                catch (Exception ex)
                {
                    //输出系统日志
                    WriteSystemLog(userInfo, ex);
                }
            }
            //插入
            else
            {
                try
                {
                    logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
                    //执行插入操作
                    isSucc = SalaryStandardDBHelper.InsertSalaryStandard(model);
                    //操作单据编号
                    logModel.ObjectID = model.ID;
                }
                catch (Exception ex)
                {
                    //输出系统日志
                    WriteSystemLog(userInfo, ex);
                }
            }
            //更新成功时
            if (isSucc)
            {
                //设置操作成功标识
                logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
            }
            //更新不成功
            else
            {
                //设置操作成功标识
                logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
            }

            //登陆日志
            LogDBHelper.InsertLog(logModel);

            return(isSucc);
        }
示例#26
0
 public int SalaryStandardUpdate(SalaryStandardModel ckm)
 {
     return(isd.SalaryStandardUpdate(ckm));
 }
示例#27
0
 /// <summary>
 /// 计时工资走势分析明细页面
 /// </summary>
 /// <param name="CompanyCD"></param>
 /// <param name="DeptID"></param>
 /// <param name="pageIndex"></param>
 /// <param name="pageCount"></param>
 /// <param name="ord"></param>
 /// <param name="TotalCount"></param>
 /// <returns></returns>
 public static DataTable DeptTimeReportPrintSelect(SalaryStandardModel model, int pageIndex, int pageCount, string ord, ref int totalCount)
 {
     return(HumanReportDBHelper.DeptTimeReportPrintSelect(model, pageIndex, pageCount, ord, ref totalCount));
 }
示例#28
0
 /// <summary>
 /// 部门工资明细统计
 /// </summary>
 /// <param name="CompanyCD"></param>
 /// <param name="DeptID"></param>
 /// <param name="pageIndex"></param>
 /// <param name="pageCount"></param>
 /// <param name="ord"></param>
 /// <param name="TotalCount"></param>
 /// <returns></returns>
 public static DataTable SalarySummerySelect(SalaryStandardModel searchModel, int pageIndex, int pageCount, string ord, ref int TotalCount)
 {
     return(HumanReportDBHelper.SalarySummerySelect(searchModel, pageIndex, pageCount, ord, ref TotalCount));
 }