public int Update(GK_OA_InFileRegisterMainModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new GK_OA_InFileRegisterMainBLL().Update(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public int Insert(GK_OA_CardsFolderModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new GK_OA_CardsFolderBLL().Insert(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public List <GK_OA_MakeMarksModel> GetGK_OA_MakeMarksList(string SortColumns, int StartRecord, int MaxRecords, string UnitCodeEqual, string MarkTypeEqual, DateTime RegisterDateEqualStart, DateTime RegisterDateEqualEnd, string TitleEqual)
{
List <GK_OA_MakeMarksModel> models = new List <GK_OA_MakeMarksModel>();
GK_OA_MakeMarksQueryModel objQueryModel = new GK_OA_MakeMarksQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.UnitCodeEqual = UnitCodeEqual;
objQueryModel.MarkTypeEqual = MarkTypeEqual;
objQueryModel.RegisterDateEqualStart = RegisterDateEqualStart;
objQueryModel.RegisterDateEqualEnd = RegisterDateEqualEnd;
objQueryModel.TitleEqual = TitleEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new GK_OA_MakeMarksBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public int ModifyPassAuditing(int Code)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new GK_OA_AssetTransferBLL().ModifyPassAuditing(Code, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public int Delete(GK_OA_MakeMarksModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new GK_OA_MakeMarksBLL().Delete(ObjModel.Code, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public List <UserHelpGroupModel> GetUserHelpGroupList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string GroupNameEqual, string UserCodeEqual, DateTime CreateTimeEqual)
{
List <UserHelpGroupModel> models = new List <UserHelpGroupModel>();
UserHelpGroupQueryModel objQueryModel = new UserHelpGroupQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.GroupNameEqual = GroupNameEqual;
objQueryModel.UserCodeEqual = UserCodeEqual;
objQueryModel.CreateTimeEqual = CreateTimeEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
models = new UserHelpGroupBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <MeetRoomModel> GetMeetRoomList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string RoomNameEqual, string CapacityEqual, string PlaceEqual, string HardConditionEqual, string RemarkEqual)
{
List <MeetRoomModel> models = new List <MeetRoomModel>();
MeetRoomQueryModel objQueryModel = new MeetRoomQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.RoomNameEqual = RoomNameEqual;
objQueryModel.CapacityEqual = CapacityEqual;
objQueryModel.PlaceEqual = PlaceEqual;
objQueryModel.HardConditionEqual = HardConditionEqual;
objQueryModel.RemarkEqual = RemarkEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
models = new MeetRoomBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_InFileRegisterMainModel> GetGK_OA_InFileRegisterMainList(string SortColumns, int StartRecord, int MaxRecords, string SystemCodeEqual, string FileCodeEqual, DateTime InFileDateEqualStart, DateTime InFileDateEqualEnd)
{
List <GK_OA_InFileRegisterMainModel> models = new List <GK_OA_InFileRegisterMainModel>();
GK_OA_InFileRegisterMainQueryModel objQueryModel = new GK_OA_InFileRegisterMainQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.SystemCodeEqual = SystemCodeEqual;
objQueryModel.FileCodeEqual = FileCodeEqual;
objQueryModel.InFileDateEqualStart = InFileDateEqualStart;
objQueryModel.InFileDateEqualEnd = InFileDateEqualEnd;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new GK_OA_InFileRegisterMainBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <RoomModelQuery> GetMeetRoomUseStatus(string roomCode, string begin, string end, LoadType lt)
{
List <RoomModelQuery> list = new List <RoomModelQuery>();
List <RoomModelQuery> list2 = new List <RoomModelQuery>();
list = new ConferenceManageDAL(new SqlConnection(FunctionRule.GetConnectionString())).GetRoomUseStatus(roomCode, begin, end);
if ((list != null) && (list.Count != 0))
{
foreach (RoomModelQuery query in list)
{
query.RoomCode = int.Parse(roomCode);
query.RoomName = GetMeetRoomName(roomCode);
query.TimeAge = this.ChangeTimeArea(query.TimeAge);
query.ChaterMember = this.GetUserName(query.ChaterMember);
if (lt.Equals(LoadType.Search))
{
query.Message = string.Format("<a href=\"#\" onclick=\"OpenLargeWindow('../RmsOA/XZ_Conference.aspx?Code={0}&Type=Read','')\">{1}</a>", query.MeetCode, query.ChaterMember);
}
else
{
query.Message = query.ChaterMember;
}
list2.Add(query);
}
}
return(list2);
}
public List <YF_AssetManageModel> GetYF_AssetManageList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string FacilityNameEqual, string AreaEqual, string ProducerEqual, string BuyCorpEqual, string ModelNOEqual, string LayCorpEqual, string TypeEqual, string CountsEqual, string UseDeptEqual, string LayPlaceEqual, string CountUnitEqual, string ProdAreaEqual, string SortNOEqual, string SortTypeEqual, string FreeMainEqual, string EquiTypeEqual, string ProviderEqual, DateTime BuyDateEqual, decimal PriceEqual, string RegisterEqual, string MainCardPlaceEqual, string StoreStatusEqual, string RemarkEqual, string StatusEqual, string DeptUnitEqual, DateTime BookINTimeEqual, string BuyTypeEqual, string CodeNOEqual, DateTime StartTimeEqual, DateTime EndTimeEqual)
{
List <YF_AssetManageModel> models = new List <YF_AssetManageModel>();
YF_AssetManageQueryModel objQueryModel = new YF_AssetManageQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.FacilityNameEqual = FacilityNameEqual;
objQueryModel.AreaEqual = AreaEqual;
objQueryModel.ProducerEqual = ProducerEqual;
objQueryModel.BuyCorpEqual = BuyCorpEqual;
objQueryModel.ModelNOEqual = ModelNOEqual;
objQueryModel.LayCorpEqual = LayCorpEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.CountsEqual = CountsEqual;
objQueryModel.UseDeptEqual = UseDeptEqual;
objQueryModel.LayPlaceEqual = LayPlaceEqual;
objQueryModel.CountUnitEqual = CountUnitEqual;
objQueryModel.ProdAreaEqual = ProdAreaEqual;
objQueryModel.SortNOEqual = SortNOEqual;
objQueryModel.SortTypeEqual = SortTypeEqual;
objQueryModel.FreeMainEqual = FreeMainEqual;
objQueryModel.EquiTypeEqual = EquiTypeEqual;
objQueryModel.ProviderEqual = ProviderEqual;
objQueryModel.BuyDateEqual = BuyDateEqual;
objQueryModel.PriceEqual = PriceEqual;
objQueryModel.RegisterEqual = RegisterEqual;
objQueryModel.MainCardPlaceEqual = MainCardPlaceEqual;
objQueryModel.StoreStatusEqual = StoreStatusEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.StatusEqual = StatusEqual;
objQueryModel.DeptUnitEqual = DeptUnitEqual;
objQueryModel.BookINTimeEqual = BookINTimeEqual;
objQueryModel.BuyTypeEqual = BuyTypeEqual;
objQueryModel.CodeNOEqual = CodeNOEqual;
objQueryModel.QueryStartTimeEqual = StartTimeEqual;
objQueryModel.QueryEndTimeEqual = EndTimeEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new YF_AssetManageBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_CardsFolderModel> GetGK_OA_CardsFolderList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string UserIdEqual, string UserNameEqual, string SexEqual, int AgeEqual, string CompanyNameEqual, string CompanyAddressEqual, string DeptEqual, string HeadshipEqual, string PostalcodeEqual, string PhoneEqual, string FaxEqual, string MobileEqual, string EmailEqual, string NetAddressEqual, string HobbyEqual, string HomeAddressEqual, string WedlockEqual, string CardTypeEqual, string NativePlaceEqual, DateTime BirthdayEqual, DateTime ContactTimeEqual, string RemarkEqual, string HomePhoneEqual)
{
List <GK_OA_CardsFolderModel> models = new List <GK_OA_CardsFolderModel>();
GK_OA_CardsFolderQueryModel objQueryModel = new GK_OA_CardsFolderQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.UserIdEqual = UserIdEqual;
objQueryModel.UserNameEqual = UserNameEqual;
objQueryModel.SexEqual = SexEqual;
objQueryModel.AgeEqual = AgeEqual;
objQueryModel.CompanyNameEqual = CompanyNameEqual;
objQueryModel.CompanyAddressEqual = CompanyAddressEqual;
objQueryModel.DeptEqual = DeptEqual;
objQueryModel.HeadshipEqual = HeadshipEqual;
objQueryModel.PostalcodeEqual = PostalcodeEqual;
objQueryModel.PhoneEqual = PhoneEqual;
objQueryModel.FaxEqual = FaxEqual;
objQueryModel.MobileEqual = MobileEqual;
objQueryModel.EmailEqual = EmailEqual;
objQueryModel.NetAddressEqual = NetAddressEqual;
objQueryModel.HobbyEqual = HobbyEqual;
objQueryModel.HomeAddressEqual = HomeAddressEqual;
objQueryModel.WedlockEqual = WedlockEqual;
objQueryModel.CardTypeEqual = CardTypeEqual;
objQueryModel.NativePlaceEqual = NativePlaceEqual;
objQueryModel.BirthdayEqual = BirthdayEqual;
objQueryModel.ContactTimeEqual = ContactTimeEqual;
objQueryModel.RemarkEqual = RemarkEqual;
objQueryModel.HomePhoneEqual = HomePhoneEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new GK_OA_CardsFolderBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <GK_OA_MeetSummaryModel> GetGK_OA_MeetSummaryList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string SortCodeEqual, string CodeRuleEqual, DateTime MeetStartTimeEqual, string PlaceEqual, string TitleEqual, string AttendPersonsEqual, string RecoderEqual, string ContextEqual, string OtherContextEqual, string TypeEqual, string DeptEqual, string StatusEqual, string CharterMemberEqual, string OtherPersonEqual, DateTime MeetEndTimeEqual, string SmallTitleEqual, string SendStatusEqual, string PreLeaveEqual, DateTime SubmitTimeEqual, string SubmiterEqual, DateTime startTime, DateTime endTime)
{
List <GK_OA_MeetSummaryModel> models = new List <GK_OA_MeetSummaryModel>();
GK_OA_MeetSummaryQueryModel objQueryModel = new GK_OA_MeetSummaryQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.SortCodeEqual = SortCodeEqual;
objQueryModel.CodeRuleEqual = CodeRuleEqual;
objQueryModel.MeetStartTimeEqual = MeetStartTimeEqual;
objQueryModel.PlaceEqual = PlaceEqual;
objQueryModel.TitleEqual = TitleEqual;
objQueryModel.AttendPersonsEqual = AttendPersonsEqual;
objQueryModel.RecoderEqual = RecoderEqual;
objQueryModel.ContextEqual = ContextEqual;
objQueryModel.OtherContextEqual = OtherContextEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.DeptEqual = DeptEqual;
objQueryModel.StatusEqual = StatusEqual;
objQueryModel.CharterMemberEqual = CharterMemberEqual;
objQueryModel.OtherPersonEqual = OtherPersonEqual;
objQueryModel.MeetEndTimeEqual = MeetEndTimeEqual;
objQueryModel.SmallTitleEqual = SmallTitleEqual;
objQueryModel.SendStatusEqual = SendStatusEqual;
objQueryModel.PreLeaveEqual = PreLeaveEqual;
objQueryModel.SubmitTimeEqual = SubmitTimeEqual;
objQueryModel.SubmiterEqual = SubmiterEqual;
objQueryModel.StartTimeEqual = startTime;
objQueryModel.EndTimeEqual = endTime;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new GK_OA_MeetSummaryBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <RS_EmployScoreModel> GetRS_EmployScoreList(string SortColumns, int StartRecord, int MaxRecords, string CodeEqual, string ManageCodeEqual, string UserCodeEqual, string ScoreEqual)
{
List <RS_EmployScoreModel> models = new List <RS_EmployScoreModel>();
RS_EmployScoreQueryModel objQueryModel = new RS_EmployScoreQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
if (!string.IsNullOrEmpty(CodeEqual))
{
objQueryModel.CodeEqual = int.Parse(CodeEqual);
}
if (!string.IsNullOrEmpty(ManageCodeEqual))
{
objQueryModel.ManageCodeEqual = int.Parse(ManageCodeEqual);
}
if (!string.IsNullOrEmpty(UserCodeEqual))
{
objQueryModel.UserCodeEqual = UserCodeEqual;
}
if (!string.IsNullOrEmpty(ScoreEqual))
{
objQueryModel.ScoreEqual = int.Parse(ScoreEqual);
}
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
try
{
connection.Open();
models = new RS_EmployScoreBLL().GetModels(objQueryModel, connection);
}
catch (SqlException exception)
{
throw exception;
}
return(models);
}
finally
{
connection.Close();
}
}
return(models);
}
public List <GK_OA_MaterialTransferModel> GetGK_OA_MaterialTransferList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, string NameEqual, string TypeEqual, string NumberEqual, string NumUnitEqual, string ReasonEqual, decimal OriginalPriceEqual, string PreUserEqual, string PreDeptEqual, string LaterUserEqual, string LaterDeptEqual, string TransferHanderEqual, string ReciveHanderEqual, string TransferMasterEqual, string ReciveMasterEqual, DateTime TransferDateEqual, DateTime ReciveDateEqual, string QualityNOEqual, string SNRuleEqual, string StatusEqual, DateTime StartDate, DateTime EndDate)
{
List <GK_OA_MaterialTransferModel> models = new List <GK_OA_MaterialTransferModel>();
GK_OA_MaterialTransferQueryModel objQueryModel = new GK_OA_MaterialTransferQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.NameEqual = NameEqual;
objQueryModel.TypeEqual = TypeEqual;
objQueryModel.NumberEqual = NumberEqual;
objQueryModel.NumUnitEqual = NumUnitEqual;
objQueryModel.ReasonEqual = ReasonEqual;
objQueryModel.OriginalPriceEqual = OriginalPriceEqual;
objQueryModel.PreUserEqual = PreUserEqual;
objQueryModel.PreDeptEqual = PreDeptEqual;
objQueryModel.LaterUserEqual = LaterUserEqual;
objQueryModel.LaterDeptEqual = LaterDeptEqual;
objQueryModel.TransferHanderEqual = TransferHanderEqual;
objQueryModel.ReciveHanderEqual = ReciveHanderEqual;
objQueryModel.TransferMasterEqual = TransferMasterEqual;
objQueryModel.ReciveMasterEqual = ReciveMasterEqual;
objQueryModel.TransferDateEqual = TransferDateEqual;
objQueryModel.ReciveDateEqual = ReciveDateEqual;
objQueryModel.QualityNOEqual = QualityNOEqual;
objQueryModel.SNRuleEqual = SNRuleEqual;
objQueryModel.StatusEqual = StatusEqual;
objQueryModel.StartDateEqual = StartDate;
objQueryModel.EndDateEqual = EndDate;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
models = new GK_OA_MaterialTransferBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public GK_OA_ComBookModel GetGK_OA_ComBook(int Code)
{
GK_OA_ComBookModel model = new GK_OA_ComBookModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
model = new GK_OA_ComBookBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public MeetRoomModel GetMeetRoom(int Code)
{
MeetRoomModel model = new MeetRoomModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
model = new MeetRoomBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public ConferenceUserListModel GetConferenceUserList(int Code)
{
ConferenceUserListModel model = new ConferenceUserListModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
model = new ConferenceUserListBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public CachetManageModel GetCachetManage(int Code)
{
CachetManageModel model = new CachetManageModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
model = new CachetManageBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public DeskTopTypeModel GetDeskTopType(int Code)
{
DeskTopTypeModel model = new DeskTopTypeModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
model = new DeskTopTypeBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public UserHelpUserModel GetUserHelpUser(int Code)
{
UserHelpUserModel model = new UserHelpUserModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
model = new UserHelpUserBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public List <CachetManageModel> GetCachetManageListOne(int Code)
{
List <CachetManageModel> list = new List <CachetManageModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
CachetManageBLL ebll = new CachetManageBLL();
list.Add(ebll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public int Insert(OAPersonModel ObjModel)
{
int num = 0;
GK_OA_ComBookModel objModel = new GK_OA_ComBookModel();
GK_OA_ComBookBLL kbll = new GK_OA_ComBookBLL();
objModel.Company = string.Empty;
objModel.MSN = string.Empty;
objModel.QQ = string.Empty;
objModel.UnitCode = ObjModel.yard;
objModel.UserCode = ObjModel.cname;
objModel.Telephone = ObjModel.phone;
objModel.HandleTelephone = ObjModel.mobile;
objModel.Email = ObjModel.email;
objModel.PrepField1 = ObjModel.address;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
OAPersonBLL nbll = new OAPersonBLL();
kbll.Insert(objModel, transaction);
num = nbll.Insert(ObjModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public YF_UseCarFlowModel GetYF_UseCarFlow(int Code)
{
YF_UseCarFlowModel model = new YF_UseCarFlowModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new YF_UseCarFlowBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public RS_ScoreManageModel GetRS_ScoreManage(int Code)
{
RS_ScoreManageModel model = new RS_ScoreManageModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new RS_ScoreManageBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public List <UserHelpUserModel> GetUserHelpUserListOne(int Code)
{
List <UserHelpUserModel> list = new List <UserHelpUserModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
UserHelpUserBLL rbll = new UserHelpUserBLL();
list.Add(rbll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}
public GK_OA_ChangeStationNoticeModel GetGK_OA_ChangeStationNotice(int Code)
{
GK_OA_ChangeStationNoticeModel model = new GK_OA_ChangeStationNoticeModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new GK_OA_ChangeStationNoticeBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public GK_OA_OfficialSealRegiesterModel GetGK_OA_OfficialSealRegiester(int Code)
{
GK_OA_OfficialSealRegiesterModel model = new GK_OA_OfficialSealRegiesterModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new GK_OA_OfficialSealRegiesterBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public GK_OA_CapitalAssertAcountModel GetGK_OA_CapitalAssertAcount(int Code)
{
GK_OA_CapitalAssertAcountModel model = new GK_OA_CapitalAssertAcountModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new GK_OA_CapitalAssertAcountBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public OAPersonStudyModel GetOAPersonStudy(int Code)
{
OAPersonStudyModel model = new OAPersonStudyModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
connection.Open();
model = new OAPersonStudyBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
public List <GK_OA_ComBookModel> GetGK_OA_ComBookListOne(int Code)
{
List <GK_OA_ComBookModel> list = new List <GK_OA_ComBookModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
GK_OA_ComBookBLL kbll = new GK_OA_ComBookBLL();
list.Add(kbll.GetModel(Code, connection));
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(list);
}