/// <summary> /// Stored proc insert with ID. /// </summary> /// <typeparam name="T">The type of object</typeparam> /// <typeparam name="U">The Type of the ID</typeparam> /// <param name="procName">Name of the proc.</param> /// <param name="parms">instance of DynamicParameters class. This should include a defined output parameter</param> /// <returns>U - the @@Identity value from output parameter</returns> public static U StoredProcInsertWithID <T, U>(string procName, DynamicParameters parms, string connectionName = null) { using (SqlConnection connection = SqlMapperUtil.GetOpenConnection(connectionName)) { var x = connection.Execute(procName, (object)parms, commandType: CommandType.StoredProcedure); return(parms.Get <U>("@ID")); } }
private void InitDataBase(string dbName) { conStr = ConfigurationManager.AppSettings["ConString"]; SqlMapperUtil.GetOpenConnection(conStr); string exsitsDB = "select count(1) from sys.sysdatabases where name =@dbName"; int result = SqlMapperUtil.SqlWithParamsSingle <int>(exsitsDB, new { dbName = dbName }); if (result == 0) { string s1 = " create database [" + dbName + "]"; int ret = SqlMapperUtil.InsertUpdateOrDeleteSql(s1, null); } conStr = conStr.Replace("master", dbName); var StaticStructAndFn = Path.Combine(Directory.GetCurrentDirectory(), "StaticStructAndFn.tsql"); var sqls = File.ReadAllText(StaticStructAndFn); SqlServerHelper.ExecuteSql(sqls, conStr); string kjqjInsert = "delete dbo.kjqj where Projectid='{0}' " + " insert dbo.kjqj(ProjectID,CustomerCode,CustomerName,BeginDate,EndDate,KJDate)" + " select '{0}','{1}','{1}','{2}','{3}','{4}'"; SqlServerHelper.ExecuteSql(string.Format(kjqjInsert, dbName, _projectID, _beginDate, _endDate, _auditYear), conStr); }