C sharp

C#

实现发送电子邮件

using System.Net.Mail;

try

           { 
           MailMessage mail = new MailMessage(); 
           string from = "XXXXXX@163.com";   发件人地址 
           string fromname = "your name"; 
           mail.From = new MailAddress(from, fromname); 
           string to = "XXXXXXX@qq.com"; 收件人 
           mail.To.Add(to); 
           string subject = "测试邮件"; 
           mail.Subject = subject; 
           mail.BodyEncoding = System.Text.Encoding.UTF8; 
           mail.Priority = MailPriority.Normal; 
           string body = "这时测试邮件
测试html格式"; 
           mail.Body = body; 
           mail.IsBodyHtml = true; 
           mail.DeliveryNotificationOptions = DeliveryNotificationOptions.OnSuccess; 
           string fujian = Server.MapPath("//") +"XXXXX.rar"; 
           if (fujian.Length > 0) 
           { 
               mail.Attachments.Add(new Attachment(fujian)); 
           } 
           SmtpClient smtp = new SmtpClient("smtp.163.com", 25); 
           smtp.UseDefaultCredentials = true; 
           smtp.UseDefaultCredentials = false; 
           smtp.DeliveryMethod = SmtpDeliveryMethod.Network; 
           //指定登录名和密码  
           smtp.Credentials = new System.Net.NetworkCredential("loginname", "password"); 
           smtp.Timeout = 10000; 
           smtp.Send(mail); 
           Label2.Text = "send ok"; 
           } 
 
           catch (Exception exp) 
           { 
 
               Label2.Text = exp.Message; 
 
           } 
 
 

using System.Net.Mail; public bool SendMailUse(string sendTo, string subject, string body)

       { 
           string host = "smtp.163.com";// 邮件服务器smtp.163.com表示网易邮箱服务器     
           string userName = "xxxxxxxx@163.com";// 发送端账号    
           string password = "xxxxxxx";// 发送端密码(这个客户端重置后的密码) 
           SmtpClient client = new SmtpClient(); 
           client.DeliveryMethod = SmtpDeliveryMethod.Network;//指定电子邮件发送方式     
           client.Host = host;//邮件服务器 
           client.UseDefaultCredentials = true; 
           client.Credentials = new System.Net.NetworkCredential(userName, password);//用户名、密码 
           string strfrom = userName; 
           //string strcc = "xxxxxxxx@qq.com";//抄送 
           System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(); 
           msg.From = new MailAddress(strfrom, "盛铭逸品"); 
           msg.To.Add(sendTo); 
           //msg.CC.Add(strcc);  //抄送 
 
           msg.Subject = subject;//邮件标题    
           msg.Body = body;//邮件内容    
           msg.BodyEncoding = System.Text.Encoding.UTF8;//邮件内容编码    
           msg.IsBodyHtml = true;//是否是HTML邮件    
           msg.Priority = MailPriority.High;//邮件优先级    
 
 
           try 
           { 
               client.Send(msg); 
               return true; 
           } 
           catch (System.Net.Mail.SmtpException ex) 
           { 
               return false; 
           } 
       } 

小写数字转换成大写金额

