/// <summary>
/// 設定作品是否加入包裝
/// </summary>
/// <param name="PackagesNo">包裝序號</param>
/// <param name="WorksNo">作品序號</param>
/// <param name="ShowJoin">是否加入包裝</param>
/// <returns></returns>
public static bool SetPackageItemJoin(string PackagesNo, string WorksNo, bool ShowJoin)
{
using (var context = new EG_MagicCubeEntities())
{
var Guid_PackagesNo = Guid.Parse(PackagesNo.ToUpper());
var Guid_WorksNo = Guid.Parse(WorksNo.ToUpper());
var PackageItemList = context.PackageItems.AsQueryable().Where(x => x.PackagesNo == Guid_PackagesNo && x.WorksNo == Guid_WorksNo).Select(c => c).ToList();
if (PackageItemList != null | PackageItemList.Count > 0)
{
foreach (PackageItems _PackageItem in PackageItemList)
{
_PackageItem.IsJoin = ShowJoin ? "Y" : "N";
_PackageItem.JoinDate = DateTime.Now;
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
public static bool SetConfigure(string strConfigureClass, string strConfigureValue)
{
using (var context = new EG_MagicCubeEntities())
{
var oSystemConfigure = context.SystemConfigure.AsQueryable().First(x => x.ConfigureName == strConfigureClass);
if (oSystemConfigure != null)
{
oSystemConfigure.ConfigureValue = strConfigureValue;
}
else
{
SystemConfigure new_SystemConfigure = new SystemConfigure()
{
};
new_SystemConfigure.ConfigureName = strConfigureClass;
new_SystemConfigure.ConfigureValue = strConfigureValue;
context.SystemConfigure.Add(new_SystemConfigure);
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
private bool Insert()
{
bool IsInsert = false;
using (var context = new EG_MagicCubeEntities())
{
context.ET_MASTER.Add(new EG_MagicCubeEntity.ET_MASTER()
{
MATNR = this.MATNR,
ZZCT = this.ZZCT,
NAME1 = this.NAME1,
ZFPRESERVE_D = this.ZFPRESERVE_D,
ZZSE = this.ZZSE,
LOCATION = this.LOCATION,
STATUS = this.STATUS,
STPRS = this.STPRS,
NETPR = this.NETPR,
WAERS = this.WAERS,
ERDAT = this.ERDAT,
UDATE = this.UDATE,
});
if (context.SaveChanges() == 0)
{
IsInsert = true;
}
}
return(IsInsert);
}
/// <summary>
/// 刪除包裝項目
/// </summary>
/// <param name="PackagesNo">包裝序號</param>
/// <param name="WorksNo">作品序號</param>
/// <returns></returns>
public static bool DeletePackageItem(string PackagesNo, string WorksNo)
{
using (var context = new EG_MagicCubeEntities())
{
var Guid_PackagesNo = Guid.Parse(PackagesNo.ToUpper());
var Guid_WorksNo = Guid.Parse(WorksNo.ToUpper());
var PackageItemList = context.PackageItems.AsQueryable().Where(x => x.PackagesNo == Guid_PackagesNo && x.WorksNo == Guid_WorksNo).Select(c => c).ToList();
if (PackageItemList != null | PackageItemList.Count > 0)
{
foreach (PackageItems _PackageItem in PackageItemList)
{
context.PackageItems.Remove(_PackageItem);
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
/// <summary>
/// 帳號資料更新
/// </summary>
/// <param name="newPackages">新帳號資料</param>
/// <returns></returns>
public static bool Update(AccountModel newAccountModel)
{
using (var context = new EG_MagicCubeEntities())
{
var oldUserAccount = context.UserAccounts.First(x => x.UserAccountsNo == newAccountModel.UserAccountsNo);
if (newAccountModel.Password != "nopwdnopwd" && newAccountModel.Password_Confirm != "nopwdnopwd")
{
if (oldUserAccount.Password != newAccountModel.Password)
{
PasswordHandler _PasswordHandler = new PasswordHandler(newAccountModel.Password);
oldUserAccount.Password = _PasswordHandler.EnStrPw;
oldUserAccount.Pwdself = _PasswordHandler.SaltKey;
}
}
oldUserAccount.UserAccount = newAccountModel.UserAccount;
oldUserAccount.Name = newAccountModel.Name;
oldUserAccount.RoleNo = newAccountModel.RoleNo;
oldUserAccount.AccountNote = newAccountModel.AccountNote;
oldUserAccount.AccountStatus = newAccountModel.AccountStatus;
oldUserAccount.ModifyUser = HttpContext.Current?.User?.Identity?.Name ?? "";
oldUserAccount.ModifyDate = DateTime.Now;
oldUserAccount.ErrorCount = newAccountModel.ErrorCount;
if (context.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
/// <summary>
/// 取得帳號明細
/// </summary>
/// <param name="UserAccountsNo"></param>
/// <returns></returns>
public static AccountModel GetAccountModelDetail(string UserAccountsNo)
{
AccountModel _AccountModel = new AccountModel();
int int_UserAccountsNo = int.Parse(UserAccountsNo);
using (var context = new EG_MagicCubeEntities())
{
if (context.UserAccounts.Count() > 0)
{
_AccountModel = context.UserAccounts.AsEnumerable().Where(c => c.IsDel != "Y" && c.UserAccountsNo == int_UserAccountsNo).Select(c =>
new AccountModel()
{
UserAccountsNo = c.UserAccountsNo,
Name = c.Name,
UserAccount = c.UserAccount,
Password = c.Password,
Password_Confirm = c.Password,
Pwdself = c.Password,
AccountStatus = c.AccountStatus,
AccountNote = c.AccountNote,
RoleNo = c.RoleNo,
CreateDate = c.CreateDate,
CreateUser = c.CreateUser,
ModifyDate = c.ModifyDate.Value,
ModifyUser = c.ModifyUser,
ErrorCount = c.ErrorCount
}).FirstOrDefault();
}
}
return(_AccountModel);
}
/// <summary>
/// 登入
/// </summary>
/// <param name="strAccount">帳號</param>
/// <param name="strPwd">密碼</param>
/// <param name="IsAccount">帳號是否存在</param>
/// <param name="IsPwd">帳號是否正確</param>
/// <returns></returns>
public static AccountModel Login(string strAccount, string strPwd, out bool IsAccount, out bool IsPwd)
{
IsPwd = false;
IsAccount = true;
AccountModel _AccountModel = null;
using (var context = new EG_MagicCubeEntities())
{
var UserAccount = context.UserAccounts?.AsQueryable()?.FirstOrDefault(c => c.IsDel != "Y" && c.UserAccount == strAccount);
if (UserAccount != null)
{
//判斷密碼是否正確
IsPwd = PasswordHandler.CompareEncryptHashString(strPwd, UserAccount.Pwdself, UserAccount.Password);
_AccountModel = new AccountModel()
{
UserAccountsNo = UserAccount.UserAccountsNo,
Name = UserAccount.Name,
UserAccount = UserAccount.UserAccount,
Password = UserAccount.Password,
Password_Confirm = UserAccount.Password,
Pwdself = UserAccount.Pwdself,
ErrorCount = UserAccount.ErrorCount,
AccountStatus = UserAccount.AccountStatus,
AccountNote = UserAccount.AccountNote,
RoleNo = UserAccount.RoleNo,
CreateDate = UserAccount.CreateDate,
CreateUser = UserAccount.CreateUser,
ModifyDate = UserAccount.ModifyDate.Value,
ModifyUser = UserAccount.ModifyUser
};
//密碼正確且錯誤次數小於10
if (IsPwd && _AccountModel.ErrorCount < 10)
{
if (_AccountModel.AccountStatus != "L")
{
_AccountModel.ErrorCount = 0;
AccountModel.Update(_AccountModel);
}
}
else
{
_AccountModel.ErrorCount = _AccountModel.ErrorCount + 1;
if (_AccountModel.ErrorCount >= 10)
{
_AccountModel.AccountStatus = "L";
}
AccountModel.Update(_AccountModel);
}
IsAccount = true;
}
else
{
IsAccount = false;
}
}
return(_AccountModel);
}
/// <summary>
/// 新增帳號
/// </summary>
/// <returns></returns>
public bool Create()
{
using (var context = new EG_MagicCubeEntities())
{
UserAccounts _UserAccounts = new UserAccounts();
_UserAccounts.UserAccount = this.UserAccount;
_UserAccounts.Name = this.Name;
PasswordHandler _PasswordHandler = new PasswordHandler(this.Password);
_UserAccounts.Password = this.Password = _PasswordHandler.EnStrPw;
_UserAccounts.Pwdself = this.Pwdself = _PasswordHandler.SaltKey;
_UserAccounts.RoleNo = this.RoleNo;
_UserAccounts.AccountStatus = this.AccountStatus;
_UserAccounts.AccountNote = this.AccountNote;
_UserAccounts.CreateDate = DateTime.Now;
_UserAccounts.CreateUser = HttpContext.Current?.User?.Identity?.Name ?? "";
_UserAccounts.ModifyUser = HttpContext.Current?.User?.Identity?.Name ?? "";
_UserAccounts.ModifyDate = DateTime.Now;
_UserAccounts.IsDel = "";
_UserAccounts.ErrorCount = 0;
context.UserAccounts.Add(_UserAccounts);
if (context.SaveChanges() == 0)
{
this.UserAccountsNo = _UserAccounts.UserAccountsNo;
return(false);
}
}
return(true);
}
/// <summary>
/// 刪除包裝
/// </summary>
/// <param name="PackagesNo">包裝序號</param>
/// <returns></returns>
public static bool Delete(string PackagesNo)
{
using (var context = new EG_MagicCubeEntities())
{
var Guid_PackagesNo = Guid.Parse(PackagesNo.ToUpper());
var package = context.Packages.AsQueryable().FirstOrDefault(x => x.PackagesNo == Guid_PackagesNo);
if (package != null)
{
package.IsDel = "Y";
package.ModifyUser = HttpContext.Current?.User?.Identity?.Name ?? "";
package.ModifyDate = DateTime.Now;
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
/// <summary>
/// 新增包裝
/// </summary>
/// <returns></returns>
public bool Create()
{
using (var context = new EG_MagicCubeEntities())
{
Packages _Package = new Packages();
_Package.PackagesNo = Guid.NewGuid();
this.PackagesNo = _Package.PackagesNo.ToString();
string BeforeName = "誠品畫廊推薦";
string strNowDate = DateTime.Now.ToString("yyyyMMdd");
var oldName = context.Packages.AsQueryable().Where(c => (BeforeName + strNowDate).Contains(c.PackagesName)).Select(c => c.PackagesName).FirstOrDefault();
var NameCount = context.Packages.AsQueryable().Where(c => c.CreateDate >= System.DateTime.Today).Count();
string NewPackagesName = "";
NewPackagesName = BeforeName + strNowDate + (NameCount + 1).ToString().PadLeft(2, '0');
_Package.PackagesName = NewPackagesName;
_Package.EndDate = this.EndDate;
_Package.PackingDate = this.PackingDate;
_Package.PackagesMemo = this.PackagesMemo;
_Package.SearchJson = this.SearchJson;
_Package.CreateDate = DateTime.Now;
_Package.CreateUser = HttpContext.Current?.User?.Identity?.Name ?? "";
_Package.ModifyDate = DateTime.Now;
_Package.ModifyUser = HttpContext.Current?.User?.Identity?.Name ?? "";
_Package.Budget = this.Budget;
_Package.IsDel = "";
context.Packages.Add(_Package);
if (context.SaveChanges() > 0)
{
foreach (PackageItemModel _PackageItemModel in PackageItems)
{
Guid Guid_WorksNo = Guid.Parse(_PackageItemModel.WorksNo.ToUpper());
context.PackageItems.Add(new PackageItems()
{
PackagesNo = _Package.PackagesNo,
WorksNo = Guid_WorksNo,
JoinDate = DateTime.Now,
IsJoin = _PackageItemModel.IsJoin,
DelDate = new Nullable <DateTime>()
});
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
/// <summary>
/// 取得包裝明細
/// </summary>
/// <param name="PackagesNo">包裝編號</param>
/// <returns></returns>
public static PackagesModel GetPackageDetail(string PackagesNo)
{
PackagesModel _PackagesModel = new PackagesModel();
using (var context = new EG_MagicCubeEntities())
{
if (context.Packages.Count() > 0)
{
var Guid_PackagesNo = Guid.Parse(PackagesNo.ToUpper());
var r_Packages = context?.Packages?.AsQueryable()?.Where(f => f.IsDel != "Y" && f.PackagesNo == Guid_PackagesNo).Select(c => c).FirstOrDefault();
if (r_Packages != null)
{
var _PackageItems = context?.PackageItems?.AsQueryable()?.Where(pi => pi.PackagesNo == r_Packages.PackagesNo && pi.Works.IsDel != "Y").Select(c => c).ToList();
int _ItemAmount = 0;
int _JoinItemAmount = 0;
int _Summary = 0;
int _SumCost = 0;
_ItemAmount = (_PackageItems?.Count()).Value;
_JoinItemAmount = (_PackageItems?.Where(pi => pi.IsJoin == "Y").Count()).Value;
_Summary = _PackageItems.Where(pi => pi.IsJoin == "Y").Select(c => c.Works.Price).Sum();
_SumCost = _PackageItems.Where(pi => pi.IsJoin == "Y").Select(c => c.Works.Cost).Sum();
_PackagesModel.PackagesNo = r_Packages.PackagesNo.ToString();
_PackagesModel.QRImg = "";
_PackagesModel.PackagesName = r_Packages.PackagesName;
_PackagesModel.EndDate = r_Packages.EndDate;
_PackagesModel.PackingDate = r_Packages.PackingDate;
_PackagesModel.CreateDate = r_Packages.CreateDate;
_PackagesModel.CreateUser = r_Packages.CreateUser;
_PackagesModel.ModifyUser = r_Packages.ModifyUser;
_PackagesModel.ModifyDate = r_Packages.ModifyDate;
_PackagesModel.SearchJson = r_Packages.SearchJson;
_PackagesModel.PackagesMemo = r_Packages.PackagesMemo;
_PackagesModel.ItemAmount = _JoinItemAmount.ToString() + " (" + _ItemAmount.ToString() + ")";
_PackagesModel.Budget = r_Packages.Budget;
_PackagesModel.SumCost = _SumCost;
_PackagesModel.SumPrice = _Summary;
_PackagesModel.PackageItems = ReturnPackageItemList(PackagesNo, true);
//PackageItems = c.PackageItems.Select(pi => new PackageItemModel()
//{
// WorksNo = pi.WorksNo.ToString(),
// WorksName = pi.Works.WorksName,
// Price = pi.Works.Price,
// AuthorsName = pi.Works.WorksAuthors.FirstOrDefault().Authors.AuthorsCName,
// IsJoin = pi.IsJoin
//}
//).ToList()
}
}
}
return(_PackagesModel);
}
public static string GetFile(int WorksFilesNo)
{
string strStream = "";
using (var context = new EG_MagicCubeEntities())
{
if (context.WorksFiles.Count() > 0)
{
strStream = context.WorksFiles.AsQueryable().Where(c => c.WorksFilesNo == WorksFilesNo).Select(c => c.FileBase64Str).FirstOrDefault();
}
}
return(strStream);
}
/// <summary>
/// 新增藝術家
/// </summary>
/// <returns></returns>
public bool Create()
{
using (var context = new EG_MagicCubeEntities())
{
Authors _Authors = new Authors();
_Authors.AuthorsCName = this.AuthorsCName ?? "";
_Authors.AuthorsEName = this.AuthorsEName ?? "";
_Authors.CreateDate = DateTime.Now;
_Authors.CreateUser = this.CreateUser ?? "";
_Authors.ModifyDate = DateTime.Now;
_Authors.ModifyUser = this.ModifyUser ?? "";
_Authors.MaterialsID = "";
_Authors.IsDel = "";
_Authors.Rating = this.Rating ?? "";
_Authors.WorksAmount = this.WorksAmount;
context.Authors.Add(_Authors);
if (context.SaveChanges() > 0)
{
this.AuthorsNo = _Authors.AuthorsNo;
if (this.AuthorsAreaNo_InputString.Count > 0)
{
foreach (int _AuthorsAreaNo in this.AuthorsAreaNo_InputString.Select(n => Convert.ToInt32(n)).ToArray())
{
context.AuthorsPropArea.Add(new AuthorsPropArea()
{
AuthorsNo = this.AuthorsNo, AuthorsAreaNo = _AuthorsAreaNo
});
}
}
if (this.AuthorsTagNo_InputString.Count > 0)
{
foreach (int _AuthorsTagNo in this.AuthorsTagNo_InputString.Select(n => Convert.ToInt32(n)).ToArray())
{
context.AuthorsPropTag.Add(new AuthorsPropTag()
{
AuthorsNo = this.AuthorsNo, AuthorsTagNo = _AuthorsTagNo
});
}
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
/// <summary>
/// 以藝術家編號取得藝術家
/// </summary>
/// <param name="authorsNo">藝術家編號</param>
/// <returns></returns>
public static AuthorsModel GetAuthorDetail(int authorsNo)
{
AuthorsModel _AuthorsModel = new AuthorsModel();
using (var context = new EG_MagicCubeEntities())
{
if (context.Authors.Count() > 0)
{
var r_Authors = context?.Authors?.AsQueryable()?.Where(c => c.IsDel != "Y" && c.AuthorsNo == authorsNo).Select(c => c).FirstOrDefault();
if (r_Authors != null)
{
var r_AuthorsPropArea = context?.AuthorsPropArea?.AsQueryable()?.Where(c => c.AuthorsNo == r_Authors.AuthorsNo).ToList();
var r_AuthorsPropTag = context?.AuthorsPropTag?.AsQueryable()?.Where(c => c.AuthorsNo == r_Authors.AuthorsNo).ToList();
int _WorksAmount = (context?.WorksAuthors?.AsQueryable()?.Where(c => c.Author_No == r_Authors.AuthorsNo).Count()).Value;
_AuthorsModel.AuthorsNo = r_Authors.AuthorsNo;
_AuthorsModel.AuthorsCName = r_Authors.AuthorsCName;
_AuthorsModel.AuthorsEName = r_Authors.AuthorsEName;
if (r_AuthorsPropArea != null && r_AuthorsPropArea.Count > 0)
{
_AuthorsModel.AuthorsAreaNo_InputString = r_AuthorsPropArea.Select(apa => Convert.ToString(apa.AuthorsAreaNo)).ToList();
_AuthorsModel.AuthorsPropArea = r_AuthorsPropArea.Select(apa =>
new MenuViewModel()
{
MenuID = apa.Menu_AuthorsArea.AuthorsAreaNo, MenuName = apa.Menu_AuthorsArea.AuthorsAreaName
}).ToList();
}
if (r_AuthorsPropTag != null && r_AuthorsPropTag.Count > 0)
{
_AuthorsModel.AuthorsTagNo_InputString = r_AuthorsPropTag.Select(apt => Convert.ToString(apt.AuthorsTagNo)).ToList();
_AuthorsModel.AuthorsPropTag = r_AuthorsPropTag.Select(apa =>
new MenuViewModel()
{
MenuID = apa.Menu_AuthorsTag.AuthorsTagNo, MenuName = apa.Menu_AuthorsTag.AuthorsTagName
}).ToList();
}
_AuthorsModel.CreateDate = r_Authors.CreateDate;
_AuthorsModel.MaterialsID = r_Authors.MaterialsID;
_AuthorsModel.CreateUser = r_Authors.CreateUser;
_AuthorsModel.ModifyDate = r_Authors.ModifyDate.Value;
_AuthorsModel.ModifyUser = r_Authors.ModifyUser;
_AuthorsModel.WorksAmount = r_Authors.WorksAmount;
_AuthorsModel.Rating = r_Authors.Rating;
}
}
}
return(_AuthorsModel);
}
/// <summary>
/// 刪除檔案By 序號清單
/// </summary>
/// <param name="WorksFilesNoList">檔案序號清單</param>
/// <returns></returns>
public static bool DelFile(List <long> WorksFilesNoList)
{
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));
CloudBlobClient _CloudBlobClient = storageAccount.CreateCloudBlobClient();
CloudBlobContainer container = _CloudBlobClient.GetContainerReference("worksimg");
long[] WorksFilesNoArray = WorksFilesNoList.ToArray();
if (WorksFilesNoArray != null && WorksFilesNoArray.Length > 0)
{
using (var context = new EG_MagicCubeEntities())
{
var WorksFilesList = context.WorksFiles.AsQueryable().Where(c => WorksFilesNoArray.Contains(c.WorksFilesNo)).Select(c => c).ToList();
if (WorksFilesList != null)
{
foreach (var _WorksFiles in WorksFilesList)
{
string filename_o = _WorksFiles.File_o_Url.Substring(_WorksFiles.File_o_Url.LastIndexOf("/") + 1);
CloudBlockBlob blockBlob = container.GetBlockBlobReference(filename_o);
if (blockBlob.Exists())
{
blockBlob.Delete();
}
string filename_m = _WorksFiles.File_m_Url.Substring(_WorksFiles.File_m_Url.LastIndexOf("/") + 1);
CloudBlockBlob blockBlob_m = container.GetBlockBlobReference(filename_m);
if (blockBlob_m.Exists())
{
blockBlob_m.Delete();
}
string filename_s = _WorksFiles.File_s_Url.Substring(_WorksFiles.File_s_Url.LastIndexOf("/") + 1);
CloudBlockBlob blockBlob_s = container.GetBlockBlobReference(filename_s);
if (blockBlob_s.Exists())
{
blockBlob_s.Delete();
}
context.WorksFiles.Remove(_WorksFiles);
}
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
}
else
{
return(false);
}
return(true);
}
/// <summary>
/// 批次新增檔案
/// </summary>
/// <param name="WorksNo">作品序號</param>
/// <param name="UploadWorksFiles">http檔案清單</param>
/// <returns></returns>
public static bool InsFile(string WorksNo, List <byte[]> UploadWorksFiles)
{
Guid Guid_WorksNo = Guid.Parse(WorksNo);
if (UploadWorksFiles != null)
{
using (var context = new EG_MagicCubeEntities())
{
foreach (byte[] _Files in UploadWorksFiles)
{
if (_Files != null)
{
//byte[] thePictureAsBytes = new byte[_Files.ContentLength];
////string filebase64 = "";
//using (BinaryReader theReader = new BinaryReader(_Files.InputStream))
//{
// thePictureAsBytes = theReader.ReadBytes(_Files.ContentLength);
// //filebase64 = Convert.ToBase64String(thePictureAsBytes);
//}
string FileName_o = Math.Abs(Guid.NewGuid().GetHashCode()).ToString() + ".jpg";
string FileName_m = Math.Abs(Guid.NewGuid().GetHashCode()).ToString() + ".jpg";
string FileName_s = Math.Abs(Guid.NewGuid().GetHashCode()).ToString() + ".jpg";
byte[] FileBinary_o = ImgFileToFileBinary(new MagickImage(_Files), 0, 70);
byte[] FileBinary_m = ImgFileToFileBinary(new MagickImage(_Files), 800, 70);
byte[] FileBinary_s = ImgFileToFileBinary(new MagickImage(_Files), 200, 40);
string img_o_url = SaveToAzure(FileName_o, FileBinary_o);
string img_m_url = SaveToAzure(FileName_m, FileBinary_m);
string img_s_url = SaveToAzure(FileName_s, FileBinary_s);
context.WorksFiles.Add(new WorksFiles()
{
WorksNo = Guid_WorksNo, Sorting = 0, FileBase64Str = Convert.ToBase64String(FileBinary_s), File_o_Url = img_o_url, File_m_Url = img_m_url, File_s_Url = img_s_url
});
}
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
}
else
{
return(false);
}
return(true);
}
/// <summary>
/// 以包裝資料更新
/// </summary>
/// <param name="newPackages">新包裝資料</param>
/// <returns></returns>
public static bool Update(PackagesModel newPackages)
{
using (var context = new EG_MagicCubeEntities())
{
var Guid_PackagesNo = Guid.Parse(newPackages.PackagesNo.ToUpper());
var oldPackages = context.Packages.AsQueryable().First(x => x.PackagesNo == Guid_PackagesNo);
if (oldPackages != null)
{
if (!string.IsNullOrEmpty(newPackages.PackagesName))
{
oldPackages.PackagesName = newPackages.PackagesName;
}
oldPackages.PackingDate = newPackages.PackingDate;
oldPackages.EndDate = newPackages.EndDate;
oldPackages.ModifyUser = HttpContext.Current?.User?.Identity?.Name ?? "";
oldPackages.ModifyDate = newPackages.ModifyDate;
oldPackages.PackagesMemo = newPackages.PackagesMemo;
oldPackages.SearchJson = newPackages.SearchJson;
oldPackages.Budget = newPackages.Budget;
var _PackageItems = context.PackageItems.AsQueryable().Where(c => c.PackagesNo == oldPackages.PackagesNo).ToList();
foreach (PackageItemModel _PackageItemModel in newPackages.PackageItems)
{
var Guid_WorksNo = Guid.Parse(_PackageItemModel.WorksNo.ToUpper());
int PackageItemCount = _PackageItems.Where(c => c.WorksNo == Guid_WorksNo).Count();
if (PackageItemCount == 0)
{
context.PackageItems.Add(new PackageItems()
{
PackagesNo = oldPackages.PackagesNo,
WorksNo = Guid_WorksNo,
JoinDate = DateTime.Now,
IsJoin = _PackageItemModel.IsJoin,
DelDate = new Nullable <DateTime>()
});
}
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
/// <summary>
/// 取得檔案清單
/// </summary>
/// <param name="WorksNo"></param>
/// <param name="PageIndex">頁碼</param>
/// <param name="PageSize">每頁筆數</param>
/// <returns></returns>
public static List <FileGroup> GetFileList(string WorksNo, int PageIndex = 1, int PageSize = 10)
{
Guid Guid_WorksNo = Guid.Parse(WorksNo);
List <FileGroup> _FileList = new List <FileGroup>();
using (var context = new EG_MagicCubeEntities())
{
if (context.WorksFiles.Count() > 0)
{
_FileList = context.WorksFiles.AsQueryable().Where(c => c.WorksNo == Guid_WorksNo).OrderBy(c => c.Sorting).ThenBy(c => c.WorksFilesNo).Select(c => new FileGroup()
{
WorksFilesNo = c.WorksFilesNo, FileBase64 = c.FileBase64Str, File_o_Url = c.File_o_Url, File_m_Url = c.File_m_Url, File_s_Url = c.File_s_Url, Sorting = c.Sorting
}).ToList();
}
}
return(_FileList);
}
/// <summary>
/// 計算作品分級
/// </summary>
/// <param name="_WorksModel"></param>
/// <returns></returns>
public static int CalculateWorksRating(WorksModel _WorksModel)
{
double _Rating = 0;
int _WorksAmount = 0;
using (var context = new EG_MagicCubeEntities())
{
foreach (int _AuthorNo in _WorksModel.AuthorNo_InputString.Select(n => Convert.ToInt32(n)).ToArray())
{
_WorksAmount = _WorksAmount + (context?.WorksAuthors?.AsQueryable().Where(c => c.Author_No == _AuthorNo).Count()).Value;
}
}
_WorksAmount = (_WorksAmount + 1) / _WorksModel.AuthorNo_InputString.Select(n => Convert.ToInt32(n)).Count();
double _AuthorsRating = Convert.ToDouble(AuthorsModel.CalculateAuthorsRating(_WorksAmount));
_Rating = (_WorksModel.Marketability * 0.3) + (_WorksModel.Packageability * 0.1) + (_WorksModel.Valuability * 0.25) + (_WorksModel.Artisticability * 0.2) + (_AuthorsRating * 0.15);
return(Convert.ToInt32(_Rating));
}
public static SystemGeneralModel GetConfigure(string strConfigureClass)
{
SystemGeneralModel _SystemGeneralModel = new SystemGeneralModel();
using (var context = new EG_MagicCubeEntities())
{
if (context.SystemConfigure.Count() > 0)
{
_SystemGeneralModel = context.SystemConfigure.AsQueryable().Where(c => c.ConfigureName == strConfigureClass).Select(c => new SystemGeneralModel()
{
ConfigureClass = c.ConfigureName, ConfigureContent = c.ConfigureValue
}).FirstOrDefault();
}
if (_SystemGeneralModel == null)
{
_SystemGeneralModel = new SystemGeneralModel();
_SystemGeneralModel.ConfigureClass = strConfigureClass;
}
}
return(_SystemGeneralModel);
}
/// <summary>
/// 更新包裝項目
/// </summary>
/// <param name="PackagesNo">包裝序號</param>
/// <param name="PackageItemModelList">包裝項目清單</param>
/// <returns></returns>
public static bool UpdatePackageItem(string PackagesNo, List <PackageItemModel> PackageItemModelList)
{
using (var context = new EG_MagicCubeEntities())
{
var Guid_PackagesNo = Guid.Parse(PackagesNo.ToUpper());
var oldPackages = context.Packages.AsQueryable().First(x => x.PackagesNo == Guid_PackagesNo);
var _PackageItems = context.PackageItems.AsQueryable().Where(c => c.PackagesNo == oldPackages.PackagesNo).ToList();
if (oldPackages != null)
{
foreach (PackageItemModel _PackageItemModel in PackageItemModelList)
{
var Guid_WorksNo = Guid.Parse(_PackageItemModel.WorksNo.ToUpper());
int PackageItemCount = _PackageItems.Where(c => c.WorksNo == Guid_WorksNo).Count();
if (PackageItemCount == 0)
{
context.PackageItems.Add(new PackageItems()
{
PackagesNo = oldPackages.PackagesNo,
WorksNo = Guid_WorksNo,
JoinDate = DateTime.Now,
IsJoin = _PackageItemModel.IsJoin,
DelDate = new Nullable <DateTime>()
});
}
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
public static bool Delete(int authorNo)
{
using (var context = new EG_MagicCubeEntities())
{
var author = context.Authors.FirstOrDefault(x => x.AuthorsNo == authorNo);
if (author != null)
{
author.ModifyUser = HttpContext.Current?.User?.Identity?.Name ?? "";
author.ModifyDate = DateTime.Now;
author.IsDel = "Y";
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
public static bool Delete(int UserAccountsNo)
{
using (var context = new EG_MagicCubeEntities())
{
var UserAccount = context.UserAccounts.FirstOrDefault(x => x.UserAccountsNo == UserAccountsNo);
if (UserAccount != null)
{
UserAccount.IsDel = "Y";
UserAccount.ModifyUser = HttpContext.Current?.User?.Identity?.Name ?? "";
UserAccount.ModifyDate = DateTime.Now;
if (context.SaveChanges() == 0)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
/// <summary>
/// 更新排序
/// </summary>
/// <param name="_FileSortingItemList"></param>
/// <returns></returns>
public static bool UpdateSorting(FileSortingItem [] _FileSortingItemList)
{
if (_FileSortingItemList != null)
{
using (var context = new EG_MagicCubeEntities())
{
foreach (FileSortingItem _FileSortingItem in _FileSortingItemList)
{
var _File = context.WorksFiles.AsQueryable().FirstOrDefault(c => c.WorksFilesNo == _FileSortingItem.WorksFilesNo);
if (_File != null)
{
_File.Sorting = _FileSortingItem.Sorting;
}
if (context.SaveChanges() == 0)
{
}
}
}
}
return(true);
}
public static bool BatchInsert(ET_MASTER [] ET_MASTERArray)
{
bool IsInsert = false;
using (var context = new EG_MagicCubeEntities())
{
foreach (var _ET_MASTER in ET_MASTERArray)
{
context.ET_MASTER.Add(new EG_MagicCubeEntity.ET_MASTER()
{
MATNR = _ET_MASTER.MATNR,
ZZCT = _ET_MASTER.ZZCT,
NAME1 = _ET_MASTER.NAME1,
ZFPRESERVE_D = _ET_MASTER.ZFPRESERVE_D,
ZZSE = _ET_MASTER.ZZSE,
LOCATION = _ET_MASTER.LOCATION,
STATUS = _ET_MASTER.STATUS,
STPRS = _ET_MASTER.STPRS,
NETPR = _ET_MASTER.NETPR,
WAERS = _ET_MASTER.WAERS,
ERDAT = _ET_MASTER.ERDAT,
UDATE = _ET_MASTER.UDATE,
CreateTime = DateTime.Now,
IsNew = "N",
IsSync = "",
SyncTime = null,
SyncUser = ""
});
}
if (context.SaveChanges() == 0)
{
IsInsert = true;
}
}
return(IsInsert);
}
/// <summary>
/// 搜尋
/// </summary>
/// <param name="PageIndex">頁碼，從1開始0為不分頁</param>
/// <param name="PageSize">每頁筆數，0為不分頁</param>
/// <returns></returns>
public List <WorksModel> Search(int PageIndex = 0, int PageSize = 0)
{
//if (PageIndex == 0) PageIndex = 0;
List <WorksModel> _WorksModel = new List <WorksModel>();
using (var context = new EG_MagicCubeEntities())
{
if (context.Works.Count() > 0)
{
var r = context.Works?.AsQueryable().Where(f => f.IsDel != "Y");
if (!string.IsNullOrEmpty(this.WorksNo))
{
r = r.Where(f => f.WorksNo == Guid.Parse(WorksNo.ToUpper()));
}
if (!string.IsNullOrEmpty(this.WorksName))
{
r = r.Where(f => f.WorksName.Contains(this.WorksName));
}
//價格
if (this.MinePrice > 0)
{
r = r.Where(f => f.Price >= this.MinePrice);
}
if (this.MaxPrice > 0)
{
r = r.Where(f => f.Price <= this.MaxPrice);
}
List <Guid> _WorksNoList = new List <Guid>();
#region 組件查詢
var rwm = context.WorksModules?.AsQueryable();
//長度
if (this.MineLength > 0)
{
rwm = rwm.Where(f => f.Length >= this.MineLength);
}
if (this.MaxLength > 0)
{
rwm = rwm.Where(f => f.Length <= this.MaxLength);
}
//寬度
if (this.MineWidth > 0)
{
rwm = rwm.Where(f => f.Width >= this.MineWidth);
}
if (this.MaxLength > 0)
{
rwm = rwm.Where(f => f.Width <= this.MaxWidth);
}
//高度
if (this.MineHeight > 0)
{
rwm = rwm.Where(f => f.Height >= this.MineHeight);
}
if (this.MaxHeight > 0)
{
rwm = rwm.Where(f => f.Height <= this.MaxHeight);
}
//深度
if (this.MineDeep > 0)
{
rwm = rwm.Where(f => f.Deep >= this.MineDeep);
}
if (this.MaxDeep > 0)
{
rwm = rwm.Where(f => f.Deep <= this.MaxDeep);
}
//時間長度
if (this.MineTimeLength > 0)
{
rwm = rwm.Where(f => Convert.ToInt16(f.TimeLength) >= this.MineTimeLength);
}
if (this.MaxTimeLength > 0)
{
rwm = rwm.Where(f => Convert.ToInt16(f.TimeLength) <= this.MaxTimeLength);
}
var _wkno = rwm.Select(c => c.WorksNo).ToList();
if (_wkno != null && _wkno.Count > 0)
{
_WorksNoList.AddRange(_wkno);
}
if (_WorksNoList != null && _WorksNoList.Count > 0)
{
_WorksNoList = _WorksNoList.Distinct().ToList();
}
//取得組件符合搜尋條件的作品列表
#endregion
int FilterCount = 1;
//藝術家
if (this.AuthorNoList != null && this.AuthorNoList.Count > 0)
{
FilterCount++;
int[] _AuthorNoArray = this.AuthorNoList.ConvertAll(s => int.Parse(s)).ToArray();
var _wawkno = context.WorksAuthors?.AsQueryable()?.Where(wa => _AuthorNoArray.Contains(wa.Author_No)).Select(c => c.Works_No).ToList();
if (_wawkno != null && _wawkno.Count > 0)
{
_WorksNoList.AddRange(_wawkno);
}
//r = r.Where(f => f.WorksAuthors.Any(wa => this.AuthorNoList.Contains(wa.Author_No.ToString())));
}
//類型
if (this.GenreNoList != null && this.GenreNoList.Count > 0)
{
FilterCount++;
int[] _GenreNoArray = this.GenreNoList.ConvertAll(s => int.Parse(s)).ToArray();
var wpgwkno = context.WorksPropGenre?.AsQueryable()?.Where(c => _GenreNoArray.Contains(c.GenreNo)).Select(c => c.WorksNo).ToList();
if (wpgwkno != null && wpgwkno.Count > 0)
{
_WorksNoList.AddRange(wpgwkno);
}
//r = r.Where(f => f.WorksPropGenre.Any(wpg => _GenreNoArray.Contains(wpg.GenreNo)));
}
//風格
if (this.StyleNoList != null && this.StyleNoList.Count > 0)
{
FilterCount++;
int[] _StyleNoList = this.StyleNoList.ConvertAll(s => int.Parse(s)).ToArray();
var wpswkno = context.WorksPropStyle?.AsQueryable()?.Where(c => _StyleNoList.Contains(c.StyleNo)).Select(c => c.WorksNo).ToList();
if (wpswkno != null && wpswkno.Count > 0)
{
_WorksNoList.AddRange(wpswkno);
}
//r = r.Where(f => f.WorksPropStyle.Any(wps => _StyleNoList.Contains(wps.StyleNo)));
}
//以包裝序號查詢
if (!string.IsNullOrEmpty(this.PackagesNo))
{
FilterCount++;
var pkgitmwkno = context.PackageItems?.AsQueryable()?.Where(c => c.PackagesNo == Guid.Parse(this.PackagesNo.ToUpper())).Select(c => c.WorksNo).ToList();
if (pkgitmwkno != null && pkgitmwkno.Count > 0)
{
_WorksNoList.AddRange(pkgitmwkno);
}
//r = r.Where(f => f.PackageItems.Any(pkg => pkg.PackagesNo == Guid.Parse(this.PackagesNo)));
}
if (_WorksNoList != null && _WorksNoList.Count > 0)
{
var _WorksNoArray = _WorksNoList.GroupBy(i => i)
.Where(g => g.Count() == FilterCount)
.Select(g => g.ElementAt(0)).ToArray();
if (_WorksNoArray != null && _WorksNoArray.Length > 0)
{
r = r.Where(f => _WorksNoArray.Contains(f.WorksNo));
}
}
if (MenuModel.WorkOrderbyTypeEnum.預設排序 == this.OrderbyType)
{
//r = r.OrderByDescending(c => c.YearStart).ThenByDescending(c => c.CreateDate);
r = r.OrderBy(c => c.MaterialsID).ThenByDescending(c => c.YearStart).ThenByDescending(c => c.CreateDate);
}
else
if (MenuModel.WorkOrderbyTypeEnum.作品起始年代小至大 == this.OrderbyType)
{
r = r.OrderBy(c => c.YearStart).ThenByDescending(c => c.CreateDate);
}
else
if (MenuModel.WorkOrderbyTypeEnum.作品起始年代大至小 == this.OrderbyType)
{
r = r.OrderByDescending(c => c.YearStart).ThenByDescending(c => c.CreateDate);
}
else
if (MenuModel.WorkOrderbyTypeEnum.定價小至大 == this.OrderbyType)
{
r = r.OrderBy(c => c.Price).ThenByDescending(c => c.CreateDate);
}
else
if (MenuModel.WorkOrderbyTypeEnum.定價大至小 == this.OrderbyType)
{
r = r.OrderByDescending(c => c.Price).ThenByDescending(c => c.CreateDate);
}
else
if (MenuModel.WorkOrderbyTypeEnum.稱姓名小至大 == this.OrderbyType)
{
r = r.OrderBy(c => c.WorksName).ThenByDescending(c => c.CreateDate);
}
else
if (MenuModel.WorkOrderbyTypeEnum.稱姓名大至小 == this.OrderbyType)
{
r = r.OrderByDescending(c => c.WorksName).ThenByDescending(c => c.CreateDate);
}
else
{
r = r.OrderByDescending(c => c.CreateDate);
}
if (PageIndex > 0 && PageIndex > 0)
{
r = r.Select(c => c).Skip((PageIndex * PageSize - PageSize)).Take(PageSize + 1);
}
var _rw = r.ToList();
_WorksModel = WorksListToWorksModelList(_rw);
}
return(_WorksModel);
}
}
/// <summary>
/// 新增Menu
/// </summary>
/// <param name="_MenuClass">Meun類型</param>
/// <param name="_MenuViewModelList"></param>
/// <returns></returns>
public bool InsertMenu(MenuClassEnum _MenuClass, List <MenuViewModel> _MenuViewModelList)
{
string MenuClassName = Enum.GetName(typeof(MenuClassEnum), _MenuClass);
using (var context = new EG_MagicCubeEntities())
{
switch (_MenuClass)
{
case MenuClassEnum.AuthorArea:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_AuthorsArea.Add(new Menu_AuthorsArea()
{
AuthorsAreaNo = _MenuViewModel.MenuID, AuthorsAreaName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.AuthorTag:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_AuthorsTag.Add(new Menu_AuthorsTag()
{
AuthorsTagNo = _MenuViewModel.MenuID, AuthorsTagName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.CountNoun:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_CountNoun.Add(new Menu_CountNoun()
{
CountNounNo = _MenuViewModel.MenuID, CountNounName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.Genre:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_Genre.Add(new Menu_Genre()
{
GenreNo = _MenuViewModel.MenuID, GenreName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.Material:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_Material.Add(new Menu_Material()
{
MaterialNo = _MenuViewModel.MenuID, MaterialName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.Style:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_Style.Add(new Menu_Style()
{
StyleNo = _MenuViewModel.MenuID, StyleName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.WareType:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_WareType.Add(new Menu_WareType()
{
WareTypeNo = _MenuViewModel.MenuID, WareTypeName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
case MenuClassEnum.Owner:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
context.Menu_Owner.Add(new Menu_Owner()
{
OwnerNo = _MenuViewModel.MenuID, OwnerName = _MenuViewModel.MenuName, IsDel = ""
});
}
break;
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
public static bool UpdateMenu(MenuClassEnum _MenuClass, string MenuNo, string MenuName)
{
int _MenuNo = int.Parse(MenuNo);
using (var context = new EG_MagicCubeEntities())
{
string MenuClassName = Enum.GetName(typeof(MenuClassEnum), _MenuClass);
switch (_MenuClass)
{
case MenuClassEnum.AuthorArea:
var AuthorArea = context.Menu_AuthorsArea.First(c => c.AuthorsAreaNo == _MenuNo);
if (AuthorArea != null)
{
AuthorArea.AuthorsAreaName = MenuName;
}
break;
case MenuClassEnum.AuthorTag:
var AuthorTag = context.Menu_AuthorsTag.First(c => c.AuthorsTagNo == _MenuNo);
if (AuthorTag != null)
{
AuthorTag.AuthorsTagName = MenuName;
}
break;
case MenuClassEnum.CountNoun:
var CountNoun = context.Menu_CountNoun.First(c => c.CountNounNo == _MenuNo);
if (CountNoun != null)
{
CountNoun.CountNounName = MenuName;
}
break;
case MenuClassEnum.Genre:
var Genre = context.Menu_Genre.First(c => c.GenreNo == _MenuNo);
if (Genre != null)
{
Genre.GenreName = MenuName;
}
break;
case MenuClassEnum.Material:
var Material = context.Menu_Material.First(c => c.MaterialNo == _MenuNo);
if (Material != null)
{
Material.MaterialName = MenuName;
}
break;
case MenuClassEnum.Style:
var Style = context.Menu_Style.First(c => c.StyleNo == _MenuNo);
if (Style != null)
{
Style.StyleName = MenuName;
}
break;
case MenuClassEnum.WareType:
var WareType = context.Menu_WareType.First(c => c.WareTypeNo == _MenuNo);
if (WareType != null)
{
WareType.WareTypeName = MenuName;
}
break;
case MenuClassEnum.Owner:
var Owner = context.Menu_Owner.First(c => c.OwnerNo == _MenuNo);
if (Owner != null)
{
Owner.OwnerName = MenuName;
}
break;
case MenuClassEnum.AccountRole:
var AccountRole = context.UserAccountRoles.First(c => c.RoleNo == _MenuNo);
if (AccountRole != null)
{
AccountRole.RoleName = MenuName;
}
break;
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
/// <summary>
/// 刪除
/// </summary>
/// <param name="_MenuClass"></param>
/// <param name="_MenuViewModelList"></param>
/// <returns></returns>
public static bool DeleteMenu(MenuClassEnum _MenuClass, List <MenuViewModel> _MenuViewModelList)
{
string MenuClassName = Enum.GetName(typeof(MenuClassEnum), _MenuClass);
using (var context = new EG_MagicCubeEntities())
{
switch (_MenuClass)
{
case MenuClassEnum.AuthorArea:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_AuthorsArea = context.Menu_AuthorsArea.FirstOrDefault(x => x.AuthorsAreaNo == _MenuViewModel.MenuID);
if (delobj_AuthorsArea != null)
{
delobj_AuthorsArea.IsDel = "Y";
}
}
break;
case MenuClassEnum.AuthorTag:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_AuthorsTag = context.Menu_AuthorsTag.FirstOrDefault(x => x.AuthorsTagNo == _MenuViewModel.MenuID);
if (delobj_Menu_AuthorsTag != null)
{
delobj_Menu_AuthorsTag.IsDel = "Y";
}
}
break;
case MenuClassEnum.CountNoun:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_CountNoun = context.Menu_CountNoun.FirstOrDefault(x => x.CountNounNo == _MenuViewModel.MenuID);
if (delobj_Menu_CountNoun != null)
{
delobj_Menu_CountNoun.IsDel = "Y";
}
}
break;
case MenuClassEnum.Genre:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_Genre = context.Menu_Genre.FirstOrDefault(x => x.GenreNo == _MenuViewModel.MenuID);
if (delobj_Menu_Genre != null)
{
delobj_Menu_Genre.IsDel = "Y";
}
}
break;
case MenuClassEnum.Material:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_Material = context.Menu_Material.FirstOrDefault(x => x.MaterialNo == _MenuViewModel.MenuID);
if (delobj_Menu_Material != null)
{
delobj_Menu_Material.IsDel = "Y";
}
}
break;
case MenuClassEnum.Style:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_Style = context.Menu_Style.FirstOrDefault(x => x.StyleNo == _MenuViewModel.MenuID);
if (delobj_Menu_Style != null)
{
delobj_Menu_Style.IsDel = "Y";
}
}
break;
case MenuClassEnum.WareType:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_WareType = context.Menu_WareType.FirstOrDefault(x => x.WareTypeNo == _MenuViewModel.MenuID);
if (delobj_Menu_WareType != null)
{
delobj_Menu_WareType.IsDel = "Y";
}
}
break;
case MenuClassEnum.Owner:
foreach (MenuViewModel _MenuViewModel in _MenuViewModelList)
{
var delobj_Menu_Owner = context.Menu_Owner.FirstOrDefault(x => x.OwnerNo == _MenuViewModel.MenuID);
if (delobj_Menu_Owner != null)
{
delobj_Menu_Owner.IsDel = "Y";
}
}
break;
}
if (context.SaveChanges() == 0)
{
return(false);
}
}
return(true);
}
public List <WorksModel> WorksListToWorksModelList(List <Works> _WorksList)
{
List <WorksModel> _WorksModelList = new List <WorksModel>();
_WorksModelList = _WorksList.Select(c =>
new WorksModel()
{
WorksNo = c.WorksNo.ToString(),
MaterialsID = c.MaterialsID,
AuthorsNo = c.AuthorsNo,
AuthorsName = "",
WorksName = c.WorksName,
YearStart = c.YearStart,
YearEnd = c.YearEnd,
Remarks = c.Remarks,
Cost = c.Cost,
Price = c.Price,
PricingDate = c.PricingDate,
GrossMargin = c.GrossMargin,
Marketability = c.Marketability,
Packageability = c.Packageability,
Valuability = c.Valuability,
Artisticability = c.Artisticability,
CreateUser = c.CreateUser,
CreateDate = c.CreateDate,
ModifyUser = c.ModifyUser,
ModifyDate = (DateTime)c.ModifyDate,
WorksModuleList = new List <WorksModel.WorksModuleModel>()
{
}
}
).ToList();
Guid[] _WorksNoArray = _WorksModelList.Select(c => Guid.Parse(c.WorksNo.ToUpper())).ToArray();
using (var context = new EG_MagicCubeEntities())
{
List <WorksAuthors> _WorksAuthors = new List <WorksAuthors>();
if (context.WorksAuthors.Count() > 0)
{
_WorksAuthors = context?.WorksAuthors?.Where(c => _WorksNoArray.Contains(c.Works_No)).ToList();
}
List <WorksModules> _WorksModules = new List <WorksModules>();
if (context.WorksModules.Count() > 0)
{
_WorksModules = context?.WorksModules?.Where(c => _WorksNoArray.Contains(c.WorksNo)).ToList();
}
foreach (WorksModel _WorksModel in _WorksModelList)
{
_WorksModel.AuthorsName = string.Join(",", _WorksAuthors.Where(c => c.Works_No == Guid.Parse(_WorksModel.WorksNo.ToUpper())).Select(c => c.Authors.AuthorsCName).ToArray());
_WorksModel.MaterialsName = string.Join(",", _WorksModules.Where(c => c.WorksNo == Guid.Parse(_WorksModel.WorksNo.ToUpper())).Select(c => c.Menu_Material.MaterialName).Distinct().ToArray());
foreach (WorksModel.WorksModuleModel _WorksModule in _WorksModel.WorksModuleList)
{
var wm = _WorksModules.Where(c => c.WorksNo == Guid.Parse(_WorksModel.WorksNo.ToUpper())).FirstOrDefault();
if (wm != null)
{
_WorksModule.WorksModulesNo = wm.WorksModulesNo;
_WorksModule.WorksNo = wm.WorksNo.ToString();
_WorksModule.Material = new MenuViewModel {
MenuID = wm.Menu_Material.MaterialNo, MenuName = wm.Menu_Material.MaterialName
};
_WorksModule.Measure = wm.Measure;
_WorksModule.Length = wm.Length;
_WorksModule.Width = wm.Width;
_WorksModule.Height = wm.Height;
_WorksModule.Deep = wm.Deep;
_WorksModule.TimeLength = wm.TimeLength;
_WorksModule.Amount = wm.Amount;
_WorksModule.CountNoun = new MenuViewModel {
MenuID = wm.Menu_CountNoun.CountNounNo, MenuName = wm.Menu_CountNoun.CountNounName
};
}
}
}
}
return(_WorksModelList);
}
