public static void 管理員更新(CAdmin admin) { string sql = $"EXEC 管理員更新 "; sql += $"@{CAdminKey.fAdminId},"; sql += $"@{CAdminKey.fAdminAccount},"; sql += $"@{CAdminKey.fAdminPassword},"; sql += $"@{CAdminKey.fName},"; sql += $"@{CAdminKey.fGender},"; sql += $"@{CAdminKey.fBirthDay},"; sql += $"@{CAdminKey.fTheAddress},"; sql += $"@{CAdminKey.fMobilePhone},"; sql += $"@{CAdminKey.fThePhoto},"; sql += $"@{CAdminKey.fHireDateTime},"; sql += $"@{CAdminKey.fLastLoginDateTime}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CAdminKey.fAdminId, admin.fAdminId), new SqlParameter(CAdminKey.fAdminAccount, admin.fAdminAccount), new SqlParameter(CAdminKey.fAdminPassword, admin.fAdminPassword), new SqlParameter(CAdminKey.fName, admin.fName), new SqlParameter(CAdminKey.fGender, admin.fGender), new SqlParameter(CAdminKey.fBirthDay, admin.fBirthDay), new SqlParameter(CAdminKey.fTheAddress, (object)admin.fTheAddress ?? DBNull.Value), //可NULL new SqlParameter(CAdminKey.fMobilePhone, admin.fMobilePhone), new SqlParameter(CAdminKey.fThePhoto, (object)admin.fThePhoto ?? DBNull.Value), //可NULL new SqlParameter(CAdminKey.fHireDateTime, admin.fHireDateTime), new SqlParameter(CAdminKey.fLastLoginDateTime, admin.fLastLoginDateTime) }; CDbManager.executeSql(sql, paras); }
public static CAdmin fn管理員登入驗證(string act, string pwd) { //檢查帳號密碼是否正確 CAdmin admin = fn管理員查詢().FirstOrDefault(m => act == m.fAdminAccount && pwd == m.fAdminPassword); if (admin != null) { Console.WriteLine("登入成功!"); Console.WriteLine("客戶ID:" + admin.fAdminId); Console.WriteLine("客戶姓名:" + admin.fName); Console.WriteLine("帳號:" + admin.fAdminAccount); Console.WriteLine("-----------------------------------------------------------"); } else { Console.WriteLine("帳號或密碼錯誤!"); } return(admin); }