// Method to handle user login validation, obtain user
// information, and redirect client following login attempt.
protected void EquipCheckLoginCtrl_Authenticate(object sender, AuthenticateEventArgs e)
{
EquipCheckAppUser user = new EquipCheckAppUser();
user.Username = EquipCheckLoginCtrl.UserName;
user.Password = EquipCheckLoginCtrl.Password;
UserManager userMgr = new UserManager();
EquipCheckAppUser userAtServer = userMgr.RetrieveUser(user);
if (userAtServer != null)
{
e.Authenticated = true;
EquipCheckAppUser userLocal = userMgr.RetrieveLocalUser(userAtServer);
if (userLocal == null)
{
userLocal = userMgr.CreateUser(userAtServer);
userLocal = ListCreation.CreateLists(userLocal);
}
// Get user's checklists
CheckListManager checkListManager = new CheckListManager();
List <CheckList> checkLists = checkListManager.RetrieveCheckLists(userLocal);
List <String> checkListNames = checkListManager.getCheckListNames(checkLists);
userLocal.AllCheckList = checkLists;
userLocal.AllCheckListNames = checkListNames;
// Get user's equipment lists
EquipListManager equipListManager = new EquipListManager();
List <EquipmentList> equipLists = equipListManager.RetrieveEquipLists(userLocal);
if (equipLists == null || equipLists.Count == 0)
{
userLocal = ListCreation.CreateLists(userLocal);
}
else
{
List <String> equipListNames = equipListManager.getEquipmentListNames(equipLists);
userLocal.AllEquipLists = equipLists;
userLocal.AllEquipListNames = equipListNames;
}
Session["user"] = userLocal;
Response.Redirect("/Restricted/Welcome.aspx");
}
else
{
e.Authenticated = false;
Session["user"] = null;
Session["message_type"] = "login_error";
Session["message"] = "Login Error.";
Session["details"] = "User Credentials Invalid.";
Response.Redirect("/Restricted/Message.aspx");
}
}
private void btnClearCheckListDB_Click(object sender, EventArgs e)
{
if (MessageBox.Show("警告！是否确定要清空交割单数据库？", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
CheckListManager manager = new CheckListManager();
int count = manager.DeleteAll();
MessageBox.Show(string.Format("Done! Deteled {0} lines.", count));
}
}
private void btnImportCheckList_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
if (ofd.ShowDialog() == DialogResult.OK)
{
CheckListManager manager = new CheckListManager();
//int count1 = manager.ImportFromXls(@"D:\stockdata\20150726 交割单查询.xls");
//int count2 = manager.ImportFromTxt(@"D:\stockdata\20150911 交割单查询.txt", 1, @"\t", new string[] { "=", "\"" });
//int count3 = manager.ImportFromTxt(@"D:\stockdata\20151016 交割单查询.txt", 1, @"\t", new string[] { "=", "\"" });
//MessageBox.Show(string.Format("Done! Inserted {0} lines.", count1 + count2 + count3));
//根据文件扩展名，选择读取程序
//string expStr = ofd.FileName.Substring(ofd.FileName.LastIndexOf('.'));
string expStr = System.IO.Path.GetExtension(ofd.FileName);
int count = 0;
try
{
if (expStr.ToLower() == ".xlsx" || expStr.ToLower() == ".xls")
{
count = manager.ImportFromXls(ofd.FileName);
}
else if (expStr.ToLower() == ".txt")
{
count = manager.ImportFromTxt(ofd.FileName, 1, @"\t", new string[] { "=", "\"" });
}
else
{
MessageBox.Show("请选择txt或者xlsx文件。");
return;
}
}
catch (NPOI.POIFS.FileSystem.NotOLE2FileException)
{
MessageBox.Show("文件格式错误！文件的格式与文件扩展名指定的格式不一致。请尝试另存为。");
return;
//throw;
}
string p = new PortfolioGenerater().PGenerater();
string a = new AccountStatusGenerater().AGenerater();
MessageBox.Show(string.Format("Done! Inserted {0} lines." + "\n" + p.ToString() + "\n" + a.ToString(), count));
//查询checklist数据库的最大日期，并显示在文本框中
if (manager.GetCount() == 0)
{
this.txtMaxDate.Text = "There is no checklist.";
}
else
{
this.txtMaxDate.Text = manager.GetMaxDate().ToShortDateString();
}
}
}
//更新自定义控件UCtlTradingTrace
public void UpdateUCtlTradingTrace(string code)
{
this.txtStockCode.Text = code;
//查询交易记录
List <CheckList> checkListData = new CheckListManager().GetByCode(code).ToList <CheckList>();
this.dgvCheckList.DataSource = checkListData;
//设置图形数据
this.SetDataToChartCandel(code);
}
private void UCtlConfiguration_Load(object sender, EventArgs e)
{
//查询checklist数据库的最大日期，并显示在文本框中
CheckListManager manager = new CheckListManager();
if (manager.GetCount() == 0)
{
this.txtMaxDate.Text = "There is no checklist.";
}
else
{
this.txtMaxDate.Text = manager.GetMaxDate().ToShortDateString();
}
}
private void btnRefreshData_Click(object sender, EventArgs e)
{
string code = this.txtStockCode.Text;
bool traded = new CheckListManager().HasBeenTraded(code);
if (traded == true)
{
List <CheckList> checkListData = new CheckListManager().GetByCode(code).ToList <CheckList>();
DateTime updateBeginDate = checkListData[0].Date.AddDays(-30);
DateTime updateEndDate = checkListData[checkListData.Count - 1].Date.AddDays(30);
new StockDayPriceManager().AutoUpdateByCodeName(code, checkListData[0].Name, updateBeginDate, updateEndDate);
//设置图形数据
this.SetDataToChartCandel(code);
}
}
// Method to save the user's Equipment Checklist.
protected void SaveChecklistButton_Click(object sender, EventArgs e)
{
CheckList checkList = new CheckList();
checkList.CheckListName = ChecklistNameTextBox.Text;
checkList.CheckListDesc = ChecklistDescriptionTextBox.Text;
checkList.TripName = TripNameTextBox.Text;
checkList.TripDesc = TripDescriptionTextBox.Text;
checkList.TripDate = TripDateTextBox.Text;
checkList.CheckListItemSummary = ChecklistItemsTextBox.Text;
if (checkList.Validate())
{
EquipCheckAppUser user = (EquipCheckAppUser)Session["user"];
List <CheckList> checkLists = user.AllCheckList;
CheckListManager checkListManager = new CheckListManager();
checkListManager.CreateCheckList(user, checkList);
checkLists.Add(checkList);
user.AllCheckList = checkLists;
List <String> checkListNames = user.AllCheckListNames;
checkListNames.Add(checkList.CheckListName);
user.AllCheckListNames = checkListNames;
Session["user"] = user;
Session["checkListEntries"] = null;
Session["selectedItems"] = null;
Session["selectedItemsWithDescriptions"] = null;
Session["message_type"] = "checklist_success";
Session["message"] = "Checklist Creation Successful.";
Session["details"] = "Click OK to Continue!";
}
else
{
saveChecklistEntries();
Session["message_type"] = "checklist_error";
Session["message"] = "Checklist Entry Error.";
Session["details"] = "Checklist Name and Description are Required!";
}
Response.Redirect("/Restricted/Message.aspx");
}
private void Awake()
{
instance = this;
}
