using System;
|
using System.Text;
|
using System.Data;
|
using System.Data.Common;
|
using CSFramework.DB;
|
using CSFrameworkV5.Models;
|
using CSFrameworkV5.Common;
|
using CSFrameworkV5.Core;
|
using CSFrameworkV5.DataAccess;
|
using CSFrameworkV5.Core.CodeGenerator;
|
using CSFrameworkV5.Interfaces;
|
|
/*===================================================================
|
* 程序说明: MES_Order的数据访问层源码
|
* 作者资料: 孙中吕
|
* 创建日期: 2024/05/21 03:13:43
|
* 最后修改: 2024/05/21 03:13:43
|
*
|
* 注: 本文件由代码生成器(Code Generator)自动生成。
|
* (此源码文件请放置在 YourProject.DataAccess 模块)
|
* 版权所有 Copyright 2006~2024, C/S框架网(www.cscode.net)
|
*===================================================================*/
|
|
namespace CSFrameworkV5.DataAccess
|
{
|
/// <summary>
|
/// DAL数据层:dalWorkOrder
|
/// </summary>
|
public class dalWorkOrder : dalBaseBusiness
|
{
|
/// <summary>
|
/// 构造器
|
/// </summary>
|
/// <param name="loginer">当前登录用户</param>
|
public dalWorkOrder(Loginer loginer) : base(loginer)
|
{
|
_SummaryKeyName = MES_Order.__KeyName; //主表的主键字段
|
_SummaryTableName = MES_Order.__TableName; //主表表名
|
_UpdateSummaryKeyMode = UpdateKeyMode.None;
|
_ReplaceString = false;
|
}
|
|
/// <summary>
|
/// 根据表名获取该表的SQL命令生成器
|
/// </summary>
|
/// <param name="tableName">表名</param>
|
/// <returns></returns>
|
protected override IGenerateSqlCommand CreateSqlGenerator(
|
DataTable table)
|
{
|
Type ORM = null;
|
if (table.TableName == MES_Order.__TableName)
|
ORM = typeof(MES_Order); //主表ORM对应关系
|
if (table.TableName == DA01IMAGE.__TableName)
|
ORM = typeof(DA01IMAGE); //明细表ORM对应关系
|
|
if (ORM == null)
|
throw new Exception(table.TableName + "表没有ORM模型，请生成此表的Model类！");
|
return new GenerateSqlCmdByTableFields(ORM, table,
|
GeneratorFactory);
|
}
|
|
|
/// <summary>
|
/// 查询功能，获取主表数据。此方法的参数仅供参考
|
/// </summary>
|
public DataTable Query(QueryMES_Order P)
|
{
|
var sp = _Database.CreateSqlProc("usp_MES_Order_Query");
|
sp.AddParam("daa001", DbType.String, P.daa001);
|
sp.AddParam("create_by", DbType.String, P.create_by);
|
return _Database.GetTable(sp.Command, MES_Order.__TableName);
|
}
|
|
/// <summary>
|
/// 获取报表数据
|
/// </summary>
|
/// <returns></returns>
|
public DataSet QueryReportData(QueryMES_Order P)
|
{
|
throw new NotImplementedException("QueryReportData");
|
}
|
|
//实现接口提供的基础查询方法
|
public DataTable Query(QueryBusinessBase P)
|
{
|
return Query(P as QueryMES_Order);
|
}
|
|
//实现接口提供的基础查询方法
|
public DataSet QueryReportData(QueryBusinessBase P)
|
{
|
return QueryReportData(P as QueryMES_Order);
|
}
|
|
/// <summary>
|
/// 获取一张业务单据的数据，包括一条主表记录及(多张)明细表
|
/// </summary>
|
/// <param name="docNo">单据号码</param>
|
/// <returns></returns>
|
public DataSet GetDataByKey(string docNo)
|
{
|
var cmd = _Database.CreateSqlProc("usp_MES_Order_GetDataByKey");
|
cmd.AddParam("DocNo", DbType.String, docNo.Trim());
|
var ds = _Database.GetDataSet(cmd.Command);
|
ds.Tables[0].TableName = MES_Order.__TableName;
|
//明细表
|
ds.Tables[1].TableName = DA01IMAGE.__TableName;
|
return ds;
|
}
|
|
/// <summary>
|
///删除一张单据，包括删除主表及明细表
|
/// </summary>
|
public bool Delete(string docNo)
|
{
|
var cmd = _Database.CreateSqlProc("usp_MES_Order_Delete");
|
cmd.AddParam("DocNo", DbType.String, docNo.Trim());
|
var i = _Database.ExecuteCommand(cmd.Command);
|
return i != 0;
|
}
|
|
/// <summary>
|
//保存数据
|
/// </summary>
|
public override SaveResult Update(DataSet data)
|
{
|
//
|
//在这里,可以在保存数据前针对参数data做处理，比如：设置默认值。
|
//在这里,可以手工启动事务关联更新其它表的数据，参考：dalPO.Update方法。
|
//
|
//调用基类的方法保存数据
|
return base.Update(data);
|
}
|
|
/// <summary>
|
//获取单据流水号码
|
/// </summary>
|
protected override string GetNumber(DbTransaction tran)
|
{
|
//1.格式：字头+年年月月+当月4位序号，如：PO15010001, 与GetDocNo方法相同
|
//string docNo = DocNoTool.GetNumber(_Database,tran, "");//注意修改流水号字头!
|
|
//2.格式：字头+年年月月+当月4位序号，如：PO15010001
|
var docNo = DocNoTool.GetDocNo(_Database, ""); //注意修改流水号字头!
|
|
//3.格式：XX0000001~N
|
//string docNo = DocNoTool.GetDataSN(_Database,tran, "", true, 6);
|
|
return docNo; //业务单据号码，默认格式2
|
}
|
} //public class
|
} //namespace
|
