Beispiel #1
0
        public IList <T_ReportApplication> ListMaker(string tempsql, SqlParameter[] sps)
        {
            DataTable dt = DataHelper.GetDataTable(tempsql, sps, false);
            IList <T_ReportApplication> list = new List <T_ReportApplication>();

            foreach (DataRow dr in dt.Rows)
            {
                T_ReportApplication model = new T_ReportApplication();
                model.ReportAppCode  = dr["ReportAppCode"].ToString();
                model.NOTE2          = dr["NOTE2"].ToString();
                model.NOTE3          = dr["NOTE3"].ToString();
                model.NOTE4          = dr["NOTE4"].ToString();
                model.NOTE5          = dr["NOTE5"].ToString();
                model.NOTE6          = dr["NOTE6"].ToString();
                model.NOTE7          = dr["NOTE7"].ToString();
                model.NOTE8          = dr["NOTE8"].ToString();
                model.NOTE9          = dr["NOTE9"].ToString();
                model.NOTE0          = dr["NOTE0"].ToString();
                model.ReportName     = dr["ReportName"].ToString();
                model.ReportNameCode = dr["ReportNameCode"].ToString();
                model.ReportDeptCode = dr["ReportDeptCode"].ToString();
                model.ReportDeptName = dr["ReportDeptName"].ToString();
                model.ReportDate     = dr["ReportDate"].ToString();
                model.ReportExplain  = dr["ReportExplain"].ToString();
                model.ReportRemark   = dr["ReportRemark"].ToString();
                model.NOTE1          = dr["NOTE1"].ToString();

                list.Add(model);
            }
            return(list);
        }
Beispiel #2
0
        public DataTable getallmode(T_ReportApplication model)
        {
            StringBuilder strSql    = new StringBuilder();
            List <object> objParams = new List <object>();

            strSql.Append(@"select a.* ,('['+ReportNameCode+']'+ReportName)as username,('['+ReportDeptCode+']'+ReportDeptName)as deptnames from dbo.T_ReportApplication a where 1=1");

            //////申请单号
            //if (model.Billcode != null && model.Billcode != "")
            //{
            //    strSql.Append(" and a.Billcode like '%" + model.Billcode + "%' ");
            //}
            strSql.Append(" order by ReportDate desc");

            return(DataHelper.GetDataTable(strSql.ToString(), null, false));
        }
Beispiel #3
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public T_ReportApplication GetModel(string ReportAppCode)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append(sql);
            strSql.Append(" where ReportAppCode=@ReportAppCode ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ReportAppCode", SqlDbType.NVarChar, 50)
            };
            parameters[0].Value = ReportAppCode;


            T_ReportApplication model = new T_ReportApplication();

            using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters))
            {
                if (dr.Read())
                {
                    model.ReportAppCode  = dr["ReportAppCode"].ToString();
                    model.NOTE2          = dr["NOTE2"].ToString();
                    model.NOTE3          = dr["NOTE3"].ToString();
                    model.NOTE4          = dr["NOTE4"].ToString();
                    model.NOTE5          = dr["NOTE5"].ToString();
                    model.NOTE6          = dr["NOTE6"].ToString();
                    model.NOTE7          = dr["NOTE7"].ToString();
                    model.NOTE8          = dr["NOTE8"].ToString();
                    model.NOTE9          = dr["NOTE9"].ToString();
                    model.NOTE0          = dr["NOTE0"].ToString();
                    model.ReportName     = dr["ReportName"].ToString();
                    model.ReportNameCode = dr["ReportNameCode"].ToString();
                    model.ReportDeptCode = dr["ReportDeptCode"].ToString();
                    model.ReportDeptName = dr["ReportDeptName"].ToString();
                    model.ReportDate     = dr["ReportDate"].ToString();
                    model.ReportExplain  = dr["ReportExplain"].ToString();
                    model.ReportRemark   = dr["ReportRemark"].ToString();
                    model.NOTE1          = dr["NOTE1"].ToString();

                    return(model);
                }
                else
                {
                    return(null);
                }
            }
        }
Beispiel #4
0
 public int Add(T_ReportApplication model)
 {
     using (SqlConnection conn = new SqlConnection(DataHelper.constr))
     {
         conn.Open();
         SqlTransaction tran = conn.BeginTransaction();
         try
         {
             int row = Add(model, tran);
             tran.Commit();
             return(row);
         }
         catch
         {
             tran.Rollback();
             throw;
         }
     }
 }
Beispiel #5
0
 /// <summary>
 /// 添加
 /// </summary>
 /// <returns></returns>
 public int Addmodel(T_ReportApplication model)
 {
     return(dal.Add(model));
 }
Beispiel #6
0
 public DataTable getalltable(T_ReportApplication model)
 {
     return(dal.getallmode(model));
 }
Beispiel #7
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(T_ReportApplication model, SqlTransaction tran)
        {
            Delete(model.ReportAppCode, tran);
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into T_ReportApplication(");
            strSql.Append("ReportAppCode,NOTE2,NOTE3,NOTE4,NOTE5,NOTE6,NOTE7,NOTE8,NOTE9,NOTE0,ReportName,ReportNameCode,ReportDeptCode,ReportDeptName,ReportDate,ReportExplain,ReportRemark,NOTE1");
            strSql.Append(") values (");
            strSql.Append("@ReportAppCode,@NOTE2,@NOTE3,@NOTE4,@NOTE5,@NOTE6,@NOTE7,@NOTE8,@NOTE9,@NOTE0,@ReportName,@ReportNameCode,@ReportDeptCode,@ReportDeptName,@ReportDate,@ReportExplain,@ReportRemark,@NOTE1");
            strSql.Append(") ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ReportAppCode",  SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE2",          SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE3",          SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE4",          SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE5",          SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE6",          SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE7",          SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE8",          SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE9",          SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE0",          SqlDbType.NVarChar, 50),
                new SqlParameter("@ReportName",     SqlDbType.NVarChar, 50),
                new SqlParameter("@ReportNameCode", SqlDbType.NVarChar, 50),
                new SqlParameter("@ReportDeptCode", SqlDbType.NVarChar, 50),
                new SqlParameter("@ReportDeptName", SqlDbType.NVarChar, 50),
                new SqlParameter("@ReportDate",     SqlDbType.NVarChar, 50),
                new SqlParameter("@ReportExplain",  SqlDbType.NVarChar, 50),
                new SqlParameter("@ReportRemark",   SqlDbType.NVarChar, 50),
                new SqlParameter("@NOTE1",          SqlDbType.NVarChar, 50)
            };

            parameters[0].Value = SqlNull(model.ReportAppCode);

            parameters[1].Value = SqlNull(model.NOTE2);

            parameters[2].Value = SqlNull(model.NOTE3);

            parameters[3].Value = SqlNull(model.NOTE4);

            parameters[4].Value = SqlNull(model.NOTE5);

            parameters[5].Value = SqlNull(model.NOTE6);

            parameters[6].Value = SqlNull(model.NOTE7);

            parameters[7].Value = SqlNull(model.NOTE8);

            parameters[8].Value = SqlNull(model.NOTE9);

            parameters[9].Value = SqlNull(model.NOTE0);

            parameters[10].Value = SqlNull(model.ReportName);

            parameters[11].Value = SqlNull(model.ReportNameCode);

            parameters[12].Value = SqlNull(model.ReportDeptCode);

            parameters[13].Value = SqlNull(model.ReportDeptName);

            parameters[14].Value = SqlNull(model.ReportDate);

            parameters[15].Value = SqlNull(model.ReportExplain);

            parameters[16].Value = SqlNull(model.ReportRemark);

            parameters[17].Value = SqlNull(model.NOTE1);


            return(DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false));
        }