public string MoneyToChinese(string LowerMoney)

       { 
 
           string functionReturnValue = null; 
 
           bool IsNegative = false; // 是否是负数 
 
           if (LowerMoney.Trim().Substring(0, 1) == "-") 
           { 
 
               // 是负数则先转为正数 
 
               LowerMoney = LowerMoney.Trim().Remove(0, 1); 
 
               IsNegative = true; 
 
           } 
 
           string strLower = null; 
 
           string strUpart = null; 
 
           string strUpper = null; 
 
           int iTemp = 0; 
 
           // 保留两位小数 123.489→123.49　　123.4→123.4 
 
           LowerMoney = Math.Round(double.Parse(LowerMoney), 2).ToString(); 
 
           if (LowerMoney.IndexOf(".") > 0) 
           { 
 
               if (LowerMoney.IndexOf(".") == LowerMoney.Length - 2) 
               { 
 
                   LowerMoney = LowerMoney + "0"; 
 
               } 
 
           } 
 
           else 
           { 
 
               LowerMoney = LowerMoney + ".00"; 
 
           } 
 
           strLower = LowerMoney; 
 
           iTemp = 1; 
 
           strUpper = ""; 
 
           while (iTemp <= strLower.Length) 
           { 
 
               switch (strLower.Substring(strLower.Length - iTemp, 1)) 
               { 
 
                   case ".": 
 
                       strUpart = "圆"; 
 
                       break; 
 
                   case "0": 
 
                       strUpart = "零"; 
 
                       break; 
 
                   case "1": 
 
                       strUpart = "壹"; 
 
                       break; 
 
                   case "2": 
 
                       strUpart = "贰"; 
 
                       break; 
 
                   case "3": 
 
                       strUpart = "叁"; 
 
                       break; 
 
                   case "4": 
 
                       strUpart = "肆"; 
 
                       break; 
 
                   case "5": 
 
                       strUpart = "伍"; 
 
                       break; 
 
                   case "6": 
 
                       strUpart = "陆"; 
 
                       break; 
 
                   case "7": 
 
                       strUpart = "柒"; 
 
                       break; 
 
                   case "8": 
 
                       strUpart = "捌"; 
 
                       break; 
 
                   case "9": 
 
                       strUpart = "玖"; 
 
                       break; 
 
               } 
 
 
 
               switch (iTemp) 
               { 
 
                   case 1: 
 
                       strUpart = strUpart + "分"; 
 
                       break; 
 
                   case 2: 
 
                       strUpart = strUpart + "角"; 
 
                       break; 
 
                   case 3: 
 
                       strUpart = strUpart + ""; 
 
                       break; 
 
                   case 4: 
 
                       strUpart = strUpart + ""; 
 
                       break; 
 
                   case 5: 
 
                       strUpart = strUpart + "拾"; 
 
                       break; 
 
                   case 6: 
 
                       strUpart = strUpart + "佰"; 
 
                       break; 
 
                   case 7: 
 
                       strUpart = strUpart + "仟"; 
 
                       break; 
 
                   case 8: 
 
                       strUpart = strUpart + "万"; 
 
                       break; 
 
                   case 9: 
 
                       strUpart = strUpart + "拾"; 
 
                       break; 
 
                   case 10: 
 
                       strUpart = strUpart + "佰"; 
 
                       break; 
 
                   case 11: 
 
                       strUpart = strUpart + "仟"; 
 
                       break; 
 
                   case 12: 
 
                       strUpart = strUpart + "亿"; 
 
                       break; 
 
                   case 13: 
 
                       strUpart = strUpart + "拾"; 
 
                       break; 
 
                   case 14: 
 
                       strUpart = strUpart + "佰"; 
 
                       break; 
 
                   case 15: 
 
                       strUpart = strUpart + "仟"; 
 
                       break; 
 
                   case 16: 
 
                       strUpart = strUpart + "万"; 
 
                       break; 
 
                   default: 
 
                       strUpart = strUpart + ""; 
 
                       break; 
 
               } 
 
 
 
               strUpper = strUpart + strUpper; 
 
               iTemp = iTemp + 1; 
 
           } 
 
 
 
           strUpper = strUpper.Replace("零拾", "零"); 
 
           strUpper = strUpper.Replace("零佰", "零"); 
 
           strUpper = strUpper.Replace("零仟", "零"); 
 
           strUpper = strUpper.Replace("零零零", "零"); 
 
           strUpper = strUpper.Replace("零零", "零"); 
 
           strUpper = strUpper.Replace("零角零分", "整"); 
 
           strUpper = strUpper.Replace("零分", "整"); 
 
           strUpper = strUpper.Replace("零角", "零"); 
 
           strUpper = strUpper.Replace("零亿零万零圆", "亿圆"); 
 
           strUpper = strUpper.Replace("亿零万零圆", "亿圆"); 
 
           strUpper = strUpper.Replace("零亿零万", "亿"); 
 
           strUpper = strUpper.Replace("零万零圆", "万圆"); 
 
           strUpper = strUpper.Replace("零亿", "亿"); 
 
           strUpper = strUpper.Replace("零万", "万"); 
 
           strUpper = strUpper.Replace("零圆", "圆"); 
 
           strUpper = strUpper.Replace("零零", "零"); 
 
 
 
           // 对壹圆以下的金额的处理 
 
           if (strUpper.Substring(0, 1) == "圆") 
           { 
 
               strUpper = strUpper.Substring(1, strUpper.Length - 1); 
 
           } 
 
           if (strUpper.Substring(0, 1) == "零") 
           { 
 
               strUpper = strUpper.Substring(1, strUpper.Length - 1); 
 
           } 
 
           if (strUpper.Substring(0, 1) == "角") 
           { 
 
               strUpper = strUpper.Substring(1, strUpper.Length - 1); 
 
           } 
 
           if (strUpper.Substring(0, 1) == "分") 
           { 
 
               strUpper = strUpper.Substring(1, strUpper.Length - 1); 
 
           } 
 
           if (strUpper.Substring(0, 1) == "整") 
           { 
 
               strUpper = "零圆整"; 
 
           } 
 
           functionReturnValue = strUpper; 
 
 
 
           if (IsNegative == true) 
           { 
 
               return "负" + functionReturnValue; 
 
           } 
 
           else 
           { 
 
               return functionReturnValue; 
 
           } 
 
       } 

