WageView/Functions.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;

/// <summary>
/// 公共函数
/// </summary>
/// <remarks></remarks>
namespace WageView
{
    internal class Functions
    {
        /// <summary>
        /// 获取人员工资
        /// </summary>
        /// <param name="cPsnCode"></param>
        /// <param name="cWageName"></param>
        /// <returns></returns>
        /// <remarks></remarks>
        public static double getPersonWage(string cPsnCode, string cWageName)
        {
            try
            {
                string str = "select iValue from WA_WageDefault where cPsnCode='" + cPsnCode + "' and cWageName='" + cWageName + "'";
                return Common.ConvertData.todbl(Common.DataBase.execCmd(str));
            }
            catch (Exception ex)
            {
                Common.Debug.myMsg(ex.Message, "");
                return 0;
            }
        }
        /// <summary>
        /// 保存人员工资
        /// </summary>
        /// <param name="cPsnCode"></param>
        /// <param name="cWageName"></param>
        /// <param name="iValue"></param>
        /// <remarks></remarks>
        public static void SavePersonWage(string cPsnCode, string cWageName, double iValue)
        {
            string str;
            try
            {
                str = "delete from WA_WageDefault where cPsnCode='" + cPsnCode + "' and cWageName='" + cWageName + "'";
                Common.DataBase.execCmd(str);
                str = "insert into WA_WageDefault(cPsnCode,cWageName,iValue)values('" + cPsnCode + "','" + cWageName + "'," + iValue + ")";
                Common.DataBase.execCmd(str);
            }
            catch (Exception ex)
            {
                Common.Debug.myMsg(ex.Message, "");
            }
        }
        /// <summary>
        /// 指定月份的工资表是否已审核
        /// </summary>
        /// <param name="cWTCode"></param>
        /// <param name="iYear"></param>
        /// <param name="iMonth"></param>
        /// <returns></returns>