OrderTemplate/Dal/Template.cs

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

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

using System;
using System.Data;
using Common;

namespace OrderTemplate.Dal
{
    /// <summary>
    /// 单据模板
    /// </summary>
    /// <remarks></remarks>
    internal class Template
    {
        private string str;
        /// <summary>
        /// 创建实例
        /// </summary>
        /// <returns></returns>
        /// <remarks></remarks>
        public static Template Create()
        {
            return new Template();
        }

        public void Delete(int TemplateId, System.Data.Common.DbCommand cmd)
        {
            str = "delete from __OrderTemplate where TemplateId=" + TemplateId;
            DataBase.execCmd(str, cmd);
        }

        public void Insert(Model.TemplateInfo mdl, System.Data.Common.DbCommand cmd)
        {
            str = "insert into __OrderTemplate(cOrderId,cTemplateName)values(" + DataBase.getString(mdl.Nuke().A02_cOrderId) + "," + DataBase.getString(mdl.Nuke().A03_cTemplateName) + ")";
            DataBase.execCmd(str, cmd);
        }

        public void Update(Model.TemplateInfo mdl, System.Data.Common.DbCommand cmd)
        {
            str = "update __OrderTemplate set cOrderId=" + DataBase.getString(mdl.Nuke().A02_cOrderId) + ",cTemplateName=" + DataBase.getString(mdl.Nuke().A03_cTemplateName) + " where TemplateId=" + mdl.Nuke().A01_TemplateId;
            DataBase.execCmd(str, cmd);
        }

        public Model.TemplateInfoCollection Query(System.Data.Common.DbCommand cmd)
        {
            return myQuery("", cmd);
        }

        public Model.TemplateInfoCollection Query(string cOrderId, System.Data.Common.DbCommand cmd)
        {
            string Filter = "cOrderId=" + DataBase.getString(cOrderId);
            return myQuery(Filter, cmd);
        }

        public Model.TemplateInfo Query(int TemplateId, System.Data.Common.DbCommand cmd)
        {
            string Filter = "TemplateId=" + TemplateId;
            Model.TemplateInfoCollection mdls = myQuery(Filter, cmd);
            if (mdls.Count != 0)
            {
                return mdls[0];
            }