Print/Dal/Line.cs

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

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

using System;
using System.Data;
using Common;

namespace Print.Dal
{
    /// <summary>
    /// 直线
    /// </summary>
    /// <remarks></remarks>
    internal class Line
    {
        private string str;
        /// <summary>
        /// 创建实例
        /// </summary>
        /// <returns></returns>
        /// <remarks></remarks>
        public static Line Create()
        {
            return new Line();
        }

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

        public void Insert(Model.LineInfo mdl, System.Data.Common.DbCommand cmd)
        {
            str = "insert into __PrintTemplateLine(TemplateId,x1,y1,x2,y2)values(" + mdl.Nuke().A02_TemplateId + "," + mdl.Nuke().A03_x1 + "," + mdl.Nuke().A04_y1 + "," + mdl.Nuke().A05_x2 + "," + mdl.Nuke().A06_y2 + ")";
            DataBase.execCmd(str, cmd);
        }

        public void OnUpdate(Model.LineInfo mdl, System.Data.Common.DbCommand cmd)
        {
            str = "Update __PrintTemplateLine set TemplateId=" + mdl.Nuke().A02_TemplateId + ",x1=" + mdl.Nuke().A03_x1 + ",y1=" + mdl.Nuke().A04_y1 + ",x2=" + mdl.Nuke().A05_x2 + ",y2=" + mdl.Nuke().A06_y2 + " where Id=" + mdl.Nuke().A01_Id;
            DataBase.execCmd(str, cmd);
        }

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

        public Model.LineInfoCollection Query(int TemplateId, System.Data.Common.DbCommand cmd)
        {
            string Filter = "TemplateId=" + TemplateId;
            return myQuery(Filter, cmd);
        }

        private Model.LineInfoCollection myQuery(string Filter, System.Data.Common.DbCommand cmd)
        {
            str = "select Id,TemplateId,x1,y1,x2,y2 from __PrintTemplateLine";
            if (Filter != "")
            {
                str += " where " + Filter;
            }
            str += " order by Id";