public void add(CMember member)
{
if (member.MemberType == "field")
add(member.Name, member.Declared[0]);
else if (member.MemberType == "const")
add(member.Name, member.Declared[0]);
else
funcs[member.Name] = member;
}
public void Add(CMember member)
{
if (member is CMemberOverload)
{
foreach (CMember m in ((CMemberOverload)member).overloads)
Add(m);
}
else
overloads.Add(member);
}
public static List <CNoteFolder> fn筆記資料夾查詢(CMember member)
{
string sql = $"EXEC 筆記資料夾查詢 @{CNoteFolderKey.fMemberId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CNoteFolderKey.fMemberId, member.fMemberId)
};
List <CNoteFolder> lsNoteFolder = (List <CNoteFolder>)CDbManager.querySql(sql, paras, reader筆記資料夾查詢);
return(lsNoteFolder);
}
public static List <COrder> fn訂單查詢(CMember member)
{
string sql = $"EXEC 訂單查詢 @{COrderKey.fMemberId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(COrderKey.fMemberId, member.fMemberId)
};
List <COrder> IsCOrder = (List <COrder>)CDbManager.querySql(sql, paras, reader訂單查詢);
return(IsCOrder);
}
public async Task <IActionResult> Create([Bind("Id,Name,Major,PhoneNumber,Email,Grade,Comment")] CMember cMember)
{
if (ModelState.IsValid)
{
_context.Add(cMember);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(cMember));
}
public string FolderRename(int FolderId, string FolderName)
{
CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員
//查詢筆記資料夾
CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member)
.FirstOrDefault(f => f.fFolderId == FolderId);
myFolder.fFolderName = FolderName;
CNoteFolderFactory.fn筆記資料夾更新(myFolder);
return("資料夾重新命名成功！");
}
public static void fn聊聊已讀更新(int a, CMember member)
{
string sql = $"EXEC 聊聊已讀更新 @{CChatKey.fMemberFrom},@{CChatKey.fMemberTo}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CChatKey.fMemberFrom, a),
new SqlParameter(CChatKey.fMemberTo, member.fMemberId)
};
CDbManager.executeSql(sql, paras);
}
public static List <CChat> fn聊聊查詢(CMember member)
{
string sql = $"EXEC 聊聊查詢 @{CChatKey.fMemberFrom}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CChatKey.fMemberFrom, member.fMemberId)
};
List <CChat> lsChat = (List <CChat>)CDbManager.querySql(sql, paras, reader聊聊查詢);
return(lsChat);
}
public ActionResult ChatRoom()
{
if (Session[CDictionary.welcome] as CMember == null)
{
return(RedirectToAction("Login"));
}
CMember cMember = Session[CDictionary.welcome] as CMember;
var user = db.tMember.Where(m => m.fMemberId == cMember.fMemberId).FirstOrDefault();
return(View(user));
}
public ActionResult CartClear(int CartId)
{
CMember member = (CMember)Session[CMemberSession.Session_Login_User];
CCartVM currentCart = CCartVM.GetCurrentCart(member);
foreach (var item in currentCart.lscartprooduct.Where(p => p.fCartId == CartId))
{
CCartProductFactory.fn購物車商品刪除(item);
}
return(RedirectToAction("CartView"));
}
public static void fn建立預設筆記資料夾(CMember member)
{
if (fn筆記資料夾查詢(member).FirstOrDefault(f => f.fFolderName == "未分類筆記") == null)
{
fn筆記資料夾新增(member, new CNoteFolder()
{
fFolderName = "未分類筆記",
fMemberId = member.fMemberId
});
}
}
public ActionResult SignIn(CMember member)
{
int tmpBool;
tmpBool = CInstance.theMemberManager.AddMember(ref member);
if (tmpBool == 1)
{
return(RedirectToAction("Index", member));
}
return(View(member));
}
public string SearchFavor(int FolderId, int NoteId)
{
CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員
//查詢筆記資料夾
CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member)
.FirstOrDefault(f => f.fFolderId == (int)FolderId);
//查詢指定筆記內容
CNote myNote = CNoteFactory.fn私人筆記查詢(myFolder)
.FirstOrDefault(n => n.fNoteId == NoteId && n.fIsTrash == false && n.fIsMyFavourite == true);
return(myNote.fJsonContent);
}
public int AddNoteFolder(string TxtNewFolderName)
{
CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員
CNoteFolder myFolder = new CNoteFolder()
{
fMemberId = member.fMemberId,
fFolderName = TxtNewFolderName
};
int folderid = CNoteFolderFactory.fn筆記資料夾新增(member, myFolder);
return(folderid);
}
public XmlDocument Encript(string input)
{
// 호출예시: http://localhost:52473/ws/member.asmx/Encript?input=1111
XmlDocument doc = new XmlDocument();
CMember member = new CMember();
doc.InnerXml = member.Encrypt(input);
return(doc);
}
public ActionResult Productblock(int ProductId)
{
if (Session[CMemberSession.Session_Login_User] == null)
{
return(RedirectToAction("../Member/Login"));
}
CMember member = (CMember)Session[CMemberSession.Session_Login_User];
CProductPicture myProductPicture = CProductPictureFactory.fn商品圖片查詢().FirstOrDefault(n => n.fProductId == ProductId);
//CProduct myProduct = CProductFactory.fn商品查詢().FirstOrDefault(n => n.fProductId == ProductId);
return(PartialView("_Productblock", myProductPicture));
}
//return RedirectToAction("List");
public ActionResult List()
{
//modify by Jony 109-12-15
CMember member = Session[CDictionary.welcome] as CMember;
if (member == null)
{
return(RedirectToAction("Login", "Member"));
}
return(View());
}
/// <summary>メンバーの削除
/// </summary>
/// <param name="sender">イベントの発生したオブジェクト</param>
/// <param name="e">発生したイベント</param>
private void TsmiRemoveMember_Click (object sender, EventArgs e) {
CMember member = this.Members[CurrentRowIndex];
TimeTableManager.UI.FMemberDialog dialog = new TimeTableManager.UI.FMemberDialog();
dialog.Member = member;
member.SetAvailable(false, StartDate.AddDays(-1.0));
if (dialog.ShowDialog(this.MainForm) == DialogResult.OK) {
this.timeTable.Members.DelMember(member);
//SetUpValidMembers();
} else {
member.SetAvailable(true);
}
}
/// <summary>優先順位の再設定
/// </summary>
public void RefreshPriority()
{
Refresh();
InRefresh = true;
for (int i = 0; i < priorities.Count; i++)
{
CMember member = priorities[i];
member.Priority = i + 1;
}
InRefresh = false;
Refresh();
}
//新訊息 已讀/未讀分類
public JsonResult GetActivityNotify_ReadYN()
{
//todo:
//int memberID = 1;
CMember member = Session[CDictionary.welcome] as CMember;
try
{
if (member != null)
{
List <InformationContent> list = new List <InformationContent>();
int memberID = member.fMemberId;
SingleApartmentEntities db = new SingleApartmentEntities();
IEnumerable <Information> ac = null;
ac = db.Information.AsEnumerable().Where(p => p.MemberID == memberID && p.Status != "User_Deleted" && p.Status != "Admin_Deleted");
list.Add(new InformationContent()
{
ContentID = 900, ContentName = ac.Count().ToString()
});
ac = db.Information.AsEnumerable().Where(p => p.Read_YN == "Y" && p.MemberID == memberID && p.Status != "User_Deleted" && p.Status != "Admin_Deleted");
list.Add(new InformationContent()
{
ContentID = 100, ContentName = ac.Count().ToString()
});
ac = db.Information.AsEnumerable().Where(p => p.Read_YN == "N" && p.MemberID == memberID && p.Status != "User_Deleted" && p.Status != "Admin_Deleted");
list.Add(new InformationContent()
{
ContentID = 200, ContentName = ac.Count().ToString()
});
List <string> str = new List <string>();
foreach (var item in list)
{
string i = JsonConvert.SerializeObject(item);
str.Add(i);
}
var ans = JsonConvert.SerializeObject(str);
return(Json(ans));
}
else
{
return(Json("fail"));
}
}
catch
{
return(Json("fail"));
}
}
public static List <CChat> fn聊聊個人查詢(CMember member, int a)
{
string sql = $"EXEC 聊聊個人查詢 @{CChatKey.fMemberFrom},@{CChatKey.fMemberTo}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CChatKey.fMemberFrom, member.fMemberId),
new SqlParameter(CChatKey.fMemberTo, a)
};
List <CChat> IsChatBeau = (List <CChat>)CDbManager.querySql(sql, paras, reader聊聊個人查詢);
return(IsChatBeau);
}
/// <summary>勤務シフトの修正
/// </summary>
/// <param name="sender">イベントの発生したオブジェクト</param>
/// <param name="e">発生したイベント</param>
private void TsmiEditPattern_Click (object sender, EventArgs e) {
CMember member = this.Members[CurrentRowIndex];
PatternWrapper wrapper = Member2PatternWrapper[member];
CPattern pattern = wrapper.Pattern;
if (pattern != null && !pattern.BuiltIn) {
TimeTableManager.UI.FPatternDialog dialog = new TimeTableManager.UI.FPatternDialog();
dialog.Pattern = pattern;
if (dialog.ShowDialog(this.MainForm) == DialogResult.OK) {
Refresh();
}
}
}
/// <summary>マウスがあがったとき、バーチャートを更新する
/// </summary>
/// <param name="sender">イベントの発生したオブジェクト</param>
/// <param name="e">発生したイベント</param>
private void BodyTable_CellMouseUp (object sender, DataGridViewCellMouseEventArgs e) {
EnumBarLabelStatus CurrentStatus = BarLabelStatus;
BarLabelStatus = EnumBarLabelStatus.None;
if (CurrentStatus != EnumBarLabelStatus.None && e.RowIndex >= 0) {
//
Rectangle CellBounds1 = BodyTable.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, false);
//
float MovingSpan0 = e.X - StartPoint.X;
float MovingSpan1 = (e.X > StartPoint.X ? MovingSpan0 : -MovingSpan0);
TimeSpan Span = GetXSpan2TimeSpan(CellBounds1.Width, StartPoint.X, e.X);
if ((Span > TimeSpan.Zero ? Span.TotalHours > Half : Span.TotalHours < -Half)) {
Rectangle CellBounds2 = new Rectangle(new Point(0, 0), CellBounds1.Size);
CMember member = this.Members[e.RowIndex];
PatternWrapper wrapper;
TimeSpan SpanStart = TimeSpan.Zero, SpanEnd = TimeSpan.Zero, SpanRest = TimeSpan.Zero;
switch (CurrentStatus) {
case EnumBarLabelStatus.StartMoving:
wrapper = this.Member2PatternWrapper[member];
SpanStart = GetX2TimeSpan(CellBounds1.Width, e.X, TableStart);
SpanEnd = wrapper.EndTime;
SpanRest = wrapper.Pattern.Rest;
break;
case EnumBarLabelStatus.EndMoving:
wrapper = this.Member2PatternWrapper[member];
SpanStart = wrapper.StartTime;
SpanEnd = GetX2TimeSpan(CellBounds1.Width, e.X, TableStart);
SpanRest = wrapper.Pattern.Rest;
break;
case EnumBarLabelStatus.AllMoving:
wrapper = this.Member2PatternWrapper[member];
SpanStart = wrapper.StartTime + Span;
SpanEnd = wrapper.EndTime + Span;
SpanRest = wrapper.Pattern.Rest;
break;
case EnumBarLabelStatus.Creating:
SpanStart = GetX2TimeSpan(CellBounds1.Width, StartPoint.X, TableStart);
SpanEnd = GetX2TimeSpan(CellBounds1.Width, e.X, TableStart);
break;
}
if (SpanStart > SpanEnd) {
// スワップ
TimeSpan Swap = SpanStart;
SpanStart = SpanEnd;
SpanEnd = Swap;
}
//
CreatePattern(member, SpanStart, SpanEnd, TimeSpan.Zero);
}
}
BodyTable.Refresh();
}
//會員購賣紀錄---------------------------------------------------------\\\
public ActionResult MemberOrder()
{
CMember member = Session[CMemberSession.Session_Login_User] as CMember;
if (member != null)
{
var SelectMemberOrder = CMemberFactory.fn會員訂單個人查詢(member).OrderByDescending(n => n.fLaunchDate);
var Count訂單 = SelectMemberOrder.Count();
ViewBag.Count訂單 = Count訂單;
return(View("../Member/MemberOrder", SelectMemberOrder));
}
return(RedirectToAction("../Home/Index"));
}
public string UpdateVersion(int NoteId, string JsonContent)
{
CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員
//查詢指定筆記內容
CNote myNote = CNoteFactory.fn私人筆記全部查詢()
.FirstOrDefault(n => n.fNoteId == NoteId);
myNote.fJsonContent = JsonContent;
myNote.fEditDateTime = DateTime.UtcNow.AddHours(08);
CNoteFactory.fn私人筆記更新(myNote);
return("筆記更新成功");
}
public static void fn公司收入新增(CMember member, CIncome Income)
{
string sql = $"EXEC 公司收入新增 @{CIncomeKey.fIncome},@{ CIncomeKey.fPaymentDateTime},@{ CIncomeKey.fIncomeCategory},@{CIncomeKey.fMemberId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CIncomeKey.fIncome, Income.fIncome),
new SqlParameter(CIncomeKey.fPaymentDateTime, Income.fPaymentDateTime),
new SqlParameter(CIncomeKey.fIncomeCategory, Income.fIncomeCategory),
new SqlParameter(CIncomeKey.fMemberId, member.fMemberId)
};
CDbManager.executeSql(sql, paras);
}
public ActionResult SearchVersion(int FolderId, int NoteId)
{
CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員
//查詢筆記資料夾
CNoteFolder myFolder = CNoteFolderFactory.fn筆記資料夾查詢(member)
.FirstOrDefault(f => f.fFolderId == (int)FolderId);
//查詢指定筆記內容
CNote myNote = CNoteFactory.fn私人筆記查詢(myFolder)
.FirstOrDefault(n => n.fNoteId == NoteId && n.fIsTrash == false);
List <CVersion> lsVersion = CVersionFactory.fn筆記版本控制查詢(myNote);
return(PartialView("_SearchVersionView", lsVersion));
}
public string AddVersion(int NoteId)
{
CMember member = (CMember)Session[CMemberSession.Session_Login_User];//會員
//查詢指定筆記內容
CNote myNote = CNoteFactory.fn私人筆記全部查詢()
.FirstOrDefault(n => n.fNoteId == NoteId);
myNote.fEditDateTime = DateTime.UtcNow.AddHours(08);
CVersionFactory.fn筆記版本控制新增(myNote);
return("版本紀錄新增成功！");
}
public XmlDocument Decript(string input)
{
// 호출예시
// http://localhost:52473/ws/member.asmx/Decript?input=PGXjU6ib2mKYwtrh2i3fIQ%3D%3D
XmlDocument doc = new XmlDocument();
CMember member = new CMember();
doc.InnerXml = member.Decrypt(input);
return(doc);
}
public ActionResult MyProfile(int fMemberId)
{
//登入的會員資訊
CMember Member = (CMember)Session[CMemberSession.Session_Login_User];
//防止未登入者進入
if (Member == null)
{
return(RedirectToAction("../Member/Login"));
}
return(PartialView("_MyProfile", Member));
}
// GET: ShoppingAccountCenter
public ActionResult Index()
{
//登入的會員資訊
CMember member = (CMember)Session[CMemberSession.Session_Login_User];
//防止未登入者進入~
if (member == null)
{
return(RedirectToAction("../Member/Login"));
}
return(View());
}
//=========================== 購物車查詢(all) =========================== //
public static List <CCart> fn購物車查詢(CMember member)
{
string sql = $"EXEC 購物車查詢 ";
sql += $"@{CCartKey.fMemberId}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CCartKey.fMemberId, member.fMemberId)
};
return((List <CCart>)CDbManager.querySql(sql, paras, reader購物車查詢));
}
private static void Parse(Member member)
{
if (!member.Consolidated)
{
member.Consolidated = true;
JSType type = null;
// parse the assignments
foreach (var mem in member.Assignments.Values)
{
if (!mem.Consolidated)
{
Parse(mem);
}
if (type == null)
type = mem.ConsolidatedType;
else
{
// here we must dfecide which type has priority if they are different
if (mem.ConsolidatedType != null && type.GetName() != mem.ConsolidatedType.GetName())
{
type = new BasicType() { Type = DataType.Dynamic };
}
}
}
// done parsing children, lets create this type
if (type == null && member.Type != MemberType.Global && member.Type != MemberType.Parameter && member.Type != MemberType.AnonymousFunction && member.Type != MemberType.Value && member.Type != MemberType.Method && member.Type != MemberType.Function)
{
// nothing was assigned to this type, so it IS the base type, lets create it
type = new Class() { Name = member.FullNameReal };
classes.Add((Class)type);
}
else if (type == null && member.Type == MemberType.Value)
{
// nothing was assigned to this type, so it IS the base type, lets create it
type = new BasicType() { Type = member.DataType };
}
// and now children types
if (member.Constructor != null)
{
Parse(member.Constructor);
if (type != null && type is Class)
((Class)type).Constructors.Add(GenerateMethod(member.Constructor));
}
foreach (var mem in member.Parameters.Values)
{
Parse(mem);
}
foreach (var mem in member.Members.Values)
{
Parse(mem);
if (type != null && type.GetType() != typeof(BasicType))
{
if (mem.Type == MemberType.Function || mem.Type == MemberType.Method)
{
Method meth = GenerateMethod(mem);
if (!((Class)type).Methods.ContainsKey(meth.Name))
((Class)type).Methods.Add(meth.Name, meth);
}
else if (mem.Type == MemberType.Member && mem.ConsolidatedType != null)
{
CMember memb = new CMember() { Name = mem.GetOfficialName(), Type = mem.ConsolidatedType.GetName() };
if (!((Class)type).Members.ContainsKey(memb.Name))
((Class)type).Members.Add(memb.Name, memb);
}
}
}
foreach (var mem in member.Body.Values)
{
Parse(mem);
}
foreach (var mem in member.ReturnMembers.Values)
{
Parse(mem);
type = mem.ConsolidatedType;
}
member.ConsolidatedType = type;
}
}
