public List <RegisterCode> FindRegisterCode(int ManagerID)
{
SqlConnection MySqlConnection = new SqlConnection(ConnectionString);
string MyCommandText = "select * from RegisterCode where ManagerID=" + ManagerID.ToString();
SqlCommand MySqlCommand = new SqlCommand(MyCommandText, MySqlConnection);
MySqlConnection.Open();
SqlDataReader MySqlDataReader = MySqlCommand.ExecuteReader();
RegisterCode AnyRegisterCode = null;
List <RegisterCode> MyAllRegisterCode = new List <RegisterCode>();
while (MySqlDataReader.Read())
{
AnyRegisterCode = new RegisterCode();
AnyRegisterCode.ManagerID = (int)MySqlDataReader["ManagerID"];
AnyRegisterCode.RegisterCodeStr = (string)MySqlDataReader["RegisterCode"];
AnyRegisterCode.LockID = (string)MySqlDataReader["LockID"];
AnyRegisterCode.Date = (DateTime)MySqlDataReader["Date"];
MyAllRegisterCode.Add(AnyRegisterCode);
}
MySqlDataReader.Close();
MySqlConnection.Close();
return(MyAllRegisterCode);
}
public void UpdateRegisterCode(RegisterCode MyRegisterCode)
{
/*
* SqlCommand MySqlCommand = new SqlCommand(commandText, MySqlConnection);
*
* MySqlConnection.Open();
*
* SqlCommand updatecmd = new SqlCommand("UPDATE Products set ProductName=@ProductName,CategoryID=@CategoryID,Price=@Price,InStore=@InStore,Description=@Description where ProductID=@ProductID", conn);
*
* updatecmd.Parameters.Add(new SqlParameter("@ProductName", pro.ProductName));
*
* updatecmd.Parameters.Add(new SqlParameter("CategoryID", pro.CategoryID));
*
* updatecmd.Parameters.Add(new SqlParameter("@Price", pro.Price));
*
* updatecmd.Parameters.Add(new SqlParameter("@InStore", pro.InStore));
*
* updatecmd.Parameters.Add(new SqlParameter("@Description", pro.Description));
*
* updatecmd.Parameters.Add(new SqlParameter("@ProductID", pro.ProductID));
*
* conn.Open();
*
* updatecmd.ExecuteNonQuery();
*
* conn.Close();
*/
}
public int InsertRegisterCodeEx(RegisterCode MyRegisterCode)
{
//string ConnectionString = "Server=VMXPSP3_LGJ;database=CloudLock;uid=sa;pwd=123456";
SqlConnection MySqlConnection = new SqlConnection(this.ConnectionString);
//--1.-----------------------------------------------------------------------------------------------
/*
* int MyFlowID;
* using (SqlCommand GetMaxcmd = new SqlCommand())
* {
* GetMaxcmd.CommandText = "select Max(FlowID) from LockFlow";//89765432BCDA820";
* GetMaxcmd.Connection = MySqlConnection;
* using (SqlDataReader MySqlDataReader = GetMaxcmd.ExecuteReader())
* {
* MySqlDataReader.Read();
* MyFlowID = (int)MySqlDataReader.GetValue(0);
*
*
* }
* }
* MyFlowID++;
* MyLockFlow.FlowID = MyFlowID;
*/
//--2.-----------------------------------------------------------------------------------------------
RandomRegisterCode MyRandomRegisterCode = new RandomRegisterCode();
MyRegisterCode.RegisterCodeStr = MyRandomRegisterCode.CreateRegsisterCode();
string MyCommandText = "insert into RegisterCode (ManagerID, LockID,RegisterCode) values (@ManagerID, @LockID,@RegisterCode)";
SqlCommand MySqlCommand = new SqlCommand(MyCommandText, MySqlConnection);
MySqlCommand.Parameters.Add(new SqlParameter("@ManagerID", MyRegisterCode.ManagerID));
MySqlCommand.Parameters.Add(new SqlParameter("@RegisterCode", MyRegisterCode.RegisterCodeStr));
MySqlCommand.Parameters.Add(new SqlParameter("@LockID", MyRegisterCode.LockID));
//MySqlCommand.Parameters.Add(new SqlParameter("@Date", MyRegisterCode.Date));
MySqlConnection.Open();
int RowCount = MySqlCommand.ExecuteNonQuery();
//------------------------------------------------------------------------------------------------------
MySqlConnection.Close();
return(RowCount);
}
public void DeleteRegisterCode(RegisterCode MyRegisterCode)
{
/*
* //string ConnectionString = "Server=VMXPSP3_LGJ;database=CloudLock;uid=sa;pwd=123456";
* SqlConnection MySqlConnection = new SqlConnection(ConnectionString);
*
* string MySQLViewName = "key" + MyLockKey.LockID;
* string MyCommandText = "delete from " + MySQLViewName + " where Number=@Number";
*
* SqlCommand MySqlCommand = new SqlCommand(MyCommandText, MySqlConnection);
*
* MySqlCommand.Parameters.Add(new SqlParameter("@Number", MyLockKey.LockKeyID));
*
* MySqlConnection.Open();
*
* MySqlCommand.ExecuteNonQuery();
*
* MySqlConnection.Close();
* */
}
public RegisterCode FindRegisterCode(string LockID)
{
//--------------------------------------------------------------
string NowDateStr = DateTime.Now.ToString();
NowDateStr = NowDateStr.Substring(0, NowDateStr.IndexOf(" "));
string AddSubNowDateStr = NowDateStr.Replace("-", "");
string DateIDFlag = "";
AddSubNowDateStr = "(Select DATEADD(DAY,-3,'" + AddSubNowDateStr + "')) ";
DateIDFlag = " and Date>=" + AddSubNowDateStr;
//ConnectionString = InConnectionString;
SqlConnection MySqlConnection = new SqlConnection(ConnectionString);
MySqlConnection.Open();
//SqlConnection MySqlConnection = HelpTool.MySqlConnection;
string MyCommandText = "select * from RegisterCode where LockID='" + LockID + "'" + DateIDFlag + " ORDER BY Date DESC";
SqlCommand MySqlCommand = new SqlCommand(MyCommandText, MySqlConnection);
SqlDataReader MySqlDataReader = MySqlCommand.ExecuteReader();
RegisterCode AnyRegisterCode = null;
while (MySqlDataReader.Read())
{
AnyRegisterCode = new RegisterCode();
AnyRegisterCode.ManagerID = (int)MySqlDataReader["ManagerID"];
AnyRegisterCode.RegisterCodeStr = (string)MySqlDataReader["RegisterCode"];
AnyRegisterCode.LockID = (string)MySqlDataReader["LockID"];
AnyRegisterCode.Date = (DateTime)MySqlDataReader["Date"];
break;
}
MySqlDataReader.Close();
MySqlConnection.Close();
return(AnyRegisterCode);
}