public UserInfoAccount Save(UserInfoAccount userInfoAccount) { UserInfoAccount retUser; #region sqlText const string sqlText = @"INSERT INTO [DBO].[USERINFOACCOUNT] VALUES(NEXT VALUE FOR UserDBSequence ,@USERINFOID ,@ACCOUNTTYPE ,@ACCOUNT)"; #endregion using (var conn = SqlServerDB.GetSqlConnection()) { var re = conn.Query <UserInfoAccount>(sqlText, userInfoAccount); retUser = re.FirstOrDefault(); } return(retUser); }
public UserInfoAccount Update(UserInfoAccount userInfo) { throw new NotImplementedException(); }
public UserInfo Save(UserInfoAccount userInfo) { UserInfo retUser = null; #region sql #region sqlText const string sqlText = @" INSERT INTO [dbo].[UserInfo] ( [ID] ,[PASSWORD] ,[NICKNAME] ,[GENDER] ,[COMPANYNAME] ,[ADDRESS] ,[REMARK]) OUTPUT INSERTED.* VALUES( NEXT VALUE FOR UserDBSequence ,@PASSWORD ,@NICKNAME ,@GENDER ,@COMPANYNAME ,@ADDRESS ,@REMARK ); "; const string mappingSqlText = @"INSERT INTO [DBO].[USERINFOACCOUNT] VALUES(NEXT VALUE FOR UserDBSequence ,@USERINFOID ,@ACCOUNTTYPE ,@ACCOUNT)"; #endregion #endregion #region USE DONET TRANSACTION using (var conn = SqlServerDB.GetSqlConnection()) { conn.Open(); var trans = conn.BeginTransaction(); try { var re = conn.Query <UserInfo>(sqlText, userInfo, trans); retUser = re.FirstOrDefault(); //if (retUser != null) //{ // foreach (var account in userInfo.Accounts) // { // conn.Execute(mappingSqlText, // new { USERINFOID = retUser.Id, ACCOUNTTYPE = userInfo.AccountType, ACCOUNT = account }, trans); // } trans.Commit(); //} } catch (Exception) { trans.Rollback(); } } #endregion #region USE SQL TRANSACTION #region transactionSqlText // const string transactionSqlText = @"DECLARE @USERINFO_TEMP TABLE( // [ID] BIGINT, // [ACCOUNT] NVARCHAR(50) NOT NULL, // [PASSWORD] NVARCHAR(50) NOT NULL, // [NICKNAME] NVARCHAR(30) NULL, // [GENDER] BIT NULL, // [COMPANYNAME] NVARCHAR(50) NULL, // [ADDRESS] NVARCHAR(100) NULL, // [REMARK] NVARCHAR(100) NULL) // DECLARE @USERINFO_ID BIGINT; // BEGIN TRAN // BEGIN TRY // INSERT INTO [dbo].[UserInfo] // ([ACCOUNT] // ,[PASSWORD] // ,[NICKNAME] // ,[GENDER] // ,[COMPANYNAME] // ,[ADDRESS] // ,[REMARK]) // OUTPUT INSERTED.* INTO @USERINFO_TEMP // VALUES( // @ACCOUNT // ,@PASSWORD // ,@NICKNAME // ,@GENDER // ,@COMPANYNAME // ,@ADDRESS // ,@REMARK); // PRINT @USERINFO_ID; // SELECT @USERINFO_ID =ID FROM @USERINFO_TEMP // PRINT @USERINFO_ID; // INSERT INTO [DBO].[UserInfo_AccountType_Mapping] VALUES (@USERINFO_ID,@ACCOUNT_TYPE) // COMMIT // SELECT * FROM @USERINFO_TEMP ; // END TRY // BEGIN CATCH // THROW // ROLLBACK // RETURN // END CATCH"; #endregion #region proc_transaction //const string insertProc = "PROC_INSERTUSERINFO"; #endregion //using (var conn = SqlServerDB.GetSqlConnection()) //{ // var re = conn.Query<UserInfo>(insertProc, new // { // Account_Type = userInfo.AccountType, // ACCOUNT = userInfo.Account, // PASSWORD = userInfo.Password, // NICKNAME = userInfo.NickName, // GENDER = userInfo.Gender, // COMPANYNAME = userInfo.CompanyName, // ADDRESS = userInfo.Address, // REMARK = userInfo.Remark // }, null, false, null, CommandType.StoredProcedure); // retUser = re.FirstOrDefault(); //} #endregion return(retUser); }
public bool Delete(UserInfoAccount userInfo) { throw new NotImplementedException(); }