source/System.DAL/System/DAL/JfitemDAL.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 JfitemDAL
    {
        public static int Add(JfitemInfo model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SYS_JFITEM(");
            strSql.Append("jgcode,jfxm,sftj,itemvalue,cjrq,jfmlbh,seq)");
            strSql.Append(" values (");
            strSql.Append("@jgcode,@jfxm,@sftj,@itemvalue,@cjrq,@jfmlbh,@seq)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@jgcode", SqlDbType.Int, 4), new SqlParameter("@jfxm", SqlDbType.VarChar, 100), new SqlParameter("@sftj", SqlDbType.Char, 1), new SqlParameter("@itemvalue", SqlDbType.Decimal, 13), new SqlParameter("@cjrq", SqlDbType.DateTime), new SqlParameter("@jfmlbh", SqlDbType.Int, 4), new SqlParameter("@seq", SqlDbType.Int, 4) };
            parameters[0].Value = model.jgcode;
            parameters[1].Value = model.jfxm;
            parameters[2].Value = model.sftj;
            parameters[3].Value = model.itemvalue;
            parameters[4].Value = model.cjrq;
            parameters[5].Value = model.jfmlbh;
            parameters[6].Value = model.seq;
            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            return Convert.ToInt32(obj);
        }

        public static string CheckMonth(string jgcode, string year, string month)
        {
            string result = string.Empty;
            try
            {
                DataSet ds = SqlDataProvider.GetResultBySql("select code from SYS_MONTHLIST where jgcode=@jgcode and datepart(yy,jfyy)=@year and datepart(MM,jfyy)=@month and sfqr=1", new SqlParameter[] { SqlDataProvider.CreateSqlParameter("@jgcode", SqlDbType.VarChar, jgcode), SqlDataProvider.CreateSqlParameter("@year", SqlDbType.VarChar, year), SqlDataProvider.CreateSqlParameter("@month", SqlDbType.VarChar, month) });
                if (((ds != null) && (ds.Tables.Count > 0)) && (ds.Tables[0].Rows.Count > 0))
                {
                    result = "1";
                    DataSet itemds = SqlDataProvider.GetResultBySql("select * from dbo.SYS_JFITEM where jfmlbh=" + ds.Tables[0].Rows[0][0].ToString(), new SqlParameter[0]);
                    if (((itemds != null) && (itemds.Tables.Count > 0)) && (itemds.Tables[0].Rows.Count > 0))
                    {
                        return "3";
                    }
                    return "4";
                }
                return "2";
            }
            catch
            {
                return "-1";
            }
        }