/ - Diff - MARKUS - 일정관리

+    	{
     		public DOCPAGERepository(string connectionString, DBMSType DBMS) : base(connectionString, DBMS)
+    		{
                 if (this.DBMS == DBMSType.POSTGRESQL)
                     if (NpgsqlConnection.GlobalTypeMapper.Mappings.Where(f => f.PgTypeName == "type_insert_docpage").Count() == 0)
                         NpgsqlConnection.GlobalTypeMapper.MapComposite<InsertDocPage>("type_insert_docpage");
                 if (NpgsqlConnection.GlobalTypeMapper.Mappings.Where(f => f.PgTypeName == "type_insert_docpage").Count() == 0)
                     NpgsqlConnection.GlobalTypeMapper.MapComposite<InsertDocPage>("type_insert_docpage");
+            }
-...
     					result = true;
+    				}
     				else if (this.DBMS == DBMSType.POSTGRESQL)
+    				{
                         var items = docPages.Select(x => new InsertDocPage {docinfo_id = x.ID,
                                                                                         page_number = x.PAGE_NUMBER,
                                                                                         page_angle = x.PAGE_ANGLE,
                                                                                         page_height = x.PAGE_HEIGHT,
                                                                                         page_width = x.PAGE_WIDTH }).ToArray();
+                    {
                         var items = docPages.Select(x => new InsertDocPage
+                        {
                             docinfo_id = x.DOCINFO_ID,
                             page_number = x.PAGE_NUMBER,
                             page_angle = x.PAGE_ANGLE,
                             page_height = x.PAGE_HEIGHT,
                             page_width = x.PAGE_WIDTH
                         }).ToArray< InsertDocPage>();
                         var tran = BeginTransaction();
                         NpgsqlCommand command = new NpgsqlCommand("convert_insert_docpage", (NpgsqlConnection)this.Connection);
                         command.CommandType = CommandType.StoredProcedure;
                         var cmdParam = command.CreateParameter();
                         cmdParam.ParameterName = "docpages";
                         cmdParam.DbType = DbType.Object;
-...
     			return result;
+    		}
             // call stored procedure at data access layer for example StudentDAL.cs
             public void CallStoredResultSet<T>(InsertDocPage[] inputParameters) where T : class
+            {
                 //var conn = _GetOpenConnection();
                 //var tran = _BeginTransaction(conn);
                 var tran = BeginTransaction();
                 NpgsqlCommand command = new NpgsqlCommand("convert_insert_docpage", (NpgsqlConnection)this.Connection);
                 command.CommandType = CommandType.StoredProcedure;
                 var cmdParam = command.CreateParameter();
                 cmdParam.ParameterName = "docpages";
                 cmdParam.DbType = DbType.Object;
                 cmdParam.Value = inputParameters;
                 cmdParam.DataTypeName = "type_insert_docpage[]";
                 command.Parameters.Add(cmdParam);
                 command.Transaction = (Npgsql.NpgsqlTransaction)tran;
                 //await command.ExecuteNonQueryAsync();
                 tran.Commit();
+            }
             public class InsertDocPage
+    		{
                 [PgName("docinfo_id")]
-...
                 public string page_height { get; set; }
                 [PgName("page_angle")]
                 public int page_angle { get; set; }
                 public InsertDocPage()
+                {
+                }
+            }
+    	}

                     newConvertDocIDs.Add(newConvertDocID);
                     Console.WriteLine($"new id : {newConvertDocID}");
                     Assert.Pass(newConvertDocID);
                     var newConvertDocID2 = repository.CreateAsync(ProjectNo, docUri, "A1111111").GetAwaiter().GetResult();
                     newConvertDocIDs.Add(newConvertDocID2);
-...
                     newConvertDocIDs.Add(newConvertDocID);
                     Console.WriteLine($"new id : {newConvertDocID}");
                     Assert.Pass(newConvertDocID);
                     var newConvertDocID2 = repository.Create(ProjectNo, docUri, "A1111111").GetAwaiter().GetResult();

                     newConvertDocIDs.Add(newConvertDocID);
                     Console.WriteLine($"new id : {newConvertDocID}");
                     Assert.Pass(newConvertDocID);
                     var newConvertDocID2 = repository.CreateAsync(ProjectNo, docUri, "A1111111").GetAwaiter().GetResult();
                     newConvertDocIDs.Add(newConvertDocID2);
