using System.Text.RegularExpressions;
public static bool taiwancarrier(string input) {
return Regex.IsMatch(input, @"^/[0-9A-Z.+-]{7}$");
}
參考資料
public static double DateToDouble(DateTime? pNow = null)
{
DateTime mNow = DateTime.Now;
if (pNow != null && pNow.HasValue)
{
mNow = pNow.Value;
}
DateTimeOffset t = DateTimeOffset.Parse(mNow.ToString("yyyy-MM-dd HH:mm:ss"));
return Convert.ToDouble(t.ToUnixTimeSeconds());
}
數字轉時間
public static DateTime DoubleToDate(double? pDate = 0)
{
double d = 0;
if (pDate != null && pDate.HasValue)
{
d = pDate.Value;
}
if (d > 9999999999)
d = d / 1000;
DateTime StartComputerFirstDay = new DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc);
return StartComputerFirstDay.AddSeconds(d).ToLocalTime();
}
參考資料
public class Staff
{
public int id { get; set; }
public string name { get; set; }
}
public class StaffViewModel :Staff
{
public int departid { get; set; }
}
如果後端存檔時前端回傳是StaffViewModel但存檔只需要Staff資料
private List<Staff> Merge(List<StaffViewModel> model)
{
List<Staff> result = new List<Staff>(0);
foreach (var item in model)
result.Add(item);
return result;
}
如果以上不是BUG的話設計時能多用原本存在的方式就能少裝些插件
DirectoryInfo di = new DirectoryInfo(@"\\192.168.0.1\old");
//所有檔案列表包含子資料夾
var queryfileall = di.GetFiles("*", SearchOption.AllDirectories);
//指定單一副檔名
var queryfileone = di.GetFiles("*.jpg", SearchOption.AllDirectories);
//指定多重副檔名
string[] extensions = new[] { ".jpg", ".mp3"};
var queryfilemultiple = di.GetFiles("*", SearchOption.AllDirectories).Where(x => extensions.Contains(x.Extension.ToLower())).ToArray();
//建立資料夾
string newpath = @"\\192.168.0.1\new";
if (!Directory.Exists(newpath))
{
Directory.CreateDirectory(newpath);
}
foreach (var item in queryfile)
{
try
{
//可自行變化...
//複製檔案
if (!File.Exists(newpath + item.Name))
item.MoveTo(newpath + item.Name);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//方法2
DirectoryInfo root = new DirectoryInfo(@"\\192.168.0.1\old");
FileInfo[] files = root.GetFiles();
foreach (var item in files)
{}
參考來源
using System;
using System.ComponentModel;
using System.Runtime.InteropServices;
using System.Security.Principal;
namespace Company.Security
{
public class ImpersonateUser : IDisposable
{
[DllImport("advapi32.dll", SetLastError=true)]
private static extern bool LogonUser(string lpszUsername, string lpszDomain, string lpszPassword, int dwLogonType, int dwLogonProvider, out IntPtr phToken);
[DllImport( "kernel32", SetLastError = true )]
private static extern bool CloseHandle(IntPtr hObject);
private IntPtr userHandle = IntPtr.Zero;
private WindowsImpersonationContext impersonationContext;
public ImpersonateUser( string user, string domain, string password )
{
if ( ! string.IsNullOrEmpty( user ) )
{
// Call LogonUser to get a token for the user
bool loggedOn = LogonUser( user, domain, password,
9 /*(int)LogonType.LOGON32_LOGON_NEW_CREDENTIALS*/,
3 /*(int)LogonProvider.LOGON32_PROVIDER_WINNT50*/,
out userHandle );
if ( !loggedOn )
throw new Win32Exception( Marshal.GetLastWin32Error() );
// Begin impersonating the user
impersonationContext = WindowsIdentity.Impersonate( userHandle );
}
}
public void Dispose()
{
if ( userHandle != IntPtr.Zero )
CloseHandle( userHandle );
if ( impersonationContext != null )
impersonationContext.Undo();
}
}
}
使用方法
using ( new ImpersonateUser( "UserID", "Domain", "Password" ) )
{
// Any IO code within this block will be able to access the remote server.
}
.net Core(20240219更新) Only windows server
[DllImport("advapi32.dll", SetLastError = true, CharSet = CharSet.Unicode)]
public static extern bool LogonUser(String lpszUsername, String lpszDomain, String lpszPassword,
int dwLogonType, int dwLogonProvider, out SafeAccessTokenHandle phToken);
const int LOGON32_PROVIDER_DEFAULT = 0;
//This parameter causes LogonUser to create a primary token.
const int LOGON32_LOGON_INTERACTIVE = 2;
// Call LogonUser to obtain a handle to an access token.
SafeAccessTokenHandle safeAccessTokenHandle;
public IActionResult X()
{
try
{
bool returnValue = LogonUser("test", "mydomain", "test123", LOGON32_LOGON_INTERACTIVE, LOGON32_PROVIDER_DEFAULT, out safeAccessTokenHandle);
if (!returnValue)
throw new Exception("登入unc路徑錯誤!!");
WindowsIdentity.RunImpersonated(safeAccessTokenHandle, () =>
{
var basepath = @"\\192.168.0.1\testFiles";
if (!Directory.Exists(basepath))
{
throw new Exception("無資料夾-" + basepath);
}
DirectoryInfo root = new DirectoryInfo(basepath);
FileInfo[] files = root.GetFiles();
foreach (var item in files)
{
try
{
// item.Delete();
}
catch (Exception ex)
{
throw new Exception( ex.Message);
}
}
});
}
catch (Exception ex)
{
sb.Append($"error:{ex.Message}");
}
}
參考來源
ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true;<=加入 ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;<=加入參考來源
public static int GetBetweenBirthdayCount(DateTime pFrom, DateTime pTo, DateTime pBirthday)
{
int mBirthdayCount = 0;//會過幾次生日
int TotalYear = pTo.Year - pFrom.Year;//看區間有幾年
for (int i = 0; i <= TotalYear; i++)
{
int y = pFrom.AddYears(i).Year;
string m = pBirthday.Month.ToString().PadLeft(2, '0');
string d = pBirthday.Day.ToString().PadLeft(2, '0');
//如果他是生日229的要判斷
if (m == "02" && d == "29")
{//四除的盡就算閏年
if (y % 4 != 0)
{
d = "28";
}
}
DateTime EveryBirthday = DateTime.Parse(y + "-" + m + "-" + d);
if (pFrom <= EveryBirthday && pTo >= EveryBirthday)
{
mBirthdayCount++;
}
}
return mBirthdayCount;
}
this.KeyPreview = true;2.覆寫Form.ProcessCmdKey大致上這樣就可以了
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
switch (keyData)
{
case Keys.NumPad1:
case Keys.D1:
//按下1或鍵盤1時處理
return true;
case Keys.Enter:
//按下Enter時處理
return true;
case Keys.Escape:
//按下Esc時處理
return true;
}
return base.ProcessCmdKey(ref msg, keyData);
}
參考來源
public int id { get; set; }
public string name { get; set; }
2.將class繼承INotifyPropertyChanged
using System.ComponentModel;
public class member : INotifyPropertyChanged
3.實作INotifyPropertyChanged
public event PropertyChangedEventHandler PropertyChanged;
private void NotifyPropertyChanged(String info)
{
if (PropertyChanged != null)
{
PropertyChanged(this, new PropertyChangedEventArgs(info));
}
}
4.修改class
public int id { get; set; }
private string _name;
public string name
{
get { return this._name; }
set
{
if (value != this._name)
{
this._name = value;
NotifyPropertyChanged("Name");
}
}
}
5.新增一個list(抓假資料如果是資料庫也可直接改)
public List6.抓出資料GetMember(int pCount) { List lst = new List (); string name = "test"; for (int i = 0; i < pCount; i++) { member create = new member() { id = i, name = name + i.ToString() }; lst.Add(create); } return lst; }
member script = new member(); List7.寫另一個頁面去修改namelst = script.GetMember(10); dataGridView1.DataSource = lst;
metadata=res://*/Models.Model.csdl|res://*/Models.Model.ssdl|res://*/Models.Model.msl;provider=System.Data.SqlClient;provider connection string=&Quot;Data Source=192.168.1.1;initial catalog=test;user id=sa;password=1234;multipleactiveresultsets=True;App=EntityFramework&Quot;寫一個function
public static string getEntitiesConn()
{
string test = CodeClass.Decrypt(System.Configuration.ConfigurationManager.ConnectionStrings["testEntities"].ToString());
return test;
}
解密出來
metadata=res://*/Models.Model.csdl|res://*/Models.Model.ssdl|res://*/Models.Model.msl;provider=System.Data.SqlClient;provider connection string=&Quot;Data Source=192.168.1.1;initial catalog=test;user id=sa;password=1234;multipleactiveresultsets=True;App=EntityFramework&Quot;看起來一樣吧
testEntities db = new testEntities(Conn.getEntitiesConn());
不支援關鍵字: 'data source'。是那裡有問題阿仔細一下 &Quot;這東西不就是雙引號嗎
cmd.Parameters.AddWithValue("@abc", (object)item.abc ?? DBNull.Value);
參考網址
////// 遮罩電話 (十個字 手機市話)(九個字 市話)(十個字以上前四後三)(四個字以下回傳空白) /// /// 字串 ///string public static string MaskString(string pStr) { string mReturn = ""; if (pStr.Length == 9 && pStr.StartsWith("0")) //9碼的如高雄 { mReturn = pStr.Substring(0,2) + "-XXX-" + pStr.Substring(5,4); } else if (pStr.Length == 10 && pStr.StartsWith("09"))//手機 { mReturn = pStr.Substring(0, 4) + "-XXX-" + pStr.Substring(7, 3); } else if (pStr.Length == 10 && pStr.StartsWith("0"))//台北市話 { mReturn = pStr.Substring(0, 2) + "-XXXX-" + pStr.Substring(6, 4); } else { if (pStr.Length > 10)//十個字以上 { for (int i = 0; i < pStr.Length ; i++) { if ((i == 0 || i <= 3) || (i >= pStr.Length - 3)) //前四個字 後三個字出現 { mReturn += pStr.Substring(i, 1); } else { mReturn += "X"; } } } else if(pStr.Length >= 4)//四個字以上才會做 { for (int i = 0; i < pStr.Length; i++) { if (i >= pStr.Length - 3) //後三個字出現 { mReturn += pStr.Substring(i, 1); } else { mReturn += "X"; } } } } return mReturn; }
////// 判斷是否為數字 /// /// 傳入判斷的字串。 public static bool IsNumeric(String pNumber) { Regex NumberPattern = new Regex("[^0-9.-]"); return !NumberPattern.IsMatch(pNumber); } ////// 三位一撇 + 小數??位 /// /// 傳入字串數字。 /// 傳入字串。 public static string ToThree(string pInt,string p0) { string mReturn = string.Empty; if (pInt != "") { if (IsNumeric(pInt)) { mReturn = string.Format("{0:N"+ p0+"}", Convert.ToDecimal(pInt)); } } else { mReturn = string.Format("{0:N" + p0 + "}", "0"); } return mReturn; }
////// 回傳數字Decimal,非數字及空白都變成0 /// /// 傳入字串。 public static Decimal ToDecimal(string pInt) { Decimal mReturn = 0; if (pInt == "") { mReturn = 0; } else { if (IsNumeric(pInt)) { mReturn = Convert.ToDecimal(pInt); } else { mReturn = 0; } } return mReturn; } var QueryA =( from u in dt1.AsEnumerable() group u by new { CX_Size = u["CX_Size"], CX_Color_Name = u["CX_Color_Name"] } into g select new { CX_Size = g.Key.CX_Size, CX_Color_Name = g.Key.CX_Color_Name, CX_Quantity = g.Sum(p => Convert.ToDecimal(PublicClass.ToDecimal(p["CX_Quantity"].ToString()))), CX_Amount = g.Sum(p => Convert.ToDecimal(PublicClass.ToDecimal(p["CX_Amount"].ToString()))) }).ToList(); 最後再用迴圈來統計 foreach (var mRowA in QueryA) { //做處理 }
//取得流水號
string Sql1 = " select top 1 convert(int,substring(CX_Order_No,6,3)) as maxNo from QuoteList where substring(CX_Order_No,1,5)=@yyyMM order by convert(int,substring(CX_Order_No,6,3)) desc ";
SqlCommand cmd1 = new SqlCommand(Sql1, conn);
decimal myyy = PublicClass.ToDecimal(DateTime.Now.Year.ToString() )- 1911;
myyyyMM = myyy.ToString() + int.Parse(DateTime.Now.Month.ToString()).ToString("00");
cmd1.Parameters.AddWithValue("@yyyMM", myyyyMM);
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
myyyyMM = myyyyMM + int.Parse( ( PublicClass.ToDecimal(dt1.Rows[0]["maxNo"].ToString()) + 1).ToString()).ToString("000");//有時給他加1
}
else
{
myyyyMM = myyyyMM + "001";//沒有時就給他001
}
string test = int.Parse(DateTime.Now.Month.ToString()).ToString("00");
string test = string.Format("{0:00}", Convert.ToInt16(mNow.Month));