使用图表chart

chartType.Series.Clear();

           Series Series1 = new Series(); 
           chartType.Series.Add(Series1); 
           chartType.Series["Series1"].ChartType = SeriesChartType.Pie;  //图ª?标À¨º类¤¨¤型¨ª饼Ày状Á¡ä图ª? 
           chartType.Series["Series1"].ChartType = SeriesChartType.StackedColumn;  //透ª?明¡Â柱¨´状Á¡ä图ª? 
           //chartType.Series[0].CustomProperties = "DrawingStyle = Cylinder";  //圆2柱¨´形? 
           chartType.Series[0].Palette = ChartColorPalette.SemiTransparent; //颜?色¦? 
           //chartType.Series[0].Palette = ChartColorPalette.BrightPastel;  
           //========标À¨º题¬a================= 
           chartType.Titles.Add("客¨ª户¡ì数ºy据Y分¤?析?"); 
           chartType.Titles[0].ForeColor = System.Drawing.Color.FromArgb(154, 123, 123); 
           chartType.Titles[0].Font = new Font("微¡é软¨¨ª雅?黑¨²", 16f, FontStyle.Regular); 
           chartType.Titles[0].Alignment = ContentAlignment.TopCenter; 
           //chartType.BackColor = Color.Transparent; 
           chartType.ChartAreas[0].BackColor = Color.Transparent; 
           chartType.ChartAreas[0].BorderColor = Color.Transparent; 
            
           chartType.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;//开a启?三¨y维?模¡ê式º?;PointDepth:厚?度¨¨BorderWidth:边À?框¨°宽¨ª 
           chartType.ChartAreas["ChartArea1"].Area3DStyle.Rotation = 15;//起e始º?角?度¨¨ 
           chartType.ChartAreas["ChartArea1"].Area3DStyle.Inclination = 30;//倾?斜¡À度¨¨(0～?90) 
           chartType.ChartAreas["ChartArea1"].Area3DStyle.LightStyle = LightStyle.Realistic;//表À¨ª面?光a泽¨®度¨¨ 
           //chartType.ChartAreas["ChartArea1"].AxisX.Interval = 1; //决?定¡§x轴¨¢显?示º?文?本À?的Ì?间?隔?，ê?1为a强?制?每?个?柱¨´状Á¡ä体¬?都?显?示º?，ê?3则¨°间?隔?3个?显?示º? 
           chartType.ChartAreas["ChartArea1"].AxisX.LabelStyle.Font =new Font("宋?体¬?", 9, FontStyle.Regular); 
           //chartType.ChartAreas["ChartArea1"].AxisX.MajorGrid.Enabled = false; 
 
           chartType.Series[0].Points.AddXY(1, 123); 
           chartType.Series[0].Points[0].Label = "diao"; 
           chartType.Series[0].Points[0].Font = new Font("微¡é软¨¨ª雅?黑¨²", 16f, FontStyle.Bold); 
           chartType.Series[0].Points[0].LabelForeColor = Color.Black;// System.Drawing.Color.FromArgb(89, 89, 89); 
            
           chartType.Series[0].Points.AddXY(2, 355); 
           chartType.Series[0].Points[1].Label = "刘¢?备À?"; 
           chartType.Series[0].Points[1].Font = new Font("微¡é软¨¨ª雅?黑¨²", 16f, FontStyle.Bold); 
           chartType.Series[0].Points[1].LabelForeColor = Color.Black; // System.Drawing.Color.FromArgb(189, 89, 89); 
           chartType.Series[0].Points.AddXY(3, 789); 
           chartType.Series[0].Points[2].Label = "张?飞¤¨¦"; 
           chartType.Series[0].Points[2].Font = new Font("微¡é软¨¨ª雅?黑¨²", 16f, FontStyle.Bold); 
           chartType.Series[0].Points[2].LabelForeColor = Color.Black; //System.Drawing.Color.FromArgb(189, 89, 189); 
 
           chartType.Series[0].Points.AddXY(4, 564); 
           chartType.Series[0].Points[3].Label = "关?羽®e38"; 
           chartType.Series[0].Points[3].Font = new Font("微¡é软¨¨ª雅?黑¨²", 16f, FontStyle.Bold); 
           chartType.Series[0].Points[3].LabelForeColor = Color.Black; //System.Drawing.Color.FromArgb(123, 89, 189); 
           chartType.Series[0].Color = Color.Lime; 
           Legend legend1 = new Legend("#VALX"); //饼Ày状Á¡ä图ª?legend 
 
           legend1.Title = "客¨ª户¡ì统ª3计?"; 
           legend1.ForeColor = Color.Black; 
 
 
           //chartType.Series[0].LegendText = chartType.Series[0]. 
           chartType.Legends.Add(legend1); 
           /* 
           LegendCellColumn avgColumn = new LegendCellColumn(); 
           avgColumn.Text = "#AVG{N2}"; 
           avgColumn.HeaderText = "Avg"; 
           avgColumn.Name = "AvgColumn"; 
           avgColumn.HeaderBackColor = Color.WhiteSmoke; 
           chartType.Legends[0].CellColumns.Add(avgColumn); 
           LegendCellColumn avgColumn1 = new LegendCellColumn(); 
           avgColumn1.Text = "#AVG{N2}"; 
           avgColumn1.HeaderText = "Avg1"; 
           avgColumn1.Name = "AvgColumn1"; 
           avgColumn1.HeaderBackColor = Color.WhiteSmoke; 
           chartType.Legends[0].CellColumns.Add(avgColumn1); 
          */ 
 
 
            
 
 
           //X坐Á?标À¨º轴¨¢颜?色¦? 
           chartType.ChartAreas[0].AxisX.LineColor = ColorTranslator.FromHtml("#cccccc"); 
           chartType.ChartAreas[0].AxisX.LabelStyle.ForeColor = ColorTranslator.FromHtml("#999999");  
           //chartType.ChartAreas[0].AxisX.LabelStyle.Font = new Font("微¡é软¨¨ª雅?黑¨²", 10f, FontStyle.Regular); 
           //X坐Á?标À¨º轴¨¢标À¨º题¬a 
           //chartType.ChartAreas[0].AxisX.Title = "数ºy量¢?(宗Á¨²)"; 
           //chartType.ChartAreas[0].AxisX.TitleFont = new Font("微¡é软¨¨ª雅?黑¨²", 10f, FontStyle.Regular); 
           //chartType.ChartAreas[0].AxisX.TitleForeColor = Color.Black; 
           //chartType.ChartAreas[0].AxisX.TextOrientation = TextOrientation.Horizontal; 
           //chartType.ChartAreas[0].AxisX.ToolTip = "数ºy量¢?(宗Á¨²)"; 
           //X轴¨¢网ª?络?线?条¬? 
           //chartType.ChartAreas[0].AxisX.MajorGrid.Enabled = true; 
           chartType.ChartAreas[0].AxisX.MajorGrid.LineColor = ColorTranslator.FromHtml("#cccccc"); 
 
           //Y坐Á?标À¨º轴¨¢颜?色¦? 
           chartType.ChartAreas[0].AxisY.LineColor = ColorTranslator.FromHtml("#cccccc"); 
           chartType.ChartAreas[0].AxisY.LabelStyle.ForeColor = ColorTranslator.FromHtml("#999999");  
           chartType.ChartAreas[0].AxisY.LabelStyle.Font = new Font("微¡é软¨¨ª雅?黑¨²", 10f, FontStyle.Regular); 
           //Y坐Á?标À¨º轴¨¢标À¨º题¬a 
           //chartType.ChartAreas[0].AxisY.Title = "客¨ª户¡ì数ºy量¢?"; 
           //chartType.ChartAreas[0].AxisY.TitleFont = new Font("微¡é软¨¨ª雅?黑¨²", 10f, FontStyle.Regular); 
           //chartType.ChartAreas[0].AxisY.TitleForeColor = Color.Black; 
           //chartType.ChartAreas[0].AxisY.TextOrientation = TextOrientation.Rotated270; 
           //chartType.ChartAreas[0].AxisY.ToolTip = "客¨ª户¡ì数ºy量¢?"; 
           //Y轴¨¢网ª?格?线?条¬? 
           chartType.ChartAreas[0].AxisY.MajorGrid.Enabled = true; 
           chartType.ChartAreas[0].AxisY.MajorGrid.LineColor = ColorTranslator.FromHtml("#cccccc"); 
 
           chartType.ChartAreas[0].AxisY2.LineColor = Color.Transparent; 
           chartType.ChartAreas[0].BackGradientStyle = GradientStyle.TopBottom; 
 