-...
                     newConvertDocIDs.Add(newConvertDocID);
                     Console.WriteLine($"new id : {newConvertDocID}");
                     Assert.Pass(newConvertDocID);
                     var newConvertDocID2 = repository.Create(ProjectNo, docUri, "A1111111").GetAwaiter().GetResult();
                     newConvertDocIDs.Add(newConvertDocID2);

                 using (Markus.Service.DataBase.Repositories.ConvertDocRepository repository = new Repositories.ConvertDocRepository(ConnectionStr, dbtype)) {
                     newConvertDocID = repository.CreateAsync(ProjectNo, docUri, "111111").GetAwaiter().GetResult();
                     Console.WriteLine($"new id : {newConvertDocID}");
                     Assert.Pass(newConvertDocID);
+                }
                 if (!string.IsNullOrEmpty(newConvertDocID)) {

ConvertService/ServiceBase/Markus.Service.DataBase.Test/DataBaseDocInfoPG.cs
15	15	{
16	16	newConvertDocID = repository.CreateAsync(ProjectNo, docUri, "111111").GetAwaiter().GetResult();
17	17	Console.WriteLine($"new id : {newConvertDocID}");
18		Assert.Pass(newConvertDocID);
	18
19	19	}
20	20
21	21	if (!string.IsNullOrEmpty(newConvertDocID))

ConvertService/ServiceBase/Markus.Service.DataBase.Test/DataBaseDocPage.cs
15	15	{
16	16	newConvertDocID = repository.CreateAsync(ProjectNo, docUri, "111111").GetAwaiter().GetResult();
17	17	Console.WriteLine($"new id : {newConvertDocID}");
18		Assert.Pass(newConvertDocID);
19	18	}
20	19
21	20	if (!string.IsNullOrEmpty(newConvertDocID))
...	...
25	24	newDocInfo = repository.CreateAsync(newConvertDocID, 10).GetAwaiter().GetResult();
26	25
27	26	Console.WriteLine($"new id : {newDocInfo}");
28		Assert.Pass(newDocInfo);
29	27	}
30	28
31	29
...	...
45	43	{
46	44	Assert.Pass();
47	45	}
48		else
49		{
50		Assert.Fail();
51		}
	46
	47
52	48	}
53	49	}
54		else
55		{
56		Assert.Fail();
57		}
58	50	}
59
	51	Assert.Fail();
60	52	}
61	53	}
62	54	}

ConvertService/ServiceBase/Markus.Service.DataBase.Test/DataBaseDocPagePG.cs
16	16	{
17	17	newConvertDocID = repository.CreateAsync(ProjectNo, docUri, "111111").GetAwaiter().GetResult();
18	18	Console.WriteLine($"new id : {newConvertDocID}");
19		Assert.Pass(newConvertDocID);
20	19	}
21	20
22	21	if (!string.IsNullOrEmpty(newConvertDocID))
...	...
26	25	newDocInfo = repository.CreateAsync(newConvertDocID, 10).GetAwaiter().GetResult();
27	26
28	27	Console.WriteLine($"new id : {newDocInfo}");
29		Assert.Pass(newDocInfo);
30	28	}
31	29
32	30
...	...
36	34	{
37	35	List<Entities.DOCPAGE> pages = new List<Entities.DOCPAGE>();
38	36
39		for (int i = 0; i < 1000; i++)
	37	for (int i = 0; i < 20000; i++)
40	38	{
41	39	pages.Add(new Entities.DOCPAGE { DOCINFO_ID = newDocInfo, PAGE_NUMBER = i + 1, PAGE_WIDTH = "1210", PAGE_HEIGHT = "1210", PAGE_ANGLE = 0 });
42	40	}
...	...
46	44	{
47	45	Assert.Pass();
48	46	}
49		else
50		{
51		Assert.Fail();
52		}
	47
	48
53	49	}
54	50	}
55		else
56		{
57		Assert.Fail();
58		}
59	51	}
60
	52	Assert.Fail();
61	53	}
62	54	}
63	55	}

ID	c1946e9c3be8e1b6fb7fff6b5a9671ce1abdbdc9
상위	9f42e700
하위	6fb40c43, 6a19b48d

프로젝트

일반

사용자정보

MARKUS

개정판 c1946e9c