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 string UpdateLockForSale(string LockID, int ManagerID)
{
RandomRegisterCode MyRandomRegisterCode = new RandomRegisterCode();
string NewRegisterCode = MyRandomRegisterCode.CreateRegsisterCode();
SqlConnection MySqlConnection = new SqlConnection(ConnectionString);
MySqlConnection.Open();
//SqlConnection MySqlConnection = HelpTool.MySqlConnection;
string MyUpdateCMDText = "UpdateLockForSale";
SqlCommand MySqlCommand = new SqlCommand(MyUpdateCMDText, MySqlConnection);
MySqlCommand.CommandType = CommandType.StoredProcedure;
MySqlCommand.Parameters.Add(new SqlParameter("@LockID", LockID));
MySqlCommand.Parameters.Add(new SqlParameter("@ManagerID", ManagerID));
MySqlCommand.Parameters.Add(new SqlParameter("@RegisterCode", NewRegisterCode));
MySqlCommand.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
MySqlCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
int RowCount = MySqlCommand.ExecuteNonQuery();
int ReturnValue = (int)MySqlCommand.Parameters["@ReturnValue"].Value;
MySqlConnection.Close();
if (ReturnValue == 0)
{
return(NewRegisterCode);
}
else
{
return(null);
}
}