winfromC#树勾选等

///

/// 树勾选///

/// /// private void tvCourse_AfterCheck(object sender, TreeViewEventArgs e){if (e.Action &＃61;&＃61;TreeViewAction.ByMouse){if (e.Node.Checked){SetChildNode(e.Node, true);if (null!&＃61; e.Node.Parent){SetParentNode(e.Node, true);}//获取选中节点值
lstChapterIds.Add(e.Node.Name);this.btnDelRes.Enabled &＃61; true;}else{//取消节点选中状态之后&＃xff0c;取消所有父节点的选中状态SetChildNode(e.Node, false);//如果节点存在父节点&＃xff0c;取消父节点的选中状态if (e.Node.Parent !&＃61; null){SetParentNode(e.Node, false);}//获取选中节点值if (lstChapterIds.Contains(e.Node.Name)){lstChapterIds.Remove(e.Node.Name);if (!lstChapterIds.Any()){this.btnDelRes.Enabled &＃61; false;}}}}}

///

/// 查找根节点///

/// 节点node/// private TreeNode FindParentNode(TreeNode node){if (node.Parent &＃61;&＃61; null){return node;}else{return FindParentNode(node);}}///

/// 设置父节点///

/// 当前节点/// 状态private void SetParentNode(TreeNode node, bool state){TreeNode pNode &＃61; node.Parent;if (null !&＃61; pNode){pNode.Checked &＃61; state;bool flag &＃61; false;foreach (TreeNode currNode in pNode.Nodes){if (!currNode.Checked) //控制父节点全选,父节点选中去掉!
{flag &＃61; false;pNode.Checked &＃61; flag;break;}//SetParentNode(item, state);
}if (pNode.Checked ){//获取选中节点值
lstChapterIds.Add(pNode.Name);}else{if (lstChapterIds.Contains(pNode.Name)){lstChapterIds.Remove(pNode.Name);}}SetParentNode(pNode, flag);}}///

/// 设置子节点///

/// 当前节点/// 状态private void SetChildNode(TreeNode node, bool state){TreeNodeCollection tncNodes &＃61; node.Nodes;if (tncNodes.Count>0){foreach (TreeNode currNode in tncNodes){currNode.Checked &＃61; state;if (currNode.Checked){//获取选中节点值
lstChapterIds.Add(currNode.Name);}else{if (lstChapterIds.Contains(currNode.Name)){lstChapterIds.Remove(currNode.Name);}}SetChildNode(currNode, state);}}}

bool createdNew &＃61; false;System.Threading.Mutex instance &＃61; new System.Threading.Mutex(true, Application.ProductName, out createdNew);if (createdNew){//...........code
instance.ReleaseMutex();}else{MessageBox.Show("该程序已经在运行&＃xff01;", Application.ProductName,MessageBoxButtons.OK, MessageBoxIcon.Exclamation);Application.Exit();}

private delegate void UploadPro(int mProgre);private event UploadPro UploadProEvent;UploadProEvent &＃43;&＃61;ResourceManage_UploadProEvent;void ResourceManage_UploadProEvent(int mProgree)
{//......

}var thread &＃61; new Thread(new ThreadStart(method));
thread.Start();

ZipInputStream inputStream &＃61; new ZipInputStream(File.OpenRead(strFilePath));
ZipEntry theEntry;
//读取文件名List<string> fileNameList &＃61; new List<string>();while ((theEntry &＃61; inputStream.GetNextEntry()) !&＃61; null){totalSize &＃43;&＃61; theEntry.UncompressedSize;string templateName &＃61; theEntry.FileName;string fileName &＃61; Path.GetFileName(templateName);if (!string.IsNullOrEmpty(fileName))fileNameList.Add(fileName);}inputStream.Close();#region 解压文件inputStream &＃61; new ZipInputStream(File.OpenRead(filePath));//long totalSize &＃61; inputStream.Length;long currentSize &＃61; 0;int currentPro &＃61; 0;ZipEntry theEntry;ZipFile zf &＃61; ZipFile.Read(filePath);//以文件流来解压所有文件&＃xff0c;同时计算进度while ((theEntry &＃61; inputStream.GetNextEntry()) !&＃61; null){//totalSize &＃43;&＃61; theEntry.UncompressedSize;//long totalSize &＃61; theEntry.UncompressedSize;//destPath &＃43;&＃61; "/";//string templateName &＃61; theEntry.FileName;//string fileName &＃61; Path.GetFileName(templateName);////string dir &＃61; Path.GetDirectoryName(templateName);//string dir &＃61; templateName;//if (!dir.Contains("\\") && string.IsNullOrEmpty(fileName))//{// continue;//} ////截取目录文件夹//if (dir.Contains("\\"))// dir &＃61; dir.Substring(dir.IndexOf("\\") &＃43; 1, dir.Length - dir.IndexOf("\\") - 1);//if (templateName.Length &＃61;&＃61; (dir &＃43; "/" &＃43; fileName).Length) dir &＃61; "";////theEntry.IsDirectory 是否目录//string path &＃61; Path.GetDirectoryName(destPath) &＃43; "/" &＃43; dir &＃43; "/";////Path.GetDirectoryName(baseDir) &＃43; "/";////if (!Directory.Exists(path)) // Directory.CreateDirectory(path);string strFilePath &＃61; string.Empty;string templateName &＃61; theEntry.FileName;if (!templateName.Contains("\\")){//文件strFilePath &＃61; destPath &＃43; "\\" &＃43; theEntry.FileName;}else{//文件夹里文件strFilePath &＃61; destPath &＃43; theEntry.FileName;}if (!Directory.Exists(Path.GetDirectoryName(strFilePath))){Directory.CreateDirectory(Path.GetDirectoryName(strFilePath));}string fileName &＃61; Path.GetFileName(templateName);if (fileName !&＃61; String.Empty){FileStream streamWriter &＃61; File.OpenWrite(strFilePath); //解压文件到指定的目录 int size &＃61; 0;byte[] data &＃61; new byte[2048];try{while (true){size &＃61; inputStream.Read(data, 0, data.Length);if (size > 0){streamWriter.Write(data, 0, size);currentSize &＃43;&＃61; size;}else{break;}currentPro &＃61; Convert.ToInt32(100 * currentSize / totalSize);this.Invoke(UploadProEvent,currentPro);}}catch (Exception ex){LogHelper.Error(this.GetType(), ex);this.Invoke(UploadProEvent, -1); //-1 导入失败
}finally{streamWriter.Close();}}}inputStream.Close();#endregion

///

/// 检查指导盘符剩余空间///

/// /// public static long GetHardDiskFreeSpace(string str_HardDiskName){if (string.IsNullOrEmpty(str_HardDiskName)) return 0;long freeSpace &＃61; new long();System.IO.DriveInfo[] drives &＃61; System.IO.DriveInfo.GetDrives();foreach (System.IO.DriveInfo drive in drives){if (drive.Name &＃61;&＃61; str_HardDiskName){freeSpace &＃61; drive.TotalFreeSpace;}}return freeSpace;}///

/// 找出当前客户端剩余空间最大盘符///

/// public static Dictionary<string, long> GetSystemDirtory(){Dictionary<string, long> freeSpace &＃61; new Dictionary<string, long>();DriveInfo[] drives &＃61; DriveInfo.GetDrives();foreach (DriveInfo drive in drives){if (drive.DriveType &＃61;&＃61; DriveType.Fixed)freeSpace.Add(drive.Name, drive.TotalFreeSpace);}string hardDiskName &＃61; freeSpace.ToArray().Max(x &＃61;> x.Key);long hardDiskSize &＃61; freeSpace.ToArray().Max(x &＃61;> x.Value);freeSpace.Clear();freeSpace.Add(hardDiskName, hardDiskSize);return freeSpace;}

///

/// 获取网卡MAC地址///

/// public static string GetNetCardMAC(){try{string stringMAC &＃61; "";ManagementClass MC &＃61; new ManagementClass("Win32_NetworkAdapterConfiguration");ManagementObjectCollection MOC &＃61; MC.GetInstances();foreach (ManagementObject MO in MOC){if ((bool)MO["IPEnabled"] &＃61;&＃61; true){stringMAC &＃43;&＃61; MO["MACAddress"].ToString();}}return stringMAC;}catch{return "";}}

///

/// 获取远程文件信息///

/// /// public static RemoteFileInfo GetFileInfo(string url){RemoteFileInfo result &＃61; new RemoteFileInfo();try{GC.Collect();HttpWebRequest request &＃61; (HttpWebRequest)WebRequest.Create(url);HttpWebResponse response &＃61; (HttpWebResponse)request.GetResponse();result.MimeType &＃61; response.ContentType;result.LastModified &＃61; response.LastModified;result.FileSize &＃61; response.ContentLength;result.AcceptRanges &＃61; String.Compare(response.Headers["Accept-Ranges"], "bytes", true) &＃61;&＃61; 0;//关闭连接
response.Close();request.KeepAlive &＃61; false;}catch (Exception ex){throw;}return result;}

