ZLPMS/Assemblys/Templates/ModelService.t

/***************以下代码由原型工具自动生成****************
 *如有需要请自行修改
 *create:${model.CreateUser}
 *date:${model.CreateDate}
 *version:1.0
 *********************************************************/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using QWPlatform.DataIntface;
using QWPlatform.IService; 

namespace ${model.NameSpace}
{
    public class ${model.ClassName}Service : DataServiceBase
    {
        /// <summary>
        /// 重写数据工厂
        /// </summary>
        /// <param name="conName"></param>
        protected override void DBFctory(string conName)
        {
            base.DBFctory(conName);
        }

        /// <summary>
        /// 增加数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(${model.ClassName} model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            return model.Insert();
        }

        /// <summary>
        /// 增加数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Add(${model.ClassName} model, ITransaction trans)
        {
            model.SetDataFactory(this.DataFactoryObject);
            if(trans==null){
                return model.Insert();
            }else{
                return model.Insert(trans);
            }
        }

        /// <summary>
        /// 更新数据库记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Update(${model.ClassName} model)
        {
		    model.SetDataFactory(this.DataFactoryObject);

            //更新方式1
			/*********************************************
            List<string> where = new List<string>();
            where.Add("ID");

            return model.Update(where, string.Empty);
			********************************************/

			//where可以指定列名称， update参数可以指定更新列
			return mode.Where("ID").Update();

        }


        /// <summary>
        /// 更新数据库记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Update(${model.ClassName} model, ITransaction trans)
        {
            model.SetDataFactory(this.DataFactoryObject);
			 
            if(trans==null){
                return model.Where("ID").Update(string.Empty);
            }else{
                return model.Where("ID").Update(trans, string.Empty)
            }
        }

        /// <summary>
        /// 删除数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Delete(${model.ClassName} model)
        {
            model.SetDataFactory(this.DataFactoryObject);

            return model.Delete("ID");
        }

		/// <summary>
        /// 删除数据记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int Delete(${model.ClassName} model, ITransaction trans)
        {
            model.SetDataFactory(this.DataFactoryObject);
            if(trans==null){
                return model.Delete("ID");
            }else{
                return model.Delete(trans,"ID");
            }
        }

        /// <summary>
        /// 查询数据对象并进行赋值
        /// </summary>
        /// <returns></returns>
        public ${model.ClassName} Select(${model.ClassName} model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            model.Select();
            return model;
        }

        /// <summary>
        /// 列表查询
        /// </summary>
        /// <returns></returns>
        public List<${model.ClassName}> SelectList(${model.ClassName} model)
        {
            model.SetDataFactory(this.DataFactoryObject);
            return model.SelectList<${model.ClassName}>();
        }
    }
}