Files
thinkyu/教育訓練系統/Web/DAC/溝通記錄/DAC_訓練溝通記錄附件1.cs
sryang 577060bc78 chore: 首次簽入 Thinkyu ASP.NET 專案
- 加入 Visual Studio / ASP.NET .gitignore
- 排除建置輸出、IDE 設定、NuGet packages、大型 MSI 安裝檔
2026-09-10 09:42:37 +08:00

621 lines
23 KiB
C#

//
// 這個檔案是 訓練溝通記錄附件 資料表的資料存取類別 檔案一
// 請不要修改這個檔案,重新產生資料存取類別時,這個檔案會被覆蓋掉
//
using System;
using System.Collections.Generic;
using System.Text;
using System.ComponentModel;
using System.Data;
using System.Data.Common;
using System.Linq;
using System.Transactions;
using WebLib;
using System.Data.SqlClient;
namespace Education
{
///<summary>
/// 訓練溝通記錄附件 資料存取類別
///</ summary>
[DataObject]
public partial class DAC_訓練溝通記錄附件 : WebLib.DAC
{
private const string _tableName = "[訓練溝通記錄附件]";
private const string _allFields = "[編號], [訓練溝通記錄編號], [標題], [檔案名稱], [副檔名], [ContentType], [DB_APPNO], [DB_CRDAT], [DB_CRUSR], [DB_TRDAT], [DB_TRUSR]";
private string _orderBy = "[編號]";
private string _select = "select " + _allFields;
private string _insert = "[訓練溝通記錄編號], [標題], [檔案名稱], [副檔名], [ContentType], [DB_APPNO], [DB_CRDAT], [DB_CRUSR], [DB_TRDAT], [DB_TRUSR]";
private string _insertBak = "[編號], [訓練溝通記錄編號], [標題], [檔案名稱], [副檔名], [ContentType], [DB_APPNO], [DB_CRDAT], [DB_CRUSR], [DB_TRDAT], [DB_TRUSR], [DB_TRMOD]";
private string _insertValue = "@訓練溝通記錄編號, @標題, @檔案名稱, @副檔名, @ContentType, @DB_APPNO, @DB_CRDAT, @DB_CRUSR, @DB_TRDAT, @DB_TRUSR";
private string _insertBakValue = "@編號, @訓練溝通記錄編號, @標題, @檔案名稱, @副檔名, @ContentType, @DB_APPNO, @DB_CRDAT, @DB_CRUSR, @DB_TRDAT, @DB_TRUSR, @DB_TRMOD";
private string _from = " from " + _tableName + " ";
private string _where = " where 1=1 ";
private string _order = " order by [編號] ";
public DAC_訓練溝通記錄附件()
: base()
{
}
public DAC_訓練溝通記錄附件(DbConnection conn)
: base(conn)
{
}
[DataObjectMethod(DataObjectMethodType.Select)]
public 訓練溝通記錄附件List SelectAll(string orderBy = "")
{
訓練溝通記錄附件List result = new 訓練溝通記錄附件List();
IDataList list = result as IDataList;
DbCommand cmdSelect = NewCommand();
cmdSelect.CommandText = _select + _from + _where + (orderBy == null || orderBy.Length == 0 ? _order : " order by " + orderBy);
Select(cmdSelect, ref list);
return result;
}
public int SelectAllCount()
{
DbCommand cmdSelect = NewCommand();
cmdSelect.CommandText = "select count(1) " + _from;
int i;
ExecuteScalar(cmdSelect, out i);
return i;
}
[DataObjectMethod(DataObjectMethodType.Select)]
public 訓練溝通記錄附件List SelectAllPage(int startRowIndex, int maximumRows, string orderBy = "")
{
訓練溝通記錄附件List result = new 訓練溝通記錄附件List();
IDataList list = result as IDataList;
DbCommand cmdSelect = NewCommand();
cmdSelect.CommandText =
String.Format("select top {0} * from (", maximumRows)
+ "select " + _allFields
+ ", row_number() over (order by " + (orderBy == null || orderBy.Length == 0 ? _orderBy : orderBy) + ") as rowid "
+ _from + _where
+ ") as TMP1 where rowid > @startRowIndex ";
AddParam(cmdSelect, "startRowIndex", startRowIndex);
Select(cmdSelect, ref list);
return result;
}
[DataObjectMethod(DataObjectMethodType.Select)]
public 訓練溝通記錄附件List SelectOne(int 編號)
{
訓練溝通記錄附件List result = new 訓練溝通記錄附件List();
IDataList list = result as IDataList;
DbCommand cmdSelect = NewCommand();
cmdSelect.CommandText = _select + _from + _where
+ " and 編號 = @編號 "
;
AddParam(cmdSelect, "編號", 編號);
Select(cmdSelect, ref list);
return result;
}
///<summary>
/// 給查詢畫面用的增加 Where 條件的方法
///</summary>
private void AddWhere(DbCommand cmdSelect, ref bool noInput, int? 訓練溝通記錄編號)
{
if (訓練溝通記錄編號 != null)
{
noInput = false;
cmdSelect.CommandText += " and 訓練溝通記錄編號 = @訓練溝通記錄編號 ";
AddParam(cmdSelect, "訓練溝通記錄編號", 訓練溝通記錄編號);
}
}
///<summary>
/// 給查詢畫面用的 Select 方法
///</summary>
[DataObjectMethod(DataObjectMethodType.Select)]
public 訓練溝通記錄附件List Select(bool noInputReturnAll, int? 訓練溝通記錄編號, string orderBy = "")
{
訓練溝通記錄附件List result = new 訓練溝通記錄附件List();
bool noInput = true;
IDataList list = result as IDataList;
DbCommand cmdSelect = NewCommand();
cmdSelect.CommandText = _select + _from + _where;
AddWhere(cmdSelect, ref noInput, 訓練溝通記錄編號);
cmdSelect.CommandText += (orderBy == null || orderBy.Length == 0 ? _order : " order by " + orderBy);
if (!noInputReturnAll && noInput)
return result;
Select(cmdSelect, ref list);
return result;
}
///<summary>
/// 給查詢畫面用的 SelectCount 方法
///</summary>
[DataObjectMethod(DataObjectMethodType.Select)]
public int SelectCount(bool noInputReturnAll, int? 訓練溝通記錄編號, string orderBy = "")
{
bool noInput = true;
DbCommand cmdSelect = NewCommand();
cmdSelect.CommandText = "select count(1) " + _from + _where;
AddWhere(cmdSelect, ref noInput, 訓練溝通記錄編號);
if (!noInputReturnAll && noInput)
return 0;
int i;
ExecuteScalar(cmdSelect, out i);
return i;
}
///<summary>
/// 給查詢畫面用的 SelectPage 方法
///</summary>
[DataObjectMethod(DataObjectMethodType.Select)]
public 訓練溝通記錄附件List SelectPage(bool noInputReturnAll, int startRowIndex, int maximumRows, int? 訓練溝通記錄編號, string orderBy = "")
{
訓練溝通記錄附件List result = new 訓練溝通記錄附件List();
bool noInput = true;
IDataList list = result as IDataList;
DbCommand cmdSelect = NewCommand();
cmdSelect.CommandText =
String.Format("select top {0} * from (", maximumRows)
+ "select " + _allFields
+ ", row_number() over (order by " + (orderBy == null || orderBy.Length == 0 ? _orderBy : orderBy) + ") as rowid "
+ _from + _where;
AddWhere(cmdSelect, ref noInput, 訓練溝通記錄編號);
cmdSelect.CommandText += ") as TMP1 where rowid > @startRowIndex ";
AddParam(cmdSelect, "startRowIndex", startRowIndex);
if (!noInputReturnAll && noInput)
return result;
Select(cmdSelect, ref list);
return result;
}
[DataObjectMethod(DataObjectMethodType.Insert)]
public 訓練溝通記錄附件Item InsertOne(訓練溝通記錄附件Item value)
{
using (TransactionScope ts = DAC.NewTransactionScope())
{
try
{
if (!BeforeInsertOne(value))
return value;
DbCommand cmdInsert = NewCommand();
cmdInsert.CommandText =
"insert into [訓練溝通記錄附件]"
+ " (" + _insert + ")"
+ "values "
+ " (" + _insertValue + ");" + "select @@identity"
;
AddParam(cmdInsert, "訓練溝通記錄編號", value.訓練溝通記錄編號);
AddParam(cmdInsert, "標題", value.標題);
AddParam(cmdInsert, "檔案名稱", value.檔案名稱);
AddParam(cmdInsert, "副檔名", value.副檔名);
AddParam(cmdInsert, "ContentType", value.ContentType);
AddParam(cmdInsert, "DB_APPNO", 1);
AddParam(cmdInsert, "DB_CRDAT", DateTime.UtcNow.AddHours(8));
AddParam(cmdInsert, "DB_CRUSR", CurrentUserId);
AddParam(cmdInsert, "DB_TRDAT", DBNull.Value);
AddParam(cmdInsert, "DB_TRUSR", DBNull.Value);
int newId;
ExecuteScalar(cmdInsert, out newId);
value.編號 = newId;
AfterInsertOne(value);
ts.Complete();
}
catch (Exception error)
{
bool handled;
OnInsertOneError(error, out handled);
if(!handled)
throw error;
}
return value;
}
}
[DataObjectMethod(DataObjectMethodType.Update)]
public 訓練溝通記錄附件Item UpdateOne(訓練溝通記錄附件Item value)
{
using (TransactionScope ts = DAC.NewTransactionScope())
{
try
{
if (!BeforeUpdateOne(value))
return value;
訓練溝通記錄附件List oldValues = SelectOne(value.編號);
if (oldValues.Count == 0 || oldValues[0].DB_APPNO != value.DB_APPNO)
{
throw new DBConcurrencyException("在更新 \"訓練溝通記錄附件\" 資料表時發生並行例外:找不到要更新的資料列");
}
else
{
DoBackup(oldValues[0], "UPDATE");
}
DbCommand cmdUpdate = NewCommand();
cmdUpdate.CommandText =
@"update [訓練溝通記錄附件]
set
訓練溝通記錄編號 = @訓練溝通記錄編號 ,
標題 = @標題 ,
檔案名稱 = @檔案名稱 ,
副檔名 = @副檔名 ,
ContentType = @ContentType ,
DB_APPNO = DB_APPNO + 1,
DB_TRDAT = @DB_TRDAT,
DB_TRUSR = @DB_TRUSR
where 1=1
and 編號 = @original_編號
and DB_APPNO = @original_DB_APPNO
";
AddParam(cmdUpdate, "訓練溝通記錄編號", value.訓練溝通記錄編號);
AddParam(cmdUpdate, "標題", value.標題);
AddParam(cmdUpdate, "檔案名稱", value.檔案名稱);
AddParam(cmdUpdate, "副檔名", value.副檔名);
AddParam(cmdUpdate, "ContentType", value.ContentType);
AddParam(cmdUpdate, "DB_TRDAT", DateTime.UtcNow.AddHours(8));
AddParam(cmdUpdate, "DB_TRUSR", CurrentUserId);
AddParam(cmdUpdate, "original_編號", value.編號);
AddParam(cmdUpdate, "original_DB_APPNO", value.DB_APPNO);
ExecuteNonQuery(cmdUpdate);
AfterUpdateOne(value);
ts.Complete();
return value;
}
catch (Exception error)
{
bool handled;
OnUpdateOneError(error, out handled);
if(!handled)
throw error;
return value;
}
}
}
[DataObjectMethod(DataObjectMethodType.Update)]
public 訓練溝通記錄附件Item UpdateOne(訓練溝通記錄附件Item value, 訓練溝通記錄附件Item original_value)
{
using (TransactionScope ts = DAC.NewTransactionScope())
{
try
{
if (!BeforeUpdateOne(value, original_value))
return value;
訓練溝通記錄附件List oldValues = SelectOne(original_value.編號);
if (oldValues.Count == 0 || oldValues[0].DB_APPNO != value.DB_APPNO)
{
throw new DBConcurrencyException("在更新 \"訓練溝通記錄附件\" 資料表時發生並行例外:找不到要更新的資料列");
}
else
{
DoBackup(oldValues[0], "UPDATE");
}
DbCommand cmdUpdate = NewCommand();
cmdUpdate.CommandText =
@"update [訓練溝通記錄附件]
set
訓練溝通記錄編號 = @訓練溝通記錄編號 ,
標題 = @標題 ,
檔案名稱 = @檔案名稱 ,
副檔名 = @副檔名 ,
ContentType = @ContentType ,
DB_APPNO = DB_APPNO + 1,
DB_TRDAT = @DB_TRDAT,
DB_TRUSR = @DB_TRUSR
where 1=1
and 編號 = @original_編號
and DB_APPNO = @original_DB_APPNO
";
AddParam(cmdUpdate, "訓練溝通記錄編號", value.訓練溝通記錄編號);
AddParam(cmdUpdate, "標題", value.標題);
AddParam(cmdUpdate, "檔案名稱", value.檔案名稱);
AddParam(cmdUpdate, "副檔名", value.副檔名);
AddParam(cmdUpdate, "ContentType", value.ContentType);
AddParam(cmdUpdate, "DB_TRDAT", DateTime.UtcNow.AddHours(8));
AddParam(cmdUpdate, "DB_TRUSR", CurrentUserId);
AddParam(cmdUpdate, "original_編號", original_value.編號);
AddParam(cmdUpdate, "original_DB_APPNO", original_value.DB_APPNO);
ExecuteNonQuery(cmdUpdate);
AfterUpdateOne(value, original_value);
ts.Complete();
return value;
}
catch (Exception error)
{
bool handled;
OnUpdateOneError(error, out handled);
if(!handled)
throw error;
return value;
}
}
}
[DataObjectMethod(DataObjectMethodType.Delete)]
public int DeleteOne(int 編號, int DB_APPNO)
{
using (TransactionScope ts = DAC.NewTransactionScope())
{
try
{
if (!BeforeDeleteOne(編號, DB_APPNO))
return -1;
訓練溝通記錄附件List oldValues = SelectOne(編號);
if (oldValues.Count == 0 || oldValues[0].DB_APPNO != DB_APPNO)
{
throw new DBConcurrencyException("在刪除 \"訓練溝通記錄附件\" 資料表時發生並行例外:找不到要刪除的資料列");
}
else
{
DoBackup(oldValues[0], "DELETE");
}
DbCommand cmdDelete = NewCommand();
cmdDelete.CommandText =
@"delete from [訓練溝通記錄附件]
where 1=1
and 編號 = @編號
and DB_APPNO = @DB_APPNO
";
AddParam(cmdDelete, "編號", 編號);
AddParam(cmdDelete, "DB_APPNO", DB_APPNO);
int rowsAffected = ExecuteNonQuery(cmdDelete);
AfterDeleteOne(編號, DB_APPNO);
ts.Complete();
return rowsAffected;
}
catch (Exception error)
{
bool handled;
OnDeleteOneError(error, out handled);
if(!handled)
throw error;
return -1;
}
}
}
[DataObjectMethod(DataObjectMethodType.Delete)]
public int DeleteOne(訓練溝通記錄附件Item value)
{
using (TransactionScope ts = DAC.NewTransactionScope())
{
try
{
if (!BeforeDeleteOne(value))
return -1;
訓練溝通記錄附件List oldValues = SelectOne(value.編號);
if (oldValues.Count == 0 || oldValues[0].DB_APPNO != value.DB_APPNO)
{
throw new DBConcurrencyException("在刪除 \"訓練溝通記錄附件\" 資料表時發生並行例外:找不到要刪除的資料列");
}
else
{
DoBackup(oldValues[0], "DELETE");
}
DbCommand cmdDelete = NewCommand();
cmdDelete.CommandText =
@"delete from [訓練溝通記錄附件]
where 1=1
and 編號 = @編號
and DB_APPNO = @DB_APPNO
";
AddParam(cmdDelete, "編號", value.編號);
AddParam(cmdDelete, "DB_APPNO", value.DB_APPNO);
int rowsAffected = ExecuteNonQuery(cmdDelete);
AfterDeleteOne(value);
ts.Complete();
return rowsAffected;
}
catch (Exception error)
{
bool handled;
OnDeleteOneError(error, out handled);
if(!handled)
throw error;
return -1;
}
}
}
public bool IsDuplicate(int 編號)
{
DbCommand cmdSelect = NewCommand();
cmdSelect.CommandText = "select count(1)" + _from + _where
+ " and 編號 = @編號 "
;
AddParam(cmdSelect, "編號", 編號);
int count;
ExecuteScalar(cmdSelect, out count);
return count > 0;
}
public void DoBackup(訓練溝通記錄附件Item value, string updateMode)
{
DbCommand cmdBak = NewCommand();
cmdBak.CommandText =
"insert into [訓練溝通記錄附件_BAK]"
+ " (" + _insertBak + ")"
+ "values "
+ " (" + _insertBakValue + ");"
;
AddParam(cmdBak, "編號", value.編號);
AddParam(cmdBak, "訓練溝通記錄編號", value.訓練溝通記錄編號);
AddParam(cmdBak, "標題", value.標題);
AddParam(cmdBak, "檔案名稱", value.檔案名稱);
AddParam(cmdBak, "副檔名", value.副檔名);
AddParam(cmdBak, "ContentType", value.ContentType);
AddParam(cmdBak, "DB_APPNO", value.DB_APPNO);
AddParam(cmdBak, "DB_CRDAT", value.DB_CRDAT);
AddParam(cmdBak, "DB_CRUSR", value.DB_CRUSR);
AddParam(cmdBak, "DB_TRDAT", DateTime.UtcNow.AddHours(8));
AddParam(cmdBak, "DB_TRUSR", CurrentUserId);
AddParam(cmdBak, "DB_TRMOD", updateMode);
ExecuteNonQuery(cmdBak);
}
}
///<summary>
///訓練溝通記錄附件 資料集合類別
///</summary>
public partial class 訓練溝通記錄附件List : List<訓練溝通記錄附件Item>, IDataList
{
public void Fill(DbDataReader reader)
{
DAC.FillData<訓練溝通記錄附件Item>(reader, this);
}
}
///<summary>
/// 訓練溝通記錄附件 資料紀錄類別
///</summary>
[Serializable]
public partial class 訓練溝通記錄附件Item : DataItemBase
{
private int _編號;
private int _訓練溝通記錄編號;
private string _標題;
private string _檔案名稱;
private string _副檔名;
private string _ContentType;
#region 資料欄位
///<summary>
/// 編號
///</summary>
[DataObjectField(true, false, false)]
public int 編號
{
get
{
return _編號;
}
set
{
if (value != _編號)
{
_編號 = value;
OnPropertyChanged("編號");
}
}
}
///<summary>
/// 訓練溝通記錄編號
///</summary>
[DataObjectField(false, false, false)]
public int 訓練溝通記錄編號
{
get
{
return _訓練溝通記錄編號;
}
set
{
if (value != _訓練溝通記錄編號)
{
_訓練溝通記錄編號 = value;
OnPropertyChanged("訓練溝通記錄編號");
}
}
}
///<summary>
/// 標題
///</summary>
[DataObjectField(false, false, true, 100)]
public string 標題
{
get
{
return _標題;
}
set
{
if (value != _標題)
{
_標題 = value;
OnPropertyChanged("標題");
}
}
}
///<summary>
/// 檔案名稱
///</summary>
[DataObjectField(false, false, true, 50)]
public string 檔案名稱
{
get
{
return _檔案名稱;
}
set
{
if (value != _檔案名稱)
{
_檔案名稱 = value;
OnPropertyChanged("檔案名稱");
}
}
}
///<summary>
/// 副檔名
///</summary>
[DataObjectField(false, false, true, 10)]
public string 副檔名
{
get
{
return _副檔名;
}
set
{
if (value != _副檔名)
{
_副檔名 = value;
OnPropertyChanged("副檔名");
}
}
}
///<summary>
/// ContentType
///</summary>
[DataObjectField(false, false, true, 50)]
public string ContentType
{
get
{
return _ContentType;
}
set
{
if (value != _ContentType)
{
_ContentType = value;
OnPropertyChanged("ContentType");
}
}
}
#endregion
}
}