source/System.DAL/System/DAL/GzItemDAL.cs

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

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

namespace System.DAL
{
    using Maticsoft.DBUtility;
    using MicroSoft.EnterpriseLibrary.Data;
    using System;
    using System.Collections;
    using System.Data;
    using System.Data.SqlClient;
    using System.Model;
    using System.Text;

    public class GzItemDAL
    {
        public static int Add(GzItemInfo model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SYS_GZITEM(");
            strSql.Append("code,itemname,usestate,seq,xmstate,xmconn)");
            strSql.Append(" values (");
            strSql.Append("@code,@itemname,@usestate,@seq,@xmstate,@xmconn)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@code", SqlDbType.Char, 4), new SqlParameter("@itemname", SqlDbType.VarChar, 50), new SqlParameter("@usestate", SqlDbType.Char, 1), new SqlParameter("@seq", SqlDbType.Int, 4), new SqlParameter("@xmstate", SqlDbType.Char, 1), new SqlParameter("@xmconn", SqlDbType.Char, 1) };
            parameters[0].Value = model.code;
            parameters[1].Value = model.itemname;
            parameters[2].Value = model.usestate;
            parameters[3].Value = model.seq;
            parameters[4].Value = model.xmstate;
            parameters[5].Value = model.xmconn;
            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            return Convert.ToInt32(obj);
        }

        public static string CreateMonthList(string jgcode, string year)
        {
            string result = string.Empty;
            try
            {
                result = SqlDataProvider.GetResultByProc("CreateGZMonthList", new object[] { jgcode, int.Parse(year) }).Tables[0].Rows[0][0].ToString();
            }
            catch
            {
            }
            return result;
        }

        public static bool DelGzEmpList(string jgcode, string year, string month)
        {
            month = (month.Length < 1) ? ("0" + month) : month;
            string gzdate = year + "-" + month + "-01";
            return (SqlDataProvider.ExecuteBySql("delete from YW_GZDETAILS where jfny=@jfny and jgcode=@jgcode", new SqlParameter[] { SqlDataProvider.CreateSqlParameter("@jfny", SqlDbType.VarChar, gzdate), SqlDataProvider.CreateSqlParameter("@jgcode", SqlDbType.VarChar, jgcode) }) > 0);
        }

        public static bool DelGzEmpList(string empcode, string jgcode, string year, string month)
        {
            month = (month.Length < 1) ? ("0" + month) : month;
            string gzdate = year + "-" + month + "-01";