MyOAExx/OA.DAL/DepartInfoService.cs

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

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

//============================================================
// Producnt name:		TenXiang.Code
// Coded by:			hotboart
// Auto generated at: 	2014/1/5 11:45:28
//============================================================



using System;						
using System.Collections.Generic;	
using System.Text;					
using System.Data;					
using System.Data.SqlClient;		
using OA.Models;



namespace OA.DAL
{								

	public static partial class DepartInfoService
	{	
		//Add Mothed Start
		public static readonly string InsertSql = "INSERT DepartInfo (DepartName, PrincipalUser, ConnectTelNo, ConnectMobileTelNo, Faxes, BranchId)VALUES (@DepartName, @PrincipalUser, @ConnectTelNo, @ConnectMobileTelNo, @Faxes, @BranchId)";
		public static readonly string UpdateSql = "Update DepartInfo set DepartName=@DepartName, PrincipalUser=@PrincipalUser, ConnectTelNo=@ConnectTelNo, ConnectMobileTelNo=@ConnectMobileTelNo, Faxes=@Faxes, BranchId=@BranchId where DepartId=@DepartId";
		public static readonly string DeleteSql = "Delete FROM DepartInfo  where DepartId=@DepartId";
		public static readonly string SelectSql = "Select * FROM DepartInfo";
		public static readonly string SelectSqlById = "Select * FROM DepartInfo where DepartId =@DepartId";
        /// <summary>
        /// 根据部门机构查询
        /// </summary>
        /// <param name="name">机构</param>
        /// <param name="branch">部门</param>
        /// <returns></returns>
        public static IList<DepartInfo> GetDepByNameList(string name, int branch)
        {
            string sql = "";
            if (branch == 0)
            {
                sql = "Select * FROM DepartInfo where DepartName like @DepartName";
            }
            else
            {
                sql = "Select * FROM DepartInfo where DepartName like @DepartName and BranchId=@BranchId";
            }
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@DepartName","%"+name+"%"),  new SqlParameter("@BranchId",branch)
								  };
            return GetListBySql(sql, para);
        }
        
        public static int AddDepartInfo(DepartInfo departInfo)
	    {								
			string sql = InsertSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@DepartName",departInfo.DepartName), new SqlParameter("@PrincipalUser",departInfo.PrincipalUser), new SqlParameter("@ConnectTelNo",departInfo.ConnectTelNo), new SqlParameter("@ConnectMobileTelNo",departInfo.ConnectMobileTelNo), new SqlParameter("@Faxes",departInfo.Faxes), new SqlParameter("@BranchId",departInfo.BranchId)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);