private void AddCamera(ConnectionOption e)
{
string st = e.Source + ":";
if (!string.IsNullOrEmpty(e.MmUrl.version))
{
st += e.MmUrl.version;
}
else
{
st += "Other";
}
string source = e.Source;
if (source == "VLC" && !_vlc)
{
source = "FFMPEG";
}
st += ": " + source + " " + e.URL.Replace("&", "&&");
var rb = new RadioButton {
Text = st, AutoSize = true, Tag = e
};
if (source == "FFMPEG" || source == "VLC")
{
rb.Font = new Font(rb.Font, FontStyle.Bold);
}
UISync.Execute(() => pnlOptions.Controls.Add(rb));
}
private void OK_Click(object sender, EventArgs e)
{
JObject jo = (JObject)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(new ConnectionOption()));
foreach (Control item in panel1.Controls)
{
jo[item.Name] = item.Text;
}
jo["connStatus"] = "0";
jo["connTotalTime"] = "0";
jo["connTimeList"] = "";
// string SQLCONNECT = @"server=JS-DIANQI\SQLEXPRESS;database=mySQL;uid=sa;pwd=1234";
string SQLCONNECT = IMDataBase.connStr;
SqlConnection conn = new SqlConnection(SQLCONNECT);
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("select connDetail from connectionOption", conn);
da.Fill(ds);
int inDataBase = 0;
foreach (DataRow tmp in ds.Tables[0].Rows)
{
ConnectionOption connTmp = JsonConvert.DeserializeObject <ConnectionOption>(tmp[0].ToString());
if (machineID.Text == connTmp.machineID)
{
inDataBase = 1;
MessageBox.Show("机器名重名");
}
if (IP.Text == connTmp.IP)
{
inDataBase = 1;
MessageBox.Show("IP重名");
}
}
if (inDataBase == 0)
{
string SQLCOMMAND = "INSERT connectionOption(machineID,connDetail,connConfirm,isDisplay)VALUES('";
SqlCommand sqlcmd = new SqlCommand(SQLCOMMAND, conn);
// sqlcmd.CommandText = "INSERT connectionOption(machineID,connDetail,connConfirm,isDisplay)VALUES('";
sqlcmd.CommandText += machineID.Text + "','" + jo.ToString() + "','" + connConfirm.Text + "','" + isDisplay.Text + "')";
sqlcmd.ExecuteNonQuery();
//SqlDataReader dr = sqlcmd.ExecuteReader();
readAllConnsEventHandler myDelegate = new readAllConnsEventHandler(IMCapture.readAllConn);
myDelegate();
MessageBox.Show("成功");
initCBConns();
// this.Close();
}
conn.Close();
}
public void writeConnToDataBase(ConnectionOption connOption)
{
string SQLCONNECT = IMDataBase.connStr;
SqlConnection conn = new SqlConnection(SQLCONNECT);
conn.Open();
JObject jo = (JObject)JsonConvert.DeserializeObject(JsonConvert.SerializeObject(connOption));
string SQLCOMMAND = " ";
SqlCommand sqlcmd = new SqlCommand(SQLCOMMAND, conn);
if (jo["conntotalTime"] == null)
{
jo["conntotalTime"] = sampleT.ToString();
}
else
{
jo["conntotalTime"] = (int.Parse(jo["conntotalTime"].ToString()) + sampleT).ToString();
}
// sqlcmd.CommandText = "INSERT connectionOption(machineID,connDetail,connConfirm,isDisplay)VALUES('";
sqlcmd.CommandText = "update connectionOption SET connDetail='" + jo.ToString() + "',conntotalTime='" + jo["conntotalTime"] + "'where machineID = '" + connOption.machineID + "'";
int sqlcmdResult = 0;
try{
sqlcmdResult = sqlcmd.ExecuteNonQuery();
conn.Close();
}
catch {
conn.Close();
}
}
private void AddONVIF(string addr, ConnectionOption co)
{
string st = "ONVIF: " + addr;
var rb = new RadioButton {
Text = st, AutoSize = true, Tag = co
};
UISync.Execute(() => pnlOptions.Controls.Add(rb));
}
public async Task ShouldGetCategory()
{
var options = new ConnectionOption
{
Identifier = Identifier,
Secret = Secret,
BaseAddress = BaseAddress
};
HttpResponseWithBody result = await(dynamic) VismaSign.CategoriesGet(options, new CancellationToken());
Assert.Equal(200, result.StatusCode);
}
public When_retrieving_sessions_from_the_database()
{
_mockConnectionOption = new Moq.Mock <IOptions <ConnectionOption> >();
ConnectionOption connectionOption = new ConnectionOption
{
ConCode = ConCodeConfiguration.Config["ConnectionStrings:ConCode"]
};
_mockConnectionOption.SetupGet(x => x.Value).Returns(connectionOption);
_conferenceDbContext = new ConferenceDbContext(_mockConnectionOption.Object);
_testSpeaker = new User
{
FirstName = "Luke",
LastName = "Skywalker",
Username = "******",
ModifiedBy = "unit test",
SpeakerInfo = new SpeakerInfo
{
Tagline = "You're not my father!",
Talks = new List <Talk> {
new Talk {
Title = "How to find your father"
}
}
}
};
_conferenceDbContext.Users.Add(_testSpeaker);
_testTalkTypes = new List <TalkType>
{
new TalkType {
Name = "Standard", Length = TimeSpan.FromMinutes(75)
},
new TalkType {
Name = "Lightening", Length = TimeSpan.FromMinutes(15)
},
};
_conferenceDbContext.SaveChanges();
_testSession = new Session
{
Talk = _testSpeaker.SpeakerInfo.Talks.First(),
Start = new DateTime(2016, 08, 20),
Status = SessionStatus.Full,
TalkType = _testTalkTypes.Last()
};
_conferenceDbContext.Sessions.Add(_testSession);
_conferenceDbContext.SaveChanges();
}
private void slowThreadProcess(object sender, System.Timers.ElapsedEventArgs e)
{
//lock (locker)
{
ConnectionOption.checkConnections(listConn);
foreach (ConnectionOption item in listConn)
{
(new IMDataBase()).writeConnToDataBase(item);
if (item.controllerType.IndexOf("gefran") != -1 && item.connStatus == "1")
{
new DataCapture().getFilesFromGefran(item.loginName, item.loginPassword, @"ftp://" + item.IP + @"/gefran/recipes/", Application.StartupPath + @"\data\" + item.controllerType, item.machineID + ".zip");
}
}
}
}
public async Task ShouldSearchDocuments()
{
var settings = new DocumentSearchInput()
{
Query = "status=cancelled"
};
var options = new ConnectionOption
{
Identifier = Identifier,
Secret = Secret,
BaseAddress = BaseAddress
};
HttpResponseWithBody result = await(dynamic) VismaSign.DocumentSearch(settings, options, new CancellationToken());
Assert.StartsWith("{\"total\":", result.Body);
}
public async Task ShouldCreateDocument()
{
var settings = new DocumentCreateInput
{
Body = "{ \"document\": { \"name\": \"Test document\"}}"
};
var options = new ConnectionOption
{
Identifier = Identifier,
Secret = Secret,
BaseAddress = BaseAddress
};
HttpResponse result = await(dynamic) VismaSign.DocumentCreate(settings, options, new CancellationToken());
Assert.StartsWith("https://sign.visma.net/api/v1/document/", result.Location);
}
public async Task ShouldGetDocument()
{
var settings = new DocumentGetInput()
{
DocumentUriId = "38ca4a5c-5080-4b95-9486-4055f226ecbd",
Passphrase = ""
};
var options = new ConnectionOption
{
Identifier = Identifier,
Secret = Secret,
BaseAddress = BaseAddress
};
HttpResponseWithByteArrayBody result = await(dynamic) VismaSign.DocumentGet(settings, options, new CancellationToken());
Assert.Equal(200, result.StatusCode);
}
/// <summary>
/// Initializes the database, loading the engine associated to <paramref name="connectorType"/>.
/// </summary>
/// <parameters>
/// <param name="connectorType">The engine backing the database.</param>
/// <param name="connectionOption">Options related to connection to a server.</param>
/// <param name="isDebugTraceEnabled">True to turn traces on.</param>
/// </parameters>
public virtual void Initialize(ConnectorType connectorType, ConnectionOption connectionOption, bool isDebugTraceEnabled)
{
Debug.Assert(Connector == null);
if (Connector != null)
{
return;
}
ConnectorType = connectorType;
ConnectionOption = connectionOption;
try
{
switch (ConnectorType)
{
case ConnectorType.MySql:
Connector = new MySqlConnector();
break;
default:
throw new ArgumentOutOfRangeException(nameof(connectorType));
}
IsDebugTraceEnabled = isDebugTraceEnabled;
if (IsDebugTraceEnabled)
{
Debugging.Print("Connector created: " + Connector.ToString());
}
}
#if TRACE
catch (ApplicationException)
{
throw;
}
#endif
catch (Exception e)
{
if (IsDebugTraceEnabled)
{
Debugging.PrintExceptionMessage(e.Message);
}
}
}
public DbConnectionProxy(string[] connectionStrings, ConnectionOption connectionOption = ConnectionOption.FirstOnly, int maxAttempts = 1)
{
if (connectionStrings == null)
{
throw new ArgumentNullException(nameof(connectionStrings));
}
else if (connectionStrings.Length == 0)
{
throw new ArgumentOutOfRangeException(nameof(connectionStrings), $"{nameof(connectionStrings)} must have at least 1.");
}
ConnectionStrings = connectionStrings;
if (maxAttempts <= 0)
{
throw new ArgumentOutOfRangeException(nameof(maxAttempts), maxAttempts, $"{nameof(maxAttempts)} must be greater than or equal to 1.");
}
MaxAttempts = maxAttempts;
ConnectionOption = connectionOption;
}
public When_retrieving_users_from_the_database()
{
_mockConnectionOption = new Moq.Mock <IOptions <ConnectionOption> >();
ConnectionOption connectionOption = new ConnectionOption
{
ConCode = ConCodeConfiguration.Config["ConnectionStrings:ConCode"]
};
_mockConnectionOption.SetupGet(x => x.Value).Returns(connectionOption);
_conferenceDbContext = new ConferenceDbContext(_mockConnectionOption.Object);
_testUser = new User {
FirstName = "Luke",
LastName = "Skywalker",
Username = "******",
ModifiedBy = "unit test",
SpeakerInfo = new SpeakerInfo {
Tagline = "You're not my father!"
}
};
_conferenceDbContext.Users.Add(_testUser);
_conferenceDbContext.SaveChanges();
}
private void Next()
{
if (pnlConfig.Visible)
{
MainForm.IPLISTED = tbl1.Enabled;
MainForm.IPRTSP = chkRTSP.Checked;
MainForm.IPHTTP = chkHTTP.Checked;
if (MainForm.IPLISTED)
{
if (!_hashdata.Contains(txtFindModel.Text.ToUpper()))
{
MessageBox.Show(this, LocRm.GetString("ChooseMake"));
return;
}
}
else
{
if (!MainForm.IPRTSP && !MainForm.IPHTTP)
{
MessageBox.Show(this, LocRm.GetString("ChooseOption"));
return;
}
}
ShowPanel(pnlLogin);
return;
}
if (pnlLogin.Visible)
{
ShowPanel(pnlFindNetwork);
return;
}
if (pnlFindNetwork.Visible)
{
string addr = txtIPAddress.Text.Trim();
if (string.IsNullOrEmpty(addr))
{
MessageBox.Show(this, LocRm.GetString("EnterIPAddress"));
return;
}
Uri nUrl = null;
if (!Uri.TryCreate("http://" + addr, UriKind.Absolute, out nUrl))
{
MessageBox.Show(this, LocRm.GetString("EnterIPDNSOnly"));
return;
}
AddConnections(nUrl);
return;
}
if (pnlConnect.Visible)
{
if (MainForm.IPLISTED && txtFindModel.Text == "")
{
ShowPanel(pnlConfig);
return;
}
DeviceScanner.Stop();
string make = txtMake.Text;
string model = txtModel.Text;
FinalUrl = "";
Username = DeviceScanner.Username;
Password = DeviceScanner.Password;
if (MainForm.IPLISTED)
{
var mm = txtFindModel.Text.Split(':');
make = mm[0].Trim();
model = "";
if (mm.Length > 1)
{
model = mm[1].Trim().ToUpper();
}
}
ConnectionOption s = null;
for (int j = 0; j < pnlOptions.Controls.Count; j++)
{
if (pnlOptions.Controls[j] is RadioButton)
{
if (((RadioButton)pnlOptions.Controls[j]).Checked)
{
var o = (pnlOptions.Controls[j]).Tag;
s = o as ConnectionOption;
if (s == null)
{
continue;
}
FinalUrl = s.URL;
VideoSourceType = s.VideoSourceTypeID;
AudioSourceType = s.AudioSourceTypeID;
Ptzid = -1;
if (s.MmUrl != null && !s.MmUrl.@fixed)
{
string modellc = model.ToLower();
string n = make.ToLower();
bool quit = false;
foreach (var ptz in MainForm.PTZs)
{
int k = 0;
foreach (var m in ptz.Makes)
{
if (m.Name.ToLower() == n)
{
Ptzid = ptz.id;
Ptzentryid = k;
string mdl = m.Model.ToLower();
if (mdl == modellc || s.MmUrl.version.ToLower() == mdl)
{
Ptzid = ptz.id;
Ptzentryid = k;
quit = true;
break;
}
}
k++;
}
if (quit)
{
break;
}
}
}
break;
}
}
}
if (string.IsNullOrEmpty(FinalUrl))
{
MessageBox.Show(this, LocRm.GetString("SelectURL"));
return;
}
MainForm.IPUN = txtUsername.Text;
MainForm.IPPASS = txtPassword.Text;
MainForm.IPTYPE = make;
MainForm.IPMODEL = model;
MainForm.IPADDR = txtIPAddress.Text;
MainForm.IPPORTS = txtPorts.Text;
MainForm.IPPORT = (int)numPort.Value;
MainForm.IPCHANNEL = txtChannel.Text.Trim();
LastConfig.PromptSave = !MainForm.IPLISTED && MainForm.IPMODEL.Trim() != "" && VideoSourceType != 9;
LastConfig.Iptype = MainForm.IPTYPE;
LastConfig.Ipmodel = MainForm.IPMODEL;
if (s?.MmUrl != null)
{
AudioModel = s.MmUrl.AudioModel;
LastConfig.Prefix = s.MmUrl.prefix;
LastConfig.Source = s.Source;
LastConfig.URL = s.MmUrl.url;
LastConfig.Cookies = s.MmUrl.cookies;
LastConfig.Flags = s.MmUrl.flags;
tokenPath = s.MmUrl.tokenPath;
tokenPost = s.MmUrl.tokenPost;
tokenPort = s.MmUrl.tokenPort;
if (s.MmUrl.portSpecified)
{
LastConfig.Port = Convert.ToInt32(s.MmUrl.port);
}
}
if (_dt != null)
{
MainForm.IPTABLE = _dt.Copy();
}
DialogResult = DialogResult.OK;
Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
ConnectionOption.getIP();
}
/// <summary>
/// 主要是用来获取数据库连接
/// </summary>
/// <param name="options">连接字符串配置</param>
/// <param name="logger">日志组件</param>
/// <param name="connectionName">连接字符串名称</param>
public DbHelper(IOptionsMonitor <SqlConnectionOption> options, ILogger <DbHelper> logger, string connectionName)
{
_current = (ConnectionOption)options.CurrentValue[connectionName];
_logger = logger;
}
private void ListCameras(IEnumerable <ManufacturersManufacturer> mm, string model)
{
model = (model ?? "").ToLowerInvariant();
//find http port
_discoverer = new URLDiscovery(Uri);
//check for onvif support first
int i = 0;
try
{
var httpUri = _discoverer.BaseUri.SetPort(_discoverer.HttpPort);
//check for this devices
foreach (var d in Discovery.DiscoveredDevices)
{
if (d.DnsSafeHost == Uri.DnsSafeHost)
{
httpUri = _discoverer.BaseUri.SetPort(d.Port);
break;
}
}
var onvifurl = httpUri + "onvif/device_service";
var dev = new ONVIFDevice(onvifurl, Username, Password);
if (dev.Profiles != null)
{
foreach (var p in dev.Profiles)
{
var b = p?.VideoEncoderConfiguration?.Resolution;
if (b != null && b.Width > 0)
{
dev.SelectProfile(i);
var co = new ConnectionOption(onvifurl, null, 9, -1, null)
{
MediaIndex = i
};
URLFound?.Invoke(this,
new ConnectionOptionEventArgs(co));
}
i++;
}
}
}
catch (Exception ex)
{
Logger.LogException(ex);
}
foreach (var m in mm)
{
//scan selected model first
var cand = m.url.Where(p => p.version.ToLowerInvariant() == model).ToList();
Scan(cand);
cand = m.url.Where(p => p.version.ToLowerInvariant() != model).ToList();
Scan(cand);
if (_quit)
{
break;
}
}
ScanComplete?.Invoke(this, EventArgs.Empty);
Finished.Set();
}
public ConnectionOptionEventArgs(ConnectionOption co)
{
Co = co;
}
private void ListCameras(IEnumerable <ManufacturersManufacturer> m, string login, string password)
{
int i = 0;
try
{
string addr = txtIPAddress.Text.Trim();
var nPort = (int)numPort.Value;
var uri = new Uri("http://" + addr + ":" + nPort);
var onvifurl = uri + "onvif/device_service";
var dev = new ONVIFDevice(onvifurl, Username, Password);
if (dev.Profiles != null)
{
foreach (var p in dev.Profiles)
{
var b = p?.VideoSourceConfiguration?.Bounds;
if (b != null && b.width > 0)
{
dev.SelectProfile(i);
var co = new ConnectionOption(onvifurl, null, 9, -1, null)
{
MediaIndex = i
};
AddONVIF(onvifurl, co);
}
i++;
}
}
}
catch (Exception ex)
{
Logger.LogException(ex);
}
foreach (var s in m)
{
var cand = s.url.ToList();
cand = cand.OrderBy(p => p.Source).ToList();
foreach (var u in cand)
{
Uri addr = GetAddr(u);
UISync.Execute(() => tsslCurrent.Text = addr.ToString());
bool found = Helper.TestAddress(addr, u, login, password);
if (found)
{
AddCamera(addr.ToString(), s, u);
}
if (_quiturlscanner)
{
break;
}
}
if (_quiturlscanner)
{
break;
}
}
}
/// <summary>
/// Initializes the database, loading the engine associated to <paramref name="connectorType"/>.
/// </summary>
/// <parameters>
/// <param name="connectorType">The engine backing the database.</param>
/// <param name="connectionOption">Options related to connection to a server.</param>
/// </parameters>
public virtual void Initialize(ConnectorType connectorType, ConnectionOption connectionOption)
{
Initialize(connectorType, connectionOption, true);
}
private void theout(object sender, System.Timers.ElapsedEventArgs e)
{
SetValue(HXOpc.itemsValue[27][1]);
if (Interlocked.Exchange(ref timeThreadRunFlag, 1) == 0)
{
DateTime cycleStartTime = System.DateTime.Now;
DateTime cycleEndTime;
TimeSpan ts;
lock (locker)
{
ConnectionOption.checkConnections(listConn);
foreach (ConnectionOption item in listConn)
{
if (!lastQualityDataCountDic.ContainsKey(item.machineID))
{
lastQualityDataCountDic.Add(item.machineID, -1);
}
DateTime connStartTime = System.DateTime.Now;
(new IMDataBase()).writeConnToDataBase(item);
if (item.controllerType.IndexOf("gefran") != -1 && item.connStatus == "1")
{
// new DataCapture().getFilesFromGefran(item.loginName, item.loginPassword, @"ftp://" + item.IP + @"/gefran/recipes/", Application.StartupPath + @"\data\" + item.controllerType, item.machineID + ".zip");
JObject jo = ObjectAnalysis.analyseGefranFile(Application.StartupPath + @"\data\" + item.controllerType, item.machineID + ".txt", 0, item.controllerType);
//DateTime connEndTime = System.DateTime.Now;
//ts = connEndTime.Subtract(connStartTime);
//jo["sampleTime"] = ts.TotalMilliseconds.ToString().Remove(ts.TotalMilliseconds.ToString().IndexOf('.') + 2);
//Console.WriteLine("{0}耗时{1}ms.", item.machineID, ts.TotalMilliseconds);
string data = "";
if (item.controllerType == "gefranVedo")
{
string qualityData = "";
string qualityDataCount = jo["overView"]["TOTPR"][1].ToString();
(new InjectionMachine()).convertedFromGefranVedo(jo, ref data);
InjectionMachine.getQualityDataFromGefranVedo(jo, ref qualityData);
if (Int32.Parse(qualityDataCount) != lastQualityDataCountDic[item.machineID])
{
lastQualityDataCountDic[item.machineID] = Int32.Parse(qualityDataCount);
InjectionMachine.getQualityDataFromGefranVedo(jo, ref qualityData);
(new IMDataBase()).writeQualityDataToDB(IMDataBase.connStr, item.machineID, qualityDataCount, qualityData);
}
}
else
{
string qualityData = "";
string qualityDataCount = jo["overView"]["CURRENT_TOTAL_PRODUCTION"][1].ToString();
(new InjectionMachine()).convertedFromGefranPerforma(jo, ref data);
//InjectionMachine.getQualityDataFromGefranPerforma(jo, ref qualityData);
if (Int32.Parse(qualityDataCount) != lastQualityDataCountDic[item.machineID])
{
lastQualityDataCountDic[item.machineID] = Int32.Parse(qualityDataCount);
InjectionMachine.getQualityDataFromGefranPerforma(jo, ref qualityData);
(new IMDataBase()).writeQualityDataToDB(IMDataBase.connStr, item.machineID, qualityDataCount, qualityData);
}
}
(new IMDataBase()).writeDataBase(IMDataBase.connStr, item.machineID, data);
}
else if (item.controllerType.IndexOf("keba") != -1 && item.connStatus == "1")
{
string kebaData = "";
try {
StreamReader sr = new StreamReader(@"c:\data\" + item.controllerType + @"\" + item.machineID + ".txt");
if (sr != null)
{
kebaData = sr.ReadToEnd();
sr.Close();
// kebaData = kebaData.Replace("Mold1", "clamp");
// kebaData = kebaData.Replace("Ejector1", "ejector");
// kebaData = kebaData.Replace("Injection1", "injection");
//kebaData.Replace("Carrage", "carrage");
// kebaData = kebaData.Replace("Core1", "core");
kebaData = kebaData.Replace("Unknown", "\"Unknown\"");
kebaData = kebaData.Replace("---", "\"---\"");
Console.Write(item.machineID);
var joTmp = JsonConvert.DeserializeObject(kebaData);
if (joTmp != null)
{
JObject jo = (JObject)joTmp;
// DateTime connEndTime = System.DateTime.Now;
// ts = connEndTime.Subtract(connStartTime);
jo.Add("sampleTime", "");
jo.Add("timestamp", System.DateTime.Now.ToString());
jo.Add("machineID", item.machineID);
// jo["sampleTime"] = ts.TotalMilliseconds.ToString().Remove(ts.TotalMilliseconds.ToString().IndexOf('.') + 2);
//jo["timestamp"] = System.DateTime.Now.ToString();
InjectionMachine macWithKeba = new InjectionMachine();
string machineData = "";
macWithKeba.convertedFromKeba(jo, ref machineData);
//kebaData = JsonConvert.SerializeObject(new InjectionMachineWithGefran());
string qualityData = "";
string qualityDataCount = jo["system.sv_iShotCounterAct"][1].ToString();
if (lastQualityDataCountDic[item.machineID] == -1)
{
lastQualityDataCountDic[item.machineID] = Int32.Parse(qualityDataCount);
}
else if (Int32.Parse(qualityDataCount) != lastQualityDataCountDic[item.machineID])
{
lastQualityDataCountDic[item.machineID] = Int32.Parse(qualityDataCount);
InjectionMachine.getQualityDataFromKeba(jo, ref qualityData);
(new IMDataBase()).writeQualityDataToDB(IMDataBase.connStr, item.machineID, qualityDataCount, qualityData);
}
(new IMDataBase()).writeDataBase(IMDataBase.connStr, item.machineID, machineData);
}
}
}
catch (ArgumentException k)
{
Console.WriteLine("me");
Console.WriteLine(k);
}
catch (Exception k)
{
Console.WriteLine("others");
}
// DateTime connEndTime = System.DateTime.Now;
// ts = connEndTime.Subtract(connStartTime);
//Console.WriteLine(ts);
}
}
}
Console.WriteLine("fast");
cycleEndTime = System.DateTime.Now;
ts = cycleEndTime.Subtract(cycleStartTime);
Console.WriteLine("循环耗时{0}ms.", ts.TotalMilliseconds);
Interlocked.Exchange(ref timeThreadRunFlag, 0);
}
}
public static extern WNetAddConnection2ReturnCode WNetAddConnection2(
ref NetResource netResource,
string strPassword,
string strUserName,
ConnectionOption dwFlags
);
public SqlConnectionProxy(string[] connectionStrings, ConnectionOption connectionOption = ConnectionOption.FirstOnly, int maxAttempts = 1)
: base(connectionStrings, connectionOption, maxAttempts)
{
}