Exemple #1
0
        public static dynamic DeleteItem(DMTinhThanh dto)
        {
            DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "DanhMuc_TinhThanh",
                                                            new string[] { "@flag", "@Id", "@ModifiedBy" },
                                                            new object[] { "DeleteItem", dto.Id, dto.ModifiedBy });

            return((from r in tabl.AsEnumerable()
                    select new
            {
                N = (int)(r["N"]),
            }).FirstOrDefault());
        }
Exemple #2
0
        public static dynamic SaveItem(DMTinhThanh dto)
        {
            DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "DanhMuc_TinhThanh",
                                                            new string[] { "@flag", "@Id", "@Ten", "@Ma", "@MoTa", "@TrangThai", "@CreatedBy", "@CreatedDate", "@ModifiedBy", "@ModifiedDate", "@Deleted" },
                                                            new object[] { "SaveItem", dto.Id, dto.Ten, dto.Ma, dto.MoTa, dto.TrangThai, dto.CreatedBy, dto.CreatedDate, dto.ModifiedBy, dto.ModifiedDate, dto.Deleted });

            return((from r in tabl.AsEnumerable()
                    select new
            {
                N = (int)(r["N"]),
            }).FirstOrDefault());
        }