You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
105 lines
4.3 KiB
105 lines
4.3 KiB
using System;
|
|
using System.Data;
|
|
using System.Collections.Generic;
|
|
|
|
namespace OT.IDAL
|
|
{
|
|
public interface ICommonClass
|
|
{
|
|
#region 下拉選單
|
|
DataSet GetDDLModuleList(string UserRoleId);
|
|
DataSet GetProgramListByModuleID(string ModuleID, string UserRoleId);
|
|
|
|
//DataSet GetNAMEByGROUP_ID(string strGROUP_ID);
|
|
//DataSet GetDescriptoinList(string ProjectDetailID);
|
|
//DataSet GetJobNameList(string ProjectDetailID);
|
|
//DataSet GetPJMgDpByProjectID(string ProjectID);
|
|
//DataSet GetGROUP_NAMEList(string CreateUser);
|
|
//DataSet GetIndustryClassList(string NULL);
|
|
//DataSet GetSatisfiedList(string NULL);
|
|
//DataSet GetOrderHStatusList();
|
|
//DataSet GetProjectStatusList();
|
|
///// <summary>
|
|
///// 獲取專案管理入場方式列表
|
|
///// </summary>
|
|
//DataSet GetInRoomClassList();
|
|
///// <summary>
|
|
///// 獲取店家資料對外服務列表
|
|
///// </summary>
|
|
//DataSet GetForeignServiceList();
|
|
DataSet GetUSERACCOUNTList(string NULL);
|
|
DataSet GetChinWDCCOUNTList(string NULL);
|
|
//DataSet GetPlaceRoomIDList();
|
|
//DataSet GetEquipmentNameListByEquipmentClass(string EquipmentClassID);
|
|
//DataSet GetJobNameListByJobItem(string JobItem);
|
|
|
|
//DataSet GetPlaceRoomByProjectID(string ProjectID);
|
|
//DataSet GetProjectPlaceRoomName(string ProjectID);
|
|
//DataSet GetBuildingByLoginUserGuid(string LoginUserGuid);
|
|
//DataSet GetEventTypeNameByParentID(string ParentID);
|
|
#endregion
|
|
|
|
#region 取流水號
|
|
int GetArgumentMaxNumber(string ArgumentClassID, string ArgumentID, string ModifyUser);
|
|
int GetArgumentClassMaxNumber(string ArgumentClassID, string ModifyUser);
|
|
#endregion
|
|
|
|
#region 取程式列表
|
|
|
|
#region GetProgramListByRuleId
|
|
/// <summary>
|
|
/// 依據角色ID取得程式列表信息
|
|
/// </summary>
|
|
/// <param name="strRuleId">角色ID</param>
|
|
/// <returns>程式列表信息</returns>
|
|
DataSet GetProgramListByRuleId(string strRuleId);
|
|
#endregion
|
|
|
|
#endregion
|
|
|
|
#region 取Text的值
|
|
|
|
|
|
string GetDate();
|
|
|
|
DataSet GetArgumentListByArgumentClassID(string strArgumentClassID);
|
|
int GetMaxNumberByType(string Type, string Flag, string ModifyUser);
|
|
DataSet GetFileListBySourceRelationID(string SourceRelationID);
|
|
/// <summary>
|
|
/// 通過專案編號獲取該專案中所有合約的附件資料列表
|
|
/// </summary>
|
|
DataSet GetContractListFileListByProjectID(string ProjectID);
|
|
/// <summary>
|
|
/// 獲得資料列表
|
|
/// </summary>
|
|
DataSet GetList(int StartRecordIndex, int EndRecordIndex, string CustomerClass, string CustomerID, string CustomerName, string ContectName, string TEL, string TaxNumber, string Status, string SortExpression);
|
|
/// <summary>
|
|
/// 更新排序欄位
|
|
/// </summary>
|
|
bool UpdateOrderByValue(string OldOrderByValue, string NewOrderByValue, string FeildName, string MDFUserFeild, string ModifyUser, string MDFDateFeild, string TableName, string Where1, string Where2);
|
|
|
|
|
|
#endregion
|
|
|
|
string GetSystemSetting(string strItem, string SettingValueOrMemo);
|
|
|
|
DataSet GetTrWord(string strWhere);
|
|
|
|
#region 共用型更改MemberID
|
|
/// <summary>
|
|
/// 共用型更改MemberID
|
|
/// Create by Gary 2014/08/13
|
|
/// </summary>
|
|
/// <param name="strTableName">資料表名稱</param>
|
|
/// <param name="strMemberField">MemberField欄位名稱</param>
|
|
/// <param name="strMemberID">新的MemberID</param>
|
|
/// <param name="strModifyField">更改人欄位</param>
|
|
/// <param name="strUserID">更改人ID</param>
|
|
/// <param name="strModifyDateField">更改時間欄位</param>
|
|
/// <param name="strWhere">Where條件，請務必給正確的條件，以免更新錯誤</param>
|
|
/// <returns>是否更新成功</returns>
|
|
/// 使用地方: ChangeMember_Pop.aspx.cs by Gary 2014/08/13
|
|
bool UpdateMemberID(string strTableName, string strMemberField, string strMemberID, string strModifyField, string strUserID, string strModifyDateField, string strWhere);
|
|
#endregion
|
|
}
|
|
}
|