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
    }
}