Exemplo n.º 1
0
        public void ImportMember(Models.CreateMemberForImportDo criteria)
        {
            db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
            {
                command.CommandText = "[dbo].[sp_Import_Member]";
                command.CommandType = System.Data.CommandType.StoredProcedure;

                command.AddParameter(typeof(string), "ImportTransactionID", criteria.ImportTransactionID);
                command.AddParameter(typeof(DateTime), "CreateDate", criteria.CreateDate);
                command.AddParameter(typeof(string), "CreateUser", criteria.CreateUser);

                command.ExecuteNonQuery();
            }));
        }
Exemplo n.º 2
0
        public void CreateMemberImport(Models.CreateMemberForImportDo entity)
        {
            db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) =>
            {
                command.CommandText = "[dbo].[sp_Create_MemberImport]";
                command.CommandType = System.Data.CommandType.StoredProcedure;

                command.AddParameter(typeof(string), "ImportTransactionID", entity.ImportTransactionID);

                string memberXml = Utils.ConvertUtil.ConvertToXml_Store <Models.MemberImportDo>(entity.Members);
                command.AddParameter(typeof(string), "MemberImportXML", memberXml);

                command.AddParameter(typeof(bool), "FlagClear", entity.FlagClear);

                command.AddParameter(typeof(DateTime), "CreateDate", entity.CreateDate);
                command.AddParameter(typeof(string), "CreateUser", entity.CreateUser);

                command.ExecuteNonQuery();
            }));
        }