访问mysql数据

 using MySql.Data.MySqlClient;

   String mysqlStr = "Database=数据库;Data Source=ip;User Id=root;Password=密码;pooling=false;CharSet=utf8;port=3306"; 
       
           MySqlConnection mysql = new MySqlConnection(mysqlStr); 
           String sqlSearch = "select host,user from user"; 
           MySqlCommand mySqlCommand = new MySqlCommand(sqlSearch, mysql); 
           mysql.Open(); 
           MySqlDataReader reader = mySqlCommand.ExecuteReader(); 
           try 
           { 
               while (reader.Read()) 
               { 
                   if (reader.HasRows) 
                   { 
                       Console.WriteLine( reader.GetString(1) + "|---" + reader.GetString(0)); 
                   } 
               } 
           } 
           catch (Exception) 
           { 
               Console.WriteLine("查询失败了！"); 
           } 
           finally 
           { 
               reader.Close(); 
           } 
           mysql.Close(); 
 
           /* 
            try 
          { 
            mySqlCommand.ExecuteNonQuery(); 
           } 
           catch (Exception ex) 
           { 
             String message = ex.Message; 
             Console.WriteLine("插入数据失败了！" + message); 
           } 
                    */

linux

cd path_to_your MySql.Data.dll assembly
gacutil -i MySql.Data.dll

