public void setDeadline(string time)
{
DateTime _time = Convert.ToDateTime(time);
_second = _time.Second - DateTime.Now.Second;
_minute = _time.Minute - DateTime.Now.Minute;
_hour = _time.Hour - DateTime.Now.Hour;
_year = _time.Year - DateTime.Now.Year;
if (_year == 0)
{
_day = _time.DayOfYear - DateTime.Now.DayOfYear;
}
else
{
_day = _time.DayOfYear - DateTime.Now.DayOfYear + 366;
}
checkdatetime();
converttostring();
//lbTime.Visible = true;
if (_day < 0)
{
Timer.Enabled = false;
lbTime.Text = "Time-expired!";
DataHandle.getInstance().SendEmail("Project " + this.lbProjectName.Text + " đã quá thời gian!", "Bạn chưa hoàn thành " + _viecchualam + " công việc.\nTiến độ công việc " + lbComplete.Text.Substring(10) + ".", email);
}
else
{
lbTime.Text = _day + ":" + hour + ":" + minute + ":" + second;
}
lbTime.Location = new System.Drawing.Point(this.Width - this.lbTime.Width - 5, 277);
Console.WriteLine(lbTime.Text);
}
private void button1_Click(object sender, EventArgs e)
{
if (txtTittle.Text == "")
{
MessageBox.Show("Không thể để trống!", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
if (DataHandle.getInstance().checkTittleReminder(txtTittle.Text) == false)
{
MessageBox.Show("Tittle đã tồn tại!", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DataHandle.getInstance().CreateNewReminder(
new Reminders()
{
Tittle = txtTittle.Text,
Content = txtContent.Text,
Time = dateTimePicker1.Value.ToString(),
Check = Convert.ToInt32(checkBox.Checked),
User_id = User_ID
});
DataHandle.getInstance().ShowNote();
this.Dispose();
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtTittle.Text == "")
{
MessageBox.Show("Không thể để trống!", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
if (DataHandle.getInstance().checkTittleToDoList(txtTittle.Text) == false)
{
MessageBox.Show("Tittle đã tồn tại!", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int p = 1;
if (txtbox.Count() == 0)
{
MessageBox.Show("Thêm list to do", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DataHandle.getInstance().CreateMyToDoList(txtTittle.Text, User_ID);
foreach (string t in txtbox)
{
DataHandle.getInstance().CreateNewToDoList(txtTittle.Text, t, p, 0);
p++;
}
DataHandle.getInstance().ShowNote();
this.Dispose();
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtTittle.Text == "")
{
MessageBox.Show("Không thể để trống!", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
if (DataHandle.getInstance().checkEditTittleToDoList(txtTittle.Text) == false)
{
MessageBox.Show("Tittle đã tồn tại!", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (eitem.Count() == 0 && newitem.Count() == 0)
{
MessageBox.Show("Thêm list to do", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DataHandle.getInstance().EditToDoList(txtTittle.Text, eitem);
foreach (ItemTDLs i in newitem)
{
DataHandle.getInstance().CreateNewToDoList(txtTittle.Text, i.Content, i.STT, Convert.ToInt32(i.check));
}
foreach (ItemTDLs i in deletedItem)
{
DataHandle.getInstance().DeleteItemInToDoList(txtTittle.Text, i.STT);
}
DataHandle.getInstance().ShowNote();
this.Dispose();
}
}
}
protected override void BandingReport()
{
//定义报表参数对象
List <ReportParameter> parameterList = new List <ReportParameter>();
Dictionary <string, string> paramDic = RdlcParam();
foreach (var key in paramDic.Keys)
{
parameterList.Add(new ReportParameter(key, paramDic[key]));
}
parameterList.Add(new ReportParameter("PollutionName", PollutionName));
parameterList.Add(new ReportParameter("PollutionNo", PollutionNo));
string ReportPath = "Areas\\Report\\Template\\AirYear.rdlc";
ReportViewer1.LocalReport.ReportPath = ReportPath;
ReportViewer1.LocalReport.ReportEmbeddedResource = "Tablix1";
ReportViewer1.LocalReport.SetParameters(parameterList);
DataTable table = MonitorData.GetMonitorDataForReportAir(Request.QueryString["dataFrom"], startTime, endTime, Request.QueryString["type"], Request.QueryString["id"], "month");
DataHandle.TableDataStyle(table, "DATA_TIME", Request.QueryString["rdlcType"]);
ReportDataSource rds = new ReportDataSource("AirHour", table); //指定数据源GetTestDataTable()
ReportViewer1.LocalReport.DataSources.Clear(); //报表数据源清除，必须
ReportViewer1.LocalReport.DataSources.Add(rds); //报表数据源增加
ReportViewer1.LocalReport.Refresh(); //刷新报表
}
public List <T> ExeSelectListM <T>(List <T> baselst) where T : DtBase, new()
{
T dto = new T();
List <T> lst = new List <T>();
DataTable dt = Select(dto.MakeSelectAll());
DataHandle.Table2List(dt, lst);
for (int i = 0; i < baselst.Count; i++)
{
T itm1 = baselst[i];
bool fEql = false;
for (int j = 0; j < lst.Count; j++)
{
T itm2 = lst[j];
if (itm1.KeyEqual(itm2))
{
fEql = true;
break;
}
}
if (!fEql)
{
lst.Add(itm1);
}
}
return(lst);
}
private void btnOk_Click(object sender, EventArgs e)
{
if (txtTittle.Text == "")
{
MessageBox.Show("Không thể để trống!", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
if (DataHandle.getInstance().checkTittleNote(txtTittle.Text) == false)
{
MessageBox.Show("Tittle đã tồn tại!", "Nhập lại", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DataHandle.getInstance().CreateNewNote(
new Notes()
{
Tittle = txtTittle.Text,
Content = txtContent.Text,
user_id = User_ID
});
DataHandle.getInstance().ShowNote();
this.Dispose();
}
}
protected override void BandingReport()
{
//定义报表参数对象
List <ReportParameter> parameterList = new List <ReportParameter>();
var paramDic = RdlcParam(Request.QueryString["rdlcType"]);
foreach (var key in paramDic.Keys)
{
parameterList.Add(new ReportParameter(key, paramDic[key]));
}
string ReportPath = "Areas\\Report\\Template\\PollutionCompanyWarn.rdlc";
ReportViewer1.LocalReport.ReportPath = ReportPath;
ReportViewer1.LocalReport.ReportEmbeddedResource = "Tablix1";
ReportViewer1.LocalReport.SetParameters(parameterList);
DataTable table = MonitorData.GetPollutionWarnData(startTime, endTime, Request.QueryString["type"], Request.QueryString["id"], dataType);
DataHandle.TableDataStyle(table, "DATA_TIME", Request.QueryString["rdlcType"]);
ReportDataSource rds = new ReportDataSource("PollutionCompanyWarn", table); //指定数据源GetTestDataTable()
ReportViewer1.LocalReport.DataSources.Clear(); //报表数据源清除，必须
ReportViewer1.LocalReport.DataSources.Add(rds); //报表数据源增加
ReportViewer1.LocalReport.Refresh(); //刷新报表
}
private void StoreMeshData <TVertex>(TVertex[] vertices, int[] indices, dReal[] normals)
{
ReleaseDataStores();
verticesData = new DataHandle(vertices.Length * Marshal.SizeOf(typeof(TVertex)));
indicesData = new DataHandle(indices.Length * Marshal.SizeOf(typeof(int)));
float[] floatVertices = vertices as float[];
if (floatVertices != null)
{
verticesData.Copy(floatVertices);
}
double[] doubleVertices = vertices as double[];
if (doubleVertices != null)
{
verticesData.Copy(doubleVertices);
}
indicesData.Copy(indices);
if (normals != null)
{
normalsData = new DataHandle(normals.Length * Marshal.SizeOf(typeof(int)));
normalsData.Copy(normals);
}
}
public void setComplete()
{
double x = 0;
double y = 0;
Projects p = DataHandle.getInstance().GetDataProject();
foreach (ItemProjects i in p.item)
{
if (i.check == true)
{
x++;
}
y++;
}
double a = y - x;
x = ((x / y) * 100);
if (x.ToString().Length > 5)
{
z = x.ToString().Substring(0, 5);
}
else
{
save = Convert.ToInt32(y - x);
z = x.ToString();
}
Form1.getInstance().ShowProject(p.Tittle, p.item, z, p.deadline, Convert.ToInt32(a));
}
protected override void BandingReport()
{
//定义报表参数对象
List <ReportParameter> parameterList = new List <ReportParameter>();
var paramDic = RdlcParam(Request.QueryString["rdlcType"]);
foreach (var key in paramDic.Keys)
{
parameterList.Add(new ReportParameter(key, paramDic[key]));
}
dynamic companyInfo = BaseCommonInfo.GetCompanyOrPK(Request.QueryString["type"], Request.QueryString["id"]);
parameterList.Add(new ReportParameter("PollutionName", companyInfo.Name));
parameterList.Add(new ReportParameter("PollutionNo", companyInfo.Code));
string ReportPath = "Areas\\Report\\Template\\VocsHour.rdlc";
ReportViewer1.LocalReport.ReportPath = ReportPath;
ReportViewer1.LocalReport.ReportEmbeddedResource = "Tablix1";
ReportViewer1.LocalReport.SetParameters(parameterList);
DataTable table = MonitorData.GetMonitorDataForReportVocs(Request.QueryString["dataFrom"], startTime, endTime, Request.QueryString["type"], Request.QueryString["id"], dataType);
DataHandle.TableDataStyle(table, "DATA_TIME", Request.QueryString["rdlcType"]);
ReportDataSource rds = new ReportDataSource("VocsMonitor", table); //指定数据源GetTestDataTable()
ReportViewer1.LocalReport.DataSources.Clear(); //报表数据源清除，必须
ReportViewer1.LocalReport.DataSources.Add(rds); //报表数据源增加
ReportViewer1.LocalReport.Refresh(); //刷新报表
}
public void populateAccounts()
{
List <NoteMakingApp.Models.Account> accounts = DataHandle.getInstance().GetAccounts();
switch (cbOrder.SelectedItem)
{
case "Created":
accounts.OrderBy(a => a.created).ToList();
break;
case "Username":
default:
accounts.OrderBy(a => a.username).ToList();
break;
}
accounts = accounts.FindAll(a => a.username.Contains(tbSearch.Text));
if (!increasingOrder)
{
accounts.Reverse();
}
this.pnlList.Controls.Clear();
AccountListItem item;
foreach (NoteMakingApp.Models.Account a in accounts)
{
item = new AccountListItem(a, accounts.IndexOf(a) + 1);
item.Location = new System.Drawing.Point(0, this.pnlList.Controls.Count * item.Height);
this.pnlList.Controls.Add(item);
}
}
private void KhoiTaoHocPhi(string maTre, DateTime start, DateTime end)
{
List <ThangNam> listThangNam = DataHandle.GetThoiGianTrongKhoan(start, end);
foreach (ThangNam tn in listThangNam)
{
TreBLL.KhoiTaoHocPhi(maTre, tn.thang, tn.nam);
}
}
private static void ReleaseDataStore(ref DataHandle storeHandle)
{
if (storeHandle != null)
{
storeHandle.Close();
}
storeHandle = null;
}
private void TCP_Connect(object state)
{
TcpClient Tcp_Client = state as TcpClient;
DataHandle.WriteLog($"接收来自{Tcp_Client.Client.RemoteEndPoint},当前线程数:{ThreadPool.ThreadCount}");
NetworkStream TCP_Stream = Tcp_Client.GetStream();
var State_VT = (Tcp_Client, TCP_Stream);
TCP_Stream.BeginRead(Receive_Data, 0, Data_Size, new AsyncCallback(TCP_Receive), State_VT);
}
public Socsk_Listen(IPAddress IP, int Port)
{
Receive_Data = new byte[Data_Size];
dataHandle = new DataHandle();
TcpListener Socks_Server = new TcpListener(IP, Port);
Program.PrintLog(string.Format("Socks服务已启动,监听{0}端口中", Port));
Socks_Server.Start();
Socks_Server.BeginAcceptTcpClient(AcceptTcpClient, Socks_Server);
}
private void btnTest_Click(object sender, RoutedEventArgs e)
{
if (txtTest.Text != null)
{
txtbShow.Text += ("\n" + DataHandle.Handle(txtTest.Text));
}
else
{
MessageBox.Show("输入测试字符串");
}
}
private bool checkData(NoteMakingApp.Models.Account acc)
{
if (DataHandle.getInstance().doesAccountExit(acc))
{
return(true);
}
else
{
return(false);
}
}
public List <T> ExeSelectList <T>() where T : DtBase, new()
{
T dto = new T();
List <T> lst = new List <T>();
DataTable dt = Select(dto.MakeSelectAll());
DataHandle.Table2List(dt, lst);
return(lst);
}
public static PersonalDetailsPanel getInstance(int acc)
{
if (instance == null)
{
instance = new PersonalDetailsPanel();
}
instance.account = acc;
instance.person = DataHandle.getInstance().GetPerson(acc);
if (instance.person != null)
{
instance.lbName.Text = instance.person.name;
instance.lbIntroduction.Text = instance.person.introduction;
}
else
{
instance.lbName.Text = "";
instance.lbIntroduction.Text = "";
}
instance.btnEdit.Visible = acc == DataHandle.getInstance().getRecentAccount().id;
List <PersonalDetail> details = DataHandle.getInstance().GetDetails(acc);
List <PersonalDetail> categorisedDetails;
CategorisedDetailPanel categoryPanel;
instance.pnlCategories.Controls.Clear();
bool nodetails = true;
foreach (string c in PersonalDetail.categories)
{
categorisedDetails = details.FindAll(d => d.category == c);
categoryPanel = new CategorisedDetailPanel(c, categorisedDetails, acc == DataHandle.getInstance().getRecentAccount().id);
categoryPanel.Location = new System.Drawing.Point(0,
instance.pnlCategories.Controls.Count == 0 ? 0 :
instance.pnlCategories.Controls[instance.pnlCategories.Controls.Count - 1].Location.Y +
instance.pnlCategories.Controls[instance.pnlCategories.Controls.Count - 1].Size.Height);
instance.pnlCategories.Controls.Add(categoryPanel);
if (categorisedDetails.Count != 0)
{
nodetails = false;
}
}
if (instance.person == null && nodetails)
{
instance.label1.Visible = true;
}
else
{
instance.label1.Visible = false;
}
instance.PerformLayout();
instance.Refresh();
return(instance);
}
public void Close()
{
try
{
DataHandle.WriteLog(string.Format("已关闭{0}的UDP代理隧道", Client_Point));
UDP_Client.Close();
TCP_Client.GetStream().Close();
TCP_Client.Close();
}
catch (Exception) {
}
}
private void KhoiTaoSucKhoe(List <string> listMatre, DateTime start, DateTime end)
{
List <ThangNam> listThangNam = DataHandle.GetThoiGianTrongKhoan(start, end);
foreach (ThangNam tn in listThangNam)
{
foreach (string maTre in listMatre)
{
TreBLL.KhoiTaoSucKhoe(maTre, tn.thang, tn.nam);
}
}
}
/// <summary>
/// 关闭UDP对象及TCP依赖
/// </summary>
public void Close()
{
try
{
DataHandle.WriteLog($"已关闭{Client_Point}的UDP代理隧道");
UDP_Client.Close();
TCP_Client.GetStream().Close();
TCP_Client.Close();
}
catch (Exception) {
}
}
/// <summary>
/// 关闭客户端连接
/// </summary>
/// <param name="Tcp_Client">客户端TCPClient</param>
private void Close(TcpClient Tcp_Client)
{
try
{
if (Tcp_Client.Connected)
{
DataHandle.WriteLog($"已关闭客户端{Tcp_Client.Client.RemoteEndPoint}的连接");
Tcp_Client.GetStream().Close();
Tcp_Client.Close();
}
}
catch (SocketException) {
}
}
/// <summary>
/// Pins the object to be allocated by cvSetData.
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
// ReSharper disable once InconsistentNaming
protected internal GCHandle AllocGCHandle(object obj)
{
if (obj == null)
{
throw new ArgumentNullException(nameof(obj));
}
if (DataHandle.IsAllocated)
{
DataHandle.Free();
}
DataHandle = GCHandle.Alloc(obj, GCHandleType.Pinned);
return(DataHandle);
}
public static void Main(
string[] args
)
{
DataHandle DH = DataHandle.getHandle(
"server=192.168.56.101;" +
"uid=logrpg;" +
"pwd=logrpg;" +
"database=logrpg;" +
"Allow User Variables=True;"
);
DH.Auth("kevok", "logrpg");
}
private void Register_Click(object sender, EventArgs e)
{
if (checkUsername() && checkPassword() && checkConfirmation())
{
DataHandle.getInstance().saveAccount(
new NoteMakingApp.Models.Account()
{
username = iUsername.Text,
password = iPassword.Text,
creator = 0
});
nullifyField();
Form1.getInstance().setWindow("Login");
}
}
public ListProject()
{
InitializeComponent();
instance = this;
this.flowLayoutPanel1.Controls.Clear();
DataHandle.getInstance().GetDataFromProject();
AddProject(0, "New Project");
foreach (Projects t in DataHandle.prjs)
{
if (t.user_id == user_id)
{
AddProject(t.id, t.Tittle);
}
}
}
private void LoadListChiTietHocPhi()
{
dgvChiTietHocPhi.DataSource = DataHandle.ListToDataTable(listChiTietHocPhi);
dgvChiTietHocPhi.Columns[3].HeaderText = "Tên chi phí";
dgvChiTietHocPhi.Columns[4].HeaderText = "Số tiền";
dgvChiTietHocPhi.Columns[3].Width = 150;
dgvChiTietHocPhi.Columns[4].Width = 100;
string[] listProp = { "STT", "TenChiPhi", "SoTien" };
ControlFormat.DataGridViewFormat(dgvChiTietHocPhi, listProp);
dgvChiTietHocPhi.ClearSelection();
}
/// <summary>
/// Releases unmanaged resources
/// </summary>
protected virtual void DisposeUnmanaged()
{
if (DataHandle.IsAllocated)
{
DataHandle.Free();
}
if (AllocatedMemorySize > 0)
{
GC.RemoveMemoryPressure(AllocatedMemorySize);
AllocatedMemorySize = 0;
}
if (AllocatedMemory != IntPtr.Zero)
{
Marshal.FreeHGlobal(AllocatedMemory);
AllocatedMemory = IntPtr.Zero;
}
}
