test/Member/CoreEntity/DAL/OrgDAL.cs

using Common.Model;
using CoreEntity.Entity;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using ZcPeng.PublicLibrary;

namespace CoreEntity.DAL
{
    public class OrgDAL
    {

        public static string GetOrgNo(string OrgId,string EntId)
        {
            string id = "";
            #region 查id

            string commandTextUser = "Select OrgNo From  "
            + "OrgDoc Where OrgId=@OrgId and EntId=@EntId";
            string resultUser;
            DataTable dt = new DataTable();

            List<List<Object>> parametersUser = new List<List<Object>>();
            parametersUser.Add(new List<Object>() { "OrgId", OrgId });
            parametersUser.Add(new List<Object>() { "EntId", EntId });
            DataAccess.GetValues(commandTextUser, ref dt, DataAccess.ToParameters(parametersUser).ToArray(), out resultUser);
            List<OrgDoc> users = new List<OrgDoc>(0);

            if(dt!=null && dt.Rows.Count > 0) { 
            users = (List<OrgDoc>)ModelConvertHelper<OrgDoc>.ConvertToModel(dt);
            OrgDoc user = users.ToArray()[0];

            id = user.ORGNO;
            }
            #endregion

            return id;
        }


        public static List<OrgDoc> getOrg(string EntId = "E1WB67UEYPG",string filter = "")
        {
            DataTable dt = new DataTable();
            string commandTextSupp = "Select * From OrgDoc where EntId=@EntId " +
                "" + filter;
            string resultSupp;

            List<List<Object>> parametersSupp = new List<List<Object>>(1);
            parametersSupp.Add(new List<Object>() { "EntId", EntId });
            DataAccess.GetValues(commandTextSupp, ref dt, DataAccess.ToParameters(parametersSupp).ToArray(), out resultSupp);
            
            if (dt!=null && dt.Rows.Count > 0)
            {
                List<OrgDoc> suplist = (List<OrgDoc>)ModelConvertHelper<OrgDoc>.ConvertToModel(dt);
                return suplist;
            }
            return null;
        }
    }
}