在monpdevelop解决方案里右键编辑引用，在.net程序集中点击浏览,选择MySql.Data.dll文件,调用方法同上

mono官方文档

https://www.mono-project.com/docs/database-access/providers/mysql/

sunnyUI

https://gitee.com/yhuse/SunnyUI

c#开发工具MONO

官网 https://www.mono-project.com/

sudo apt-get install monodevelop

asp web service

sudo apt-get install mono-xsp4

Mono下C#调用linux命令

using System.Diagnostics;
Process p = new Process();
       p.StartInfo.FileName = "sh";
       p.StartInfo.UseShellExecute = false;
       p.StartInfo.RedirectStandardInput = true;
       p.StartInfo.RedirectStandardOutput = true;
       p.StartInfo.RedirectStandardError = true;
       p.StartInfo.CreateNoWindow = true;
       p.Start();
       p.StandardInput.WriteLine("ls -l");
       p.StandardInput.WriteLine("exit");
       string strResult = p.StandardOutput.ReadToEnd();
       label1.Text = strResult;
       p.Close();

上传文件

public string SendFile(string fileName, Uri uri, string encodingType = "UTF-8")
       {

           WebClient myWebClient = new WebClient();
           byte[] responseArray = myWebClient.UploadFile(uri, "POST", fileName);

           return Encoding.GetEncoding(encodingType).GetString(responseArray);
       }

需要php服务支持

  SendFile(@"c:\smypOut.jpeg", new Uri("http://****/uploadFile.php"));

启动exe

using System.Diagnostics;
Process.Start("smyp.jsx");

写入文件

       private void writeFile()
       {
           FileStream fs = new FileStream("smyp.txt",FileMode.Create);
           StreamWriter ws = new StreamWriter(fs);
           ws.Write("asda\r\n");
           ws.Write("22222");
           ws.Flush();
           ws.Close();
           fs.Close();
       }

获取本机ip地址

           IPAddress[] iplist =  Dns.GetHostByName(Dns.GetHostName()).AddressList;
           comboBox2.Items.Clear();
           for (int i = 0; i < iplist.Count(); i++)
           {
               comboBox2.Items.Add(iplist[i]);
           }
           if (comboBox2.Items.Count > 0)
               comboBox2.SelectedIndex = 0;