private void frmHeatItem_Load(object sender, System.EventArgs e)
{
this.Text = "参数编辑";
con = new DBcon();
InitializeGridTable();
LoadDatas();
}
public void MakePayment()
{
try
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("spLavBetaling", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@afsender", SelectedAccountNmb);
cmd.Parameters.AddWithValue("@modtager", Receiver);
cmd.Parameters.AddWithValue("@note", Note);
cmd.Parameters.AddWithValue("@beloeb", Amount);
int count = Convert.ToInt32(cmd.ExecuteNonQuery());
if (count == -1)
{
MessageBox.Show("Modtageren findes ikke!");
}
else
{
MessageBox.Show("Jeg tror det lykkedes?");
}
}
}
}
catch (Exception)
{
throw;
}
}
// Finally the method for doing the DB stuff
public ReturnType DoDatabaseStuff()
{
SqlConnection myCon = DBcon.getInstance().conn();
try
{
myCon.Open();
// ... do some DB stuff
}
catch (Exception ex)
{
// ... Some logging
}
finally
{
if (myCon.State == ConnectionState.Open)
{
myCon.Close();
}
// ... any additional cleanup in here
}
return // ... some value;
}
public string AddBloodStorage([FromBody] BloodStorage bloodStorage)
{
string response = DBcon.AddBloodStorage(conn, bloodStorage.ShelfLife, bloodStorage.BloodType, bloodStorage.RHFactor, bloodStorage.Shipped,
"addBloodStorage");
return(response);
}
public void GetTransactions()
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
using (SqlCommand cmd = new SqlCommand("spHentAlleTransaktionerAlleKonti", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@kundeID", DashboardViewModel.u.Id);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Transactions.Add(new TransactionModel
{
TransactionID = Convert.ToInt32(dr[0]),
AccountNmb = Convert.ToInt32(dr[1]),
Note = dr[2].ToString(),
Function = Convert.ToChar(dr[3]),
Amount = Convert.ToDecimal(dr[4]),
NewBalance = Convert.ToDecimal(dr[5]),
Date = dr[6].ToString()
});
}
}
}
}
public int IsLogInValid(string id, string password)
{
this.sql = "select * from Login where userid ='" + id + "'and password ='******';";
this.Ds = DBcon.GetDataSet(sql);
if (this.Ds.Tables[0].Rows.Count == 1)
{
if (IsAdminValid(id, password) == true)
{
return(1);
}
else if (IsEmployeeValid(id, password) == true)
{
return(2);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
private void EditLoad()
{
DateTime dt;
try
{
con = new DBcon();
SqlCommand cmd = new SqlCommand("select * from v_PointData where id=@m_id", con.GetConnection());
cmd.Parameters.Add("@m_id", m_DataID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
dt = System.Convert.ToDateTime(dr["DT"]);
dtDate.Value = dt.Date;
dtTime.Value = dt.Hour;
// dtDate.Value=System.Convert.ToDateTime(dr["DT"]);
cmbPoint.Text = dr["Name"].ToString();
txtDescription.Text = dr["Description"].ToString();
txtFlux.Text = dr["Flux"].ToString();
txtFluxAll1.Text = dr["FluxAll1"].ToString();
txtFluxAll2.Text = dr["FluxAll2"].ToString();
txtFulxInstant.Text = dr["FluxInstant"].ToString();
txtHeat.Text = dr["Heat"].ToString();
txtHeatAll.Text = dr["HeatAll"].ToString();
txtTemp1.Text = dr["Temp1"].ToString();
txtTemp2.Text = dr["Temp2"].ToString();
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void AddRecord()
{
try
{
con = new DBcon();
SqlCommand cmd = new SqlCommand("PointDataAdd", con.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_PointName", cmbPoint.Text.ToString().Trim());
cmd.Parameters.Add("@p_DT", m_DT);
cmd.Parameters.Add("@p_Temp1", m_Temp1);
cmd.Parameters.Add("@p_Temp2", m_Temp2);
cmd.Parameters.Add("@p_Flux", m_Flux);
cmd.Parameters.Add("@p_Heat", m_Heat);
cmd.Parameters.Add("@p_HeatAll", m_HeatAll);
cmd.Parameters.Add("@p_FluxAll1", m_FluxAll1);
cmd.Parameters.Add("@p_FluxAll2", m_FluxAll2);
cmd.Parameters.Add("@p_FluxInstant", m_FluxInstant);
cmd.Parameters.Add("@p_Description", txtDescription.Text.Trim());
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Delete()
{
if (NoRecordDataGrid())
{
return;
}
int row = m_dataGrid.CurrentCell.RowNumber;
int col = 1;
string UserName = m_dataGrid[row, col].ToString().ToString().Trim();
if (UserName == null)
{
MessageBox.Show("请正确选择需要删除的数据行!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (MessageBox.Show("确定要删除该行数据?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
row = m_dataGrid.CurrentCell.RowNumber;
col = 0;
DBcon con = new DBcon();
int id = Convert.ToInt32(m_dataGrid[row, col].ToString());
SqlCommand sqlCmd = new SqlCommand("DELETE FROM tbWUser WHERE ID=" + id, con.GetConnection());
sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
RefreshDataGrid();
}
public void GetAccounts()
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
using (SqlCommand cmd = new SqlCommand("spHentKonti", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@kundeID", DashboardViewModel.u.Id);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Accounts.Add(new AccountModel(
AccountNmb = dr[0].ToString(),
AccountType = dr[1].ToString(),
AccountName = dr[2].ToString(),
Balance = Convert.ToDecimal(dr[3])));
}
}
}
}
public static void setLoggedUser(this HttpContext context, User userAccount, bool saveCookie = false)
{
DBcon dbContext = context.RequestServices.GetService <DBcon>();
string oldToken = context.Request.GetCookieJson <string>(loggedUser);
if (oldToken != null)
{
Token remove = dbContext.Tokens.FirstOrDefault(i => i.Value == oldToken);
if (remove != null)
{
dbContext.Tokens.Remove(remove);
dbContext.SaveChanges();
}
}
if (userAccount != null)
{
string token = Guid.NewGuid().ToString();
dbContext.Tokens.Add(new Token
{
Value = token,
UserId = userAccount.Id,
Created = DateTime.Now
});
dbContext.SaveChanges();
context.Response.SetCookieJson(loggedUser, token);
}
}
public string AddPrizeTransaction([FromBody] PrizeTransaction prizeTransaction)
{
var worked = DBcon.InsertPrizeTransaction(conn, prizeTransaction.donorID, prizeTransaction.PID, "addPrizeTransaction");
return(worked switch
{
0 => "Transaction invalid",
-1 => "error in procedure",
_ => "Transaction complete. Insertion was successful"
});
public void Login()
{
using (SqlConnection conn = new SqlConnection(DBcon.Connect()))
{
conn.Open();
try
{
SqlCommand cmd = new SqlCommand("spLogin", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@email", Email);
cmd.Parameters.AddWithValue("@kodeord", Psw);
cmd.ExecuteNonQuery();
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count == 1)
{
using (SqlCommand cmd2 = new SqlCommand("spHentbrugerinfo", conn))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@email", Email);
cmd2.Parameters.AddWithValue("@kodeord", Psw);
using (SqlDataReader reader = cmd2.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
ShellViewModel.u = new UserModel(
reader.GetInt32(0),
reader.GetString(1).ToString(),
reader.GetString(2).ToString());
}
}
};
_events.PublishOnUIThread(new DashboardRequest());
}
else
{
manager.ShowDialog(new LoginErrorViewModel());
Psw = "";
}
}
catch (Exception)
{
manager.ShowDialog(new LoginErrorViewModel());
Psw = "";
}
}
}
public bool IsEmployeeValid(string id, string password)
{
this.sql = "select * from Login where userid ='" + id + "'and password ='******'and usertype ='Employee';";
this.Ds = DBcon.GetDataSet(sql);
if (this.Ds.Tables[0].Rows.Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public void AdminProfile()
{
string sql = "Select * from login";
DataTable dt = new DataTable();
dt = DBcon.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
lblid.Content = dt.Rows[0]["userid"].ToString();
lblname.Content = dt.Rows[0]["name"].ToString();
}
}
private void LoadStation()
{
string str = "select name from PointInfo";
con = new DBcon();
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbPoint.Items.Add(dr.GetValue(0).ToString().Trim());
}
dr.Close();
}
/// <summary>
///
/// </summary>
private void UpdateRecord()
{
try
{
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand("UserUpdate", con.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_EditName", m_strEditUser);
cmd.Parameters.Add("@p_Name", txtUserName.Text.Trim());
cmd.Parameters.Add("@p_Password", txtPwd.Text);
cmd.Parameters.Add("@p_Description", txtDescription.Text.Trim());
SqlDataReader dr = cmd.ExecuteReader();
if (!dr.Read())
{
dr.Close();
return;
}
string UserID = dr["ID"].ToString().Trim();
int intUserID = Convert.ToInt32(UserID);
dr.Close();
cmd.Dispose();
//delete old funID
cmd = new SqlCommand("DELETE FROM WUserFunction WHERE UserID=" + intUserID, con.GetConnection());
cmd.ExecuteNonQuery();
cmd.Dispose();
for (int i = 0; i < cklPurview.Items.Count; i++)
{
if (cklPurview.GetItemChecked(i))
{
int intFunID = Convert.ToInt32(m_FunName2FunID[cklPurview.Items[i]].ToString());
//add userid -> codeID to UserFunction
cmd = new SqlCommand("UserFunctionAdd", con.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@p_UserID", intUserID);
cmd.Parameters.Add("@p_FunctionID", intFunID);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
}
catch (Exception ex)
{
// 2007.05.30
//
//MessageBox.Show("编辑用户失败！");
ExceptionHandler.Handle("编辑用户失败！", ex);
}
}
private void LoadStation()
{
dtDateDown.Value = dtDateUp.Value.AddDays(1);
string str = "select Name from V_heatDatas Group by name";
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbID.Items.Add(dr.GetValue(0).ToString().Trim());
}
dr.Close();
m_PageCount = 1;
cmbID.Items.Add("<全部站点>");
}
public static User GetLoggedUser(this HttpContext context)
{
DBcon dbContext = context.RequestServices.GetService <DBcon>();
string token = context.Request.GetCookieJson <string>(loggedUser);
if (token == null)
{
return(null);
}
int value = dbContext.Tokens.Where(x => x.Value == token).Select(s => s.UserId).FirstOrDefault();
User user = dbContext.Users.Find(value);
return(user);
}
private void RefreshDataGrid()
{
try
{
if (!d_Type)
{
m_dataGrid.DataSource = ds.Tables[0].DefaultView;
this.Width = 170 + 90 * (ds.Tables[0].Columns.Count - 1);
}
else
{
DataTable dt = CreatTable();
DBcon con = new DBcon();
int z = 0;
string strName = "select name from v_HeatDatas group by name";
SqlDataAdapter daName = new SqlDataAdapter(strName, con.GetConnection());
DataSet dsName = new DataSet();
daName.Fill(dsName, "Name");
daName.Dispose();
for (int i = 0; i < dsName.Tables["Name"].Rows.Count; i++)
{
string str = "select top 1 name,team,time,oneBackTemp from v_HeatDatas where name='" + dsName.Tables["Name"].Rows[i]["name"].ToString() + "' order by time desc";
SqlDataAdapter da = new SqlDataAdapter(str, con.GetConnection());
DataSet dsOBT = new DataSet();
da.Fill(dsOBT, "table");
for (int j = 0; j < dsOBT.Tables["table"].Rows.Count; j++)
{
DataRow newrow = dt.NewRow();
dt.Rows.Add(newrow);
dt.Rows[z]["name"] = dsOBT.Tables["table"].Rows[j]["name"].ToString();
dt.Rows[z]["team"] = dsOBT.Tables["table"].Rows[j]["team"].ToString();
dt.Rows[z]["time"] = System.Convert.ToDateTime(dsOBT.Tables["table"].Rows[j]["time"].ToString());
dt.Rows[z]["oneBackTemp"] = System.Convert.ToDecimal(dsOBT.Tables["table"].Rows[j]["oneBackTemp"].ToString());
z = z + 1;
}
}
m_dataGrid.DataSource = dt;
this.Width = 184 + 90 * (dt.Columns.Count - 1);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
///
/// </summary>
private void ReadEditUserInfo()
{
try
{
txtUserName.Text = m_strEditUser;
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand("SELECT * FROM tbWUser WHERE Name='" + m_strEditUser + "'", con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
int intUserID;
if (!dr.Read())
{
dr.Close();
cmd.Dispose();
return;
}
intUserID = Convert.ToInt32(dr["ID"]);
txtPwd.Text = dr["Password"].ToString();
txtPwd2.Text = txtPwd.Text;
txtDescription.Text = dr["Description"].ToString().Trim();
dr.Close();
cmd.Dispose();
cmd = new SqlCommand("SELECT * FROM WUserFunction WHERE UserID=" + intUserID, con.GetConnection());
dr = cmd.ExecuteReader();
ArrayList arrFun = new ArrayList();
while (dr.Read())
{
arrFun.Add(dr["FunctionID"]);
}
dr.Close();
cmd.Dispose();
for (int i = 0; i < arrFun.Count; i++)
{
SetItemCheckedByFunID((int)arrFun[i]);
}
}
catch (Exception ex)
{
// 2007.05.30
//
//MessageBox.Show(ex.ToString());
ExceptionHandler.Handle(ex);
}
}
/// <summary>
///
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
private bool UserNameExist(string UserName)
{
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand("SELECT * FROM tbWUser WHERE Name='" + UserName.Trim() + "'", con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
bool bln = dr.Read();
dr.Close();
if (bln)
{
return(true);
}
else
{
return(false);
}
}
private void LoadDataGrid()
{
try
{
DBcon con = new DBcon();
string str = "select * from tbWUser";
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
cmd.ExecuteNonQuery();
cmd.Dispose();
SqlDataAdapter da = new SqlDataAdapter(str, con.GetConnection());
DataSet ds = new DataSet();
da.Fill(ds, "User");
da.Dispose();
this.m_dataGrid.DataSource = ds.Tables["User"];
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
///
/// </summary>
private void ReadFunction()
{
try
{
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand("SELECT * FROM tbWFunction ORDER BY ID", con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string FunName = dr["Name"].ToString().Trim();
cklPurview.Items.Add(FunName);
m_FunName2FunID.Add(FunName, (int)dr["id"]);
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void ReadFunction()
{
try
{
dtEnd.Value = dtBegin.Value.AddDays(1);
string str = "select Name from V_heatDatas Group by name"; //筛选以存站点
DBcon con = new DBcon();
SqlCommand cmd = new SqlCommand(str, con.GetConnection());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cmbStation.Items.Add(dr.GetValue(0).ToString());
}
dr.Close();
InitializeColor();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public Sub2totpldtm()
{
InitializeComponent();
DBcon.InitializeDB();
}
public string UpdateRequest([FromBody] Request request)
{
DBcon.UpdateRequest(conn, request.RequestID, request.Approved, request.ApprovedBy,
"updateRequest");
return("Update was successful");
}
public string RetrieveRequestByBloodType(string bloodType, string rhf)
{
string json = DBcon.RetrieveRequestByBloodType(conn, bloodType, rhf, "getRequestByBloodType");
return(json);
}
public string RetrieveAllRequests()
{
string json = DBcon.RetrieveAllRequests(conn, "getAllRequests");
return(json);
}
public string AddRequest([FromBody] Request request)
{
DBcon.AddRequest(conn, request.ClinicID, request.DateCompleted, request.HospitalID, request.Amount,
request.BloodType, request.RHFactor, "AddRequest");
return("Request Made. Insertion was successful");
}