#region 日志方法public void LogTest(string str){string path &＃61; System.IO.Directory.GetCurrentDirectory() &＃43; "\\log\\";if (!Directory.Exists(path)){DirectoryInfo directorylnfo &＃61; new DirectoryInfo(path);directorylnfo.Create();}string dt &＃61; "\r\n时间&＃xff1a;" &＃43; DateTime.Now.ToString("yyyymmddhhmmss") &＃43; "\r\n内容&＃xff1a;" &＃43; str;int len &＃61; dt.Length;byte[] inputByts &＃61; new byte[len];inputByts &＃61; Encoding.GetEncoding("utf-8").GetBytes(dt);System.IO.FileStream fs &＃61; new System.IO.FileStream(path &＃43; "log.txt", System.IO.FileMode.OpenOrCreate);fs.Seek(0, System.IO.SeekOrigin.End);fs.Write(inputByts, 0, inputByts.Length);fs.Close();//关闭流
} #endregion

///

/// 错误日志///

/// public static void WriteLog(Exception ex){string logPath &＃61; GetResDir() &＃43; "/log";string message &＃61; string.Format("\r\n\r\n异常时间&＃xff1a;{0} \r\n错误源&＃xff1a;{1} \r\n异常信息&＃xff1a;{2}",DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss,fff"), ex.Source, ex.Message);File.AppendAllText(logPath &＃43; DateTime.Now.ToString("yyyy.MM.dd") &＃43; ".log", message, Encoding.UTF8);}

///

/// 启动服务sc.DisplayName///

/// public static void StartService(string serverName){if (string.IsNullOrEmpty(serverName)) return;ServiceController sc &＃61; new ServiceController(serverName);if (sc.DisplayName !&＃61; null){if (sc.Status &＃61;&＃61; ServiceControllerStatus.Stopped) sc.Start();}}///

/// 停止服务///

/// public static void StopService(string serverName){if (string.IsNullOrEmpty(serverName)) return;ServiceController sc &＃61; new ServiceController(serverName);if (sc.DisplayName !&＃61; null) {if (sc.Status &＃61;&＃61; ServiceControllerStatus.Running) sc.Stop();}}

public string InsertORupdateData(List _list, string dtName,string columnName){StringBuilder sbInsert &＃61; new StringBuilder();ArrayList list &＃61; new ArrayList();try{string sqlstr &＃61; "";if (_list !&＃61; null && _list.Count > 0){System.Reflection.PropertyInfo[] p &＃61; _list[0].GetType().GetProperties();int length &＃61; 0;string values &＃61; "";for (int i &＃61; 0; i <_list.Count; i&＃43;&＃43;){string sbUpdateSql &＃61; "";int count &＃61; 0;string upwh &＃61; "";length &＃61; 0;//通过反射获取list中的字段 foreach (System.Reflection.PropertyInfo pi in p){string cName &＃61; pi.Name;string cValue &＃61; (pi.GetValue(_list[i], null) &＃61;&＃61; null? "": (pi.GetValue(_list[i], null)).ToString().Replace("&＃39;", "")); //替换 &＃39;语法错误的if (cName.ToLower() &＃61;&＃61; columnName.ToLower()){string sql &＃61; "select count(0) from " &＃43; dtName &＃43; " where " &＃43; columnName &＃43; "&＃61;&＃39;"&＃43;cValue&＃43;"&＃39;";upwh &＃61; " where " &＃43; columnName &＃43; "&＃61;&＃39;" &＃43; cValue &＃43; "&＃39;";count &＃61; ExcelHelper.GetScalar(sql);}if (length &＃61;&＃61; 0){sqlstr &＃61; "INSERT INTO " &＃43; dtName &＃43; " (";values &＃61; "(";sbUpdateSql&＃43;&＃61;"update " &＃43; dtName &＃43; " set ";}length &＃43;&＃61; 1;if (length < p.Length){sbUpdateSql &＃43;&＃61; cName &＃43; "&＃61; &＃39;" &＃43; cValue &＃43;"&＃39;,";sqlstr &＃43;&＃61; cName &＃43; ",";values &＃43;&＃61; "&＃39;" &＃43; cValue &＃43; "&＃39;,";}else{sbUpdateSql &＃43;&＃61; cName &＃43; "&＃61; &＃39;" &＃43; cValue &＃43; "&＃39;";sqlstr &＃43;&＃61; cName &＃43; ") Values";values &＃43;&＃61; "&＃39;" &＃43; cValue &＃43; "&＃39;); ";if (count > 0){sqlstr &＃61; sbUpdateSql &＃43; upwh;values &＃61; "";}}}sqlstr &＃43;&＃61; values;list.Add(sqlstr);}}//for (int i &＃61; 0; i //{// ArrayList arrList &＃61; new ArrayList();// arrList.Add(list[i]);// var result &＃61; AccessDbHelper.ExecuteSqlTran(arrList);//}//string str &＃61; string.Join("", list.ToArray());var result &＃61; AccessDbHelper.ExecuteSqlTran(list);return "success";}catch (Exception err){LogTest(err.ToString());return err.ToString();}}