public static List <Bill> readFile(string fn, int skipRows, Str2Bill toBill)
{
List <Bill> billList = new List <Bill>();
Encoding encode = CommUtil.GetFileEncoding(fn);
using (FileStream fs = new FileStream(fn, FileMode.Open))
{
StreamReader sr = new StreamReader(fs, encode);
int irow = 0;
while (!sr.EndOfStream)
{
string sLine = sr.ReadLine();
irow++;
if (irow > skipRows)
{
Bill b = toBill(sLine);
if (b != null)
{
if (b.id == 0)
{
b.id = irow - skipRows;
}
billList.Add(b);
}
}
}
sr.Close();
}
billList.Sort();
return(billList);
}
/// <summary>
///查询训练计划分析页面展示的信息，参数为AppConfig中的当前训练计划id，当前训练课程id
/// </summary>
/// <returns></returns>
public TrainingPlanVO GetTrainingPlanVO()
{
string trainingPlanId = CommUtil.GetSettingString("trainingPlanId");
string trainingCourseId = CommUtil.GetSettingString("trainingCourseId");
return(trainingPlanDAO.GetTrainingPlanVO(trainingPlanId, trainingCourseId));
}
/// <summary>
/// fill module accessright from datarow
/// </summary>
/// <param name="dr"></param>
/// <param name="allowAccessActionList"></param>
/// <param name="accessRightDA"></param>
/// <returns></returns>
private ModuleRightModel FillModuleRightModel(DataRow dr, List <string> allowAccessActionList, AccessRightDA accessRightDA)
{
ModuleRightModel mrModel = new ModuleRightModel();
mrModel.ModuleCode = CommUtil.ConvertObjectToString(dr["code"]);
mrModel.ModuleName = CommUtil.ConvertObjectToString(dr["name"]);
DataTable dtAccessRight = accessRightDA.GetAccessRightByModuleCode(dr["code"].ToString());
Dictionary <string, bool> dicAction = new Dictionary <string, bool>();
for (int j = 0; j < dtAccessRight.Rows.Count; j++)
{
DataRow drAction = dtAccessRight.Rows[j];
if (drAction["name"] != null)
{
if (allowAccessActionList.Contains(mrModel.ModuleCode + "_" + drAction["code"].ToString()))
{
dicAction[drAction["name"].ToString()] = true;
}
else
{
dicAction[drAction["name"].ToString()] = false;
}
}
}
mrModel.DicAction = dicAction;
return(mrModel);
}
private void ExcelToPdf()
{
Dispatcher.Invoke(new Action(() =>
{
using (Workbook workbook = new Workbook())
{
workbook.LoadFromFile(CommUtil.GetDocPath("test.xlsx"));
workbook.SaveToFile(CommUtil.GetDocPath("test.pdf"), Spire.Xls.FileFormat.PDF);
//Worksheet sheet = workbook.Worksheets[0];
//sheet.SaveToPdf(@"e:\test.pdf");
//Console.WriteLine("转换执行完成了");
////获取第一张工作表
//Worksheet sheet = workbook.Worksheets[0];
////设置打印区域（设置你想要转换的单元格范围）
//sheet.PageSetup.PrintArea = "A1:K48";
////将指定范围内的单元格保存为PDF
//sheet.SaveToPdf(@"e:\test.pdf");
//文档输出
//Console.WriteLine("转换完成了");
if (SaveToPath != "" && SaveToPath != null)
{
File.Copy(CommUtil.GetDocPath("test.pdf"), SaveToPath, true);
}
}
PdfViewer.valueChange.Flag = true;
}));
}
private void Print_Click(object sender, RoutedEventArgs e)
{
try
{
PdfDocument doc = new PdfDocument();
doc.LoadFromFile(CommUtil.GetDocPath("test.pdf"));
PrintDialog dialogPrint = new PrintDialog();
dialogPrint.AllowPrintToFile = true;
dialogPrint.AllowSomePages = true;
dialogPrint.PrinterSettings.MinimumPage = 1;
dialogPrint.PrinterSettings.MaximumPage = doc.Pages.Count;
dialogPrint.PrinterSettings.FromPage = 1;
dialogPrint.PrinterSettings.ToPage = doc.Pages.Count;
if (dialogPrint.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
//设置打印的起始页码
doc.PrintFromPage = dialogPrint.PrinterSettings.FromPage;
//设置打印的终止页码
doc.PrintToPage = dialogPrint.PrinterSettings.ToPage;
//选择打印机
doc.PrinterName = dialogPrint.PrinterSettings.PrinterName;
PrintDocument printDoc = doc.PrintDocument;
dialogPrint.Document = printDoc;
printDoc.Print();
}
}
catch (Exception ex)
{
Console.WriteLine("打印异常");
}
}
/// <summary>
/// Get the module allow action by groupid
/// </summary>
/// <param name="groupID"></param>
/// <returns></returns>
private List <string> GetModuleAccessRightByGroupID(string groupID)
{
List <string> moduleARList = new List <string>();
AccessRightDA accessRightDA = null;
DataTable dt = new DataTable();
try
{
accessRightDA = new AccessRightDA();
dt = accessRightDA.GetAccessRightByGroupID(groupID);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
string allowAccessModuleAction = CommUtil.ConvertObjectToString(dr["ModuleCode"]) + "_" + CommUtil.ConvertObjectToString(dr["ActionCode"]);
moduleARList.Add(allowAccessModuleAction);
}
}
finally
{
if (accessRightDA != null)
{
accessRightDA.CloseConnection();
}
}
return(moduleARList);
}
/// <summary>
/// EditActity页活动分组Expnder中的个人设置查询 分组是前端根据活动类型分
/// </summary>
/// <returns></returns>
public List <ActivityGroupDTO> ListActivitysGroupAndPersonalSetting()
{
//当前正在进行和训练课程ID
long courseId = ParseIntegerUtil.ParseInt(CommUtil.GetSettingString("trainingCourseId"));
return(activityDAO.ListActivitysGroupAndPersonalSetting(courseId));
}
public UserM GetUser(string userID)
{
UserDA userDA = null;
DataRow dr;
var u = new UserM {
};
try
{
userDA = new UserDA();
dr = userDA.GetUsers(userID).Rows[0];
u = new UserM
{
UserID = dr["UserID"].ToString(),
UserName = dr["UserName"].ToString(),
Active = CommUtil.ConvertObjectToBool(dr["Active"]),
IsDeleted = Convert.ToByte(dr["IsDeleted"]),
};
}
finally
{
if (userDA != null)
{
userDA.CloseConnection();
}
}
return(u);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
this.Height = SystemParameters.WorkArea.Size.Height;
var hwnd = new System.Windows.Interop.WindowInteropHelper(this).Handle;
SetWindowLong(hwnd, GWL_STYLE, GetWindowLong(hwnd, GWL_STYLE) & ~WS_SYSMENU);
//获取最初姓名
origin_name = t2.Text;
//获取最初姓名
origin_name_pinyin = SelectUser.User_Namepinyin;
//获得最初的手机号
origin_phone = SelectUser.User_Phone;
//获得最初的身份证号
origin_IDCard = SelectUser.User_IDCard;
photoName = SelectUser.User_PhotoLocation;
// 加zai用戶的照片
//更新完用戶后刷新一下展示的tu片
//selectUser = (User)UsersInfo.SelectedItem;
string path = CommUtil.GetUserPic() + photoName; // huo的用戶的tu片url
if (File.Exists(path))
{
BitmapImage i = new BitmapImage(new Uri(path,
UriKind.Absolute)); //打开图片
pic.Source = i.Clone(); //将控件和图片绑定
}
else
{
BitmapImage bitmap = new BitmapImage(new Uri(@"\view\images\NoPhoto.png", UriKind.Relative));
pic.Source = bitmap;
}
}
private static void Main()
{
IsDeployClickOnce = true;
ClickOnceUpdateDN = (_IsHyweb ? "mhr.hyweb.com.tw" : "mi.baphiq.gov.tw");
Counter = 0;
Upgraded = false;
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(defaultValue: false);
if (ApplicationDeployment.CurrentDeployment.IsFirstRun)
{
CommUtil.WriteToFile("Config.ini", "\r\nMDBPath=" + ApplicationDeployment.CurrentDeployment.DataDirectory, 'A', string.Empty);
copyShortcut("家禽屠宰衛生檢查系統", "家禽屠宰衛生檢查系統.appref-ms", "家禽屠宰衛生檢查系統(V3.3.0.1版).appref-ms");
}
if (!File.Exists(Environment.GetFolderPath(Environment.SpecialFolder.ProgramFiles) + "\\Common Files\\MSSoap\\Binaries\\MSSOAP30.dll"))
{
MessageBox.Show("您尚未安裝過SOAP, 現在開始安裝。");
Process process = Process.Start("soapsdk.exe");
while (!process.HasExited)
{
Application.DoEvents();
process.WaitForExit(50);
}
}
Application.Run(new frmUpdate());
if (Upgraded)
{
Application.Restart();
}
}
private void Btn_Confirm(object sender, RoutedEventArgs e)
{//MessageBox.Show(LanguageUtils.ConvertLanguage("你确认要保存更改吗", "Are you sure you want to save your changes?"), LanguageUtils.ConvertLanguage("提示：", "Tips"), MessageBoxButton.OKCancel) == MessageBoxResult.OK
if (MessageBoxX.Question(LanguageUtils.ConvertLanguage("你确认要保存更改吗", "Are you sure you want to save your changes?")))
{
string textValue1 = textBox1.Text; //机构团体名称
string textValue2 = textBox2.Text; //照片保存文档
string textValue3 = textBox3.Text; //机构电话
//string textValue4 = textBox4.Text;//版本
string textValue5 = textBox5.Text; //备份
int comboBox1Selected = comboBox1.SelectedIndex; //机构区分被选择的index
int comboBox2Selected = comboBox2.SelectedIndex; //语言被选择的index
entity.Setter setter = new entity.Setter();
setter.Pk_Set_Id = Pk_Set_Id;
setter.Set_OrganizationName = textValue1;
setter.Set_PhotoLocation = textValue2;
setter.Set_OrganizationPhone = textValue3;
//setter.Set_Version = textValue4;
if (textValue5.Contains(" "))
{
MessageBoxX.Warning(LanguageUtils.ConvertLanguage("备份路径不能含有空格", "Backup path cannot contain spaces"));
}
else
{
setter.Back_Up = textValue5;//备份路径
setter.Set_Version = CommUtil.GetCurrentVersion();
setter.Set_Language = comboBox2Selected;
setter.Set_OrganizationSort = comboBox1Selected.ToString();
setterDao.UpdateSetter(setter);
//切换语言
LanguageUtils.SetLanguage();
GoBack(null, null);
}
}
}
private void WriteButton_Click(object sender, EventArgs e)
{
if (!m_Connected)
{
return;
}
String DeviceName = DeviceAddr.Text;
String[] values = DeviceData.Text.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
StringBuilder data = new StringBuilder();
try
{
foreach (String v in values)
{
byte c = byte.Parse(v);
data.Append((Char)(c));
}
String dataStr = data.ToString();
CommUtil.SetStringToDevice(dataStr, DeviceName, dataStr.Length, m_PLCCom);
MessageBox.Show("写入成功", "信息");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "错误");
}
}
private void ReadButton_Click(object sender, EventArgs e)
{
if (!m_Connected)
{
return;
}
String DeviceName = DeviceAddr.Text;
int DeviceSize;
if (!int.TryParse(DeviceNum.Text, out DeviceSize))
{
DeviceSize = 1;
DeviceNum.Text = DeviceSize.ToString();
}
try
{
String data = CommUtil.GetStringFromDevice(DeviceName, DeviceSize * 2, m_PLCCom);
StringBuilder msg = new StringBuilder();
foreach (Char c in data)
{
msg.Append((short)(c));
msg.Append(" ");
}
DeviceData.Text = msg.ToString();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "错误");
}
}
public List <SelectListItem> GetAllOperation()
{
List <SelectListItem> _operationList = new List <SelectListItem>();
OperationDA opDA = null;
DataTable dt = new DataTable();
try
{
opDA = new OperationDA();
dt = opDA.GetAllOperation();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
SelectListItem item = new SelectListItem();
item.Text = CommUtil.ConvertObjectToString(dr["Operation_desc"]);
item.Value = CommUtil.ConvertObjectToString(dr["Operation_code"]);
_operationList.Add(item);
}
}
finally
{
if (opDA != null)
{
opDA.CloseConnection();
}
}
return(_operationList);
}
public Int16 GetPicturePackCount(string idCard)
{
UserService userService = new UserService();
User u = userService.GetByIdCard(idCard);
string path = CommUtil.GetUserPic(u.User_PhotoLocation);
return((Int16)GetPicturePackCount(path, ProtocolConstant.PIC_PACK_SIZE));
}
public byte[] GetPictureData(string idCard, int packNum)
{
UserService userService = new UserService();
User u = userService.GetByIdCard(idCard);
string path = CommUtil.GetUserPic(u.User_PhotoLocation);
return(GetPictureData(path, packNum, ProtocolConstant.PIC_PACK_SIZE));
}
// 用户自主选择照片
private void Select_Picture_Show(object sender, RoutedEventArgs e)
{
if (t3.Text == "" || IDCard.Text == "")
{
MessageBoxX.Info(LanguageUtils.ConvertLanguage("请填写完整信息", "Please fill in the complete information"));
return;
}
using (System.Windows.Forms.OpenFileDialog ofd = new System.Windows.Forms.OpenFileDialog())
{
ofd.Title = "请选择要插入的图片";
ofd.Filter = "JPG图片|*.jpg|BMP图片|*.bmp|Gif图片|*.gif";
ofd.CheckFileExists = true;
ofd.CheckPathExists = true;
ofd.Multiselect = false;
if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
BitmapImage image = new BitmapImage(new Uri(ofd.FileName, UriKind.Absolute));//打开图片
var win2 = new PhotoCutWindow(image)
{
Owner = Window.GetWindow(this),
ShowActivated = true,
ShowInTaskbar = false,
WindowStartupLocation = WindowStartupLocation.CenterScreen
};
win2.getName = t3.Text;
win2.id = IDCard.Text;
win2.oldPhotoName = oldPhotoName;
//如果是免冠照片
double p = image.Width / image.Height;//照片比例
if (p > 0.6 && p < 0.8)
{
PicZipUtil.GetPicThumbnail(ofd.FileName, CommUtil.GetUserPic() + win2.getPhotoName());
}
else
{
win2.ShowDialog();
}
photoName = win2.photoName;
oldPhotoName = photoName;
//photograph.Close();
Console.WriteLine(photoName);
//在更新页面上展示用户 刚刚更新的照片
string photoUpdatePhoto = CommUtil.GetUserPic() + photoName;
if (File.Exists(photoUpdatePhoto))
{
//MessageBox.Show("hi open!");
BitmapImage i = new BitmapImage(new Uri(photoUpdatePhoto, UriKind.Absolute)); //打开图片
pic.Source = i.Clone(); //将控件和图片绑定
}
}
else
{
userIfSelectPic = false;
}
}
}
public ResultModel Login(LoginViewModel model)
{
ResultModel result = new ResultModel();
UserDA userDA = null;
DataTable dt = new DataTable();
try
{
userDA = new UserDA();
dt = userDA.GetUsers(model.UserID.Trim());
if (dt == null)
{
result.IsSuccess = false;
result.Exception = string.Format("User does not exist!");
return(result);
}
DataRow dr = dt.Rows[0];
if (!string.Equals(dr["password"], GetSHA512Encrypt(model.Password)))
{
result.IsSuccess = false;
result.Exception = string.Format("The Password is incorrect");
return(result);
}
if (!CommUtil.ConvertObjectToBool(dr["active"]))
{
result.IsSuccess = false;
result.Exception = string.Format("User blocked, please contact your administrator!");
return(result);
}
// TODO: Add web service logic here
UserName = dr["UserName"].ToString();
UserID = dr["UserID"].ToString();
UserUID = dr["UID"].ToString();
//Operation = "EEGHK";//在未完成Operation模块时作为测试数据
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Exception = ex.Message;
}
finally
{
if (userDA != null)
{
userDA.CloseConnection();
}
}
return(result);
}
public IEnumerable <MenuModel> GetMenu()
{
List <string> moduleList = new List <string>();
List <MenuModel> menuList = new List <MenuModel>();
ModuleDA moduleDA = null;
DataTable dt = new DataTable();
try
{
moduleDA = new ModuleDA();
dt = moduleDA.GetMenuByUserID(UserUID, Operation);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
if ("".Equals(CommUtil.ConvertObjectToString(dr["ModuleCode"])) || moduleList.Contains(CommUtil.ConvertObjectToString(dr["ModuleCode"])))
{
continue;
}
else
{
moduleList.Add(CommUtil.ConvertObjectToString(dr["ModuleCode"]));
}
MenuModel mm = new MenuModel();
mm.ModuleCode = CommUtil.ConvertObjectToString(dr["ModuleCode"]);
mm.ModuleName = CommUtil.ConvertObjectToString(dr["ModuleName"]);
mm.ModuleController = CommUtil.ConvertObjectToString(dr["ModuleController"]);
mm.ModuleAction = CommUtil.ConvertObjectToString(dr["ModuleAction"]);
mm.IsFatherNode = CommUtil.ConvertObjectToBool(dr["IsFatherNode"]);
bool isSelect = false;
if (mm.IsFatherNode)
{
mm.SubMenu = GetSubMenu(mm.ModuleCode, 1, out isSelect);
}
else
{
isSelect = CheckMenuSelected(mm.ModuleController, mm.ModuleAction);
}
mm.IsSelect = isSelect;
menuList.Add(mm);
}
}
finally
{
if (moduleDA != null)
{
moduleDA.CloseConnection();
}
}
return(menuList);
}
//查询按钮，刷新加载图表
private void Button_Click(object sender, RoutedEventArgs e)
{
//选择的次数
int num = CommUtil.ParseInt(comboxNum.Text);
int deviceId = CommUtil.ParseInt(comboxDevice.SelectedValue.ToString());
RefreshChart(userId, deviceId, num);
}
//按钮：更新
private void UserUpdata(object sender, RoutedEventArgs e)
{
// 切换用户图片的显示，解决线程占用问题
BitmapImage bitmap = new BitmapImage(new Uri(@"\view\images\NoPhoto.png", UriKind.Relative));
UserPhoto.Source = bitmap;
//检查是否选中
if ((User)UsersInfo.SelectedItem == null)
//if (selectUser == null)//4.7 lzh
{
MessageBoxX.Warning(LanguageUtils.ConvertLanguage("请选择用户再进行操作！", "Please Select A Subject!"));
// MessageBox.Show(LanguageUtils.ConvertLanguage("请选择用户再进行操作！", "Please Select A Subject!"));
return;
}
UserUpdata userUpdata = new UserUpdata
{
Owner = Window.GetWindow(this),
ShowActivated = true,
ShowInTaskbar = false,
WindowStartupLocation = WindowStartupLocation.CenterScreen
};
//类中使用
User user = (User)UsersInfo.SelectedItem;
userUpdata.SelectUser = user;
//UI中使用
userUpdata.selectUser.DataContext = user;
//Console.WriteLine("123123: " + user.User_Privateinfo);
userUpdata.noPublicInfoText.Text = user.User_Privateinfo;
//Console.WriteLine("123123aaaaa: " + userUpdata.noPublicInfoText.Text);
userUpdata.ShowDialog();
//关闭后刷新界面
users = userService.GetAllUsers();
UsersInfo.ItemsSource = users;
// 加载用户头像
string photoUrl = CommUtil.GetUserPic() + selectUser.User_PhotoLocation;
if (selectUser.User_PhotoLocation != null)
{
try
{
BitmapImage b = new BitmapImage(new Uri(photoUrl, UriKind.Absolute)); //打开图片
UserPhoto.Source = b.Clone(); //将控件和图片绑定
}
catch (Exception ee)
{
}
}
//更新之后，刷新左下角
Refresh_RecordFrame_Action();
}
/// <summary>
/// 批量插入训练活动
/// </summary>
/// <param name="activities"></param>
/// <returns></returns>
public long BatchSaveActivity(List <ActivityEntity> activities)
{
using (TransactionScope ts = new TransactionScope())
{
UploadManagementDAO uploadManagementDao2 = new UploadManagementDAO();
long result = 0;
//判断登陆用户，是教练自己锻炼。还是教练为用户进行设置。决定传哪个参数
string currentMemberPK = CommUtil.GetSettingString("memberPrimarykey");
string currentCoachId = CommUtil.GetSettingString("coachId");
if ((currentMemberPK == null || currentMemberPK == "") && (currentCoachId != null && currentCoachId != ""))
{
//无用户登陆。教练单独登陆时对教练进行设置
foreach (var activity in activities)
{
activity.Id = KeyGenerator.GetNextKeyValueLong("bdl_activity");
activity.Member_id = CommUtil.GetSettingString("memberId");
activity.Fk_member_id = ParseIntegerUtil.ParseInt(CommUtil.GetSettingString("coachId"));
activity.Fk_training_course_id = ParseIntegerUtil.ParseInt(CommUtil.GetSettingString("trainingCourseId"));
activity.Gmt_create = System.DateTime.Now;
activity.Is_complete = false;
activity.current_turn_number = 0;
//插入至上传表
uploadManagementDao2.Insert(new UploadManagement(activity.Id, "bdl_activity", 0));
}
//批量插入训练活动
result = activityDAO.BatchInsert(activities);
//根据训练活动批量插入个人设置记录 传入教练的主键id
personalSettingService.SavePersonalSettings(ParseIntegerUtil.ParseInt(CommUtil.GetSettingString("coachId")));
}
else
{
//只要用户登录，为用户进行设置
foreach (var activity in activities)
{
activity.Id = KeyGenerator.GetNextKeyValueLong("bdl_activity");
activity.Member_id = CommUtil.GetSettingString("memberId");
activity.Fk_member_id = ParseIntegerUtil.ParseInt(CommUtil.GetSettingString("memberPrimarykey"));
activity.Fk_training_course_id = ParseIntegerUtil.ParseInt(CommUtil.GetSettingString("trainingCourseId"));
activity.Gmt_create = System.DateTime.Now;
activity.Is_complete = false;
activity.current_turn_number = 0;
//插入至上传表
uploadManagementDao2.Insert(new UploadManagement(activity.Id, "bdl_activity", 0));
}
//批量插入训练活动
result = activityDAO.BatchInsert(activities);
//根据训练活动批量插入个人设置记录 传入会员的主键id
personalSettingService.SavePersonalSettings(ParseIntegerUtil.ParseInt(CommUtil.GetSettingString("memberPrimarykey")));
}
ts.Complete();
return(result);
}
}
/// <summary>
/// 箭筒截图是否成功
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ImageDealer_OnOnCutImaging(object sender, RoutedEventArgs e)
{
var ddd = (BitmapSource)e.OriginalSource;
Bitmap bit = BitmapFromSource(ddd);
//指定照片尺寸这么大
var bmcpy = new Bitmap(183, 256);
Graphics gh = Graphics.FromImage(bmcpy);
gh.DrawImage(bit, new System.Drawing.Rectangle(0, 0, 183, 256));
bmcpy.Save(CommUtil.GetUserPic() + photoName, System.Drawing.Imaging.ImageFormat.Jpeg);
}
/// <summary>
/// Get all goup info
/// </summary>
/// <param name="groupID"></param>
/// <param name="selectedGroupID"></param>
/// <param name="selectedGroupName"></param>
/// <returns></returns>
private List <GroupM> GetAllGroup(string groupID, out string selectedGroupID, out string selectedGroupName)
{
selectedGroupID = "";
selectedGroupName = "";
bool getGroupFisrstElement = false;
if (groupID == null)
{
getGroupFisrstElement = true;
}
List <GroupM> groupList = new List <GroupM>();
GroupDA groupDA = null;
DataTable dt = new DataTable();
try
{
groupDA = new GroupDA();
dt = groupDA.GetAllGroup(Operation);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
GroupM group = new GroupM();
group.GroupID = CommUtil.ConvertObjectToString(dr["GroupID"]);
group.GroupName = CommUtil.ConvertObjectToString(dr["GroupName"]);
groupList.Add(group);
if (i == 0 && getGroupFisrstElement)
{
selectedGroupID = group.GroupID;
selectedGroupName = group.GroupName;
}
if (group.GroupID.Equals(groupID))
{
selectedGroupID = group.GroupID;
selectedGroupName = group.GroupName;
}
}
}
finally
{
if (groupDA != null)
{
groupDA.CloseConnection();
}
}
return(groupList);
}
/// <summary>
/// 备份
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BackUp(object sender, RoutedEventArgs e)
{
try
{
string DbUserName = ConfigUtil.GetEncrypt("DbUserName", "");
string DbPassword = ConfigUtil.GetEncrypt("DbPassword", "");
string DbUrl = ConfigUtil.GetEncrypt("DbUrl", "");
//指令
string strAddress = string.Format("mysqldump -h{0} -u{1} -p{2} --default-character-set=utf8 --lock-tables --routines --force --quick ", DbUrl, DbUserName, DbPassword);
//string strAddress = string.Format("mysqldump -h{0} -u{1} -p{2} --default-character-set=utf8 --lock-tables --routines --force --quick ", "127.0.0.1", "root", "53231323xjh");
//数据库名称
//string strDB = "bdl1";
string strDB = ConfigUtil.GetEncrypt("DbName", "");
//mysql的路径
string mysqlPath = new SetterService().getPath() + @"\bin";
//备份的路径(获取前端页面)
//string filePath = System.AppDomain.CurrentDomain.BaseDirectory + @"\BackUp\";
string filePath = textBox5.Text;
if (!Directory.Exists(filePath)) //如果不存在就创建file文件夹
{
Directory.CreateDirectory(filePath); //创建该文件夹
}
//判断是否含空格
if (filePath.IndexOf(" ") != -1)
{
Console.WriteLine("保存路径中含空格");
MessageBoxX.Warning(LanguageUtils.ConvertLanguage("备份路径不能含有空格", "Backup path cannot contain spaces"));
return;
}
//执行的指令
string cmd = strAddress + strDB + " > " + filePath + "bdl.sql";
string result = CommUtil.RunCmd(mysqlPath, cmd);
//MessageBox.Show(result);
//图片备份
CommUtil.CopyDirectory(filePath);
if (("mysqldump: [Warning] Using a password on the command line interface can be insecure.".Trim()).Contains(result.Trim()) ||
("Warning: Using a password on the command line interface can be insecure.".Trim()).Contains(result.Trim()))
{
MessageBoxX.Info(LanguageUtils.ConvertLanguage("数据备份成功", "Successful data backup"));
}
else
{
MessageBoxX.Error(LanguageUtils.ConvertLanguage("数据备份失败", " Data backup failed"));
}
}
catch (Exception ex)
{
Console.WriteLine("执行sql异常，备份异常" + ex.ToString());
}
}
/// <summary>
/// 测试激活
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Click_16(object sender, RoutedEventArgs e)
{
SetterDAO setterDAO = new SetterDAO();
//获取mac地址
StringBuilder stringBuilder = new StringBuilder();
//string strMac = CommUtil.GetMacAddress();
// List<string> Macs = CommUtil.GetMacByWMI();
List <string> Macs = CommUtil.GetMacByIPConfig();
foreach (string mac in Macs)
{
string prefix = "物理地址. . . . . . . . . . . . . : ";
string Mac = mac.Substring(prefix.Length - 1);
stringBuilder.Append(Mac);
}
//Console.WriteLine("==================="+stringBuilder.ToString());
//MessageBox.Show("===================" + stringBuilder.ToString());
entity.Setter setter = new entity.Setter();
//mac地址先变为byte[]再aes加密
byte[] byteMac = Encoding.GetEncoding("GBK").GetBytes(stringBuilder.ToString());
byte[] AesMac = AesUtil.Encrypt(byteMac, ProtocolConstant.USB_DOG_PASSWORD);
//存入数据库
//setter.Set_Unique_Id = Encoding.GetEncoding("GBK").GetString(AesMac);
setter.Set_Unique_Id = ProtocolUtil.BytesToString(AesMac);
/*AES解密
* byte[] a = ProtocolUtil.StringToBcd(setter.Set_Unique_Id);
* byte[] b = AesUtil.Decrypt(a, ProtocolConstant.USB_DOG_PASSWORD);
* Console.WriteLine(Encoding.GetEncoding("GBK").GetString(b));*/
//默认照片路径，激活时获取(路径中不要有汉字)
string basePath = System.AppDomain.CurrentDomain.BaseDirectory;
string path = ConfigurationManager.AppSettings["PicPath"];
setter.Set_PhotoLocation = basePath + path;
setter.Set_Language = 1;
setter.Pk_Set_Id = 1;
//设置版本号
setter.Set_Version = CommUtil.GetCurrentVersion();
if (!Directory.Exists(@setter.Set_PhotoLocation))
{
Directory.CreateDirectory(@setter.Set_PhotoLocation);//不存在就创建目录
}
/*if (Directory.Exists(@setter.Set_PhotoLocation)) { //存在就删除
* Directory.Delete(@setter.Set_PhotoLocation, true);
* Directory.CreateDirectory(@setter.Set_PhotoLocation);
* }*/
setterDAO.InsertOneMacAdress(setter);
}
//private void dgData_LoadingRow(object sender, DataGridRowEventArgs e)
//{
// e.Row.Header = e.Row.GetIndex() + 1;
//}
/// <summary>
/// 选中使用者信息时触发，将详细信息展示在左下角
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Grid_Click(object sender, MouseButtonEventArgs e)
{
ifSelecUser = true;
if (UsersInfo.SelectedIndex == -1)
{
id.Content = null;
}
else
{
id.Content = UsersInfo.SelectedIndex + 1;//使用者详细信息展示框id设置
}
selectUser = (User)UsersInfo.SelectedItem;
//UserInfo
UserInfo.DataContext = selectUser;
string path = null;
// 选中用户的时候初始化
is_signinformationrecord.Focus();
//选中用户时展示 症状 训练 体力的记录框的frame
//Radio_Check_Action();
// 给frame加入数据
Refresh_RecordFrame_Action();
if (selectUser != null && selectUser.User_IDCard != null && selectUser.User_Namepinyin != null && selectUser.User_IDCard != "" && selectUser.User_Namepinyin != "")
{
path = CommUtil.GetUserPic();
path += selectUser.User_PhotoLocation;
}
else
{
return;
}
//看照片是否存在
if (!File.Exists(path))
{
BitmapImage bitmap = new BitmapImage(new Uri(@"\view\images\NoPhoto.png", UriKind.Relative));
UserPhoto.Source = bitmap;
return;
}
else
{
UserPhoto.Source = new BitmapImage(new Uri(path)).Clone();
}
}
/// <summary>
/// 作用：经过初步测试，第一次Excel转pdf相对较慢，所以在进入程序的时候，执行一次Excel转PDF
/// </summary>
public void InitializationExcelToPdf()
{
try
{
using (Workbook workbook = new Workbook())
{
workbook.LoadFromFile(CommUtil.GetDocPath("test1.xlsx"));
workbook.SaveToFile(CommUtil.GetDocPath("test1.pdf"), Spire.Xls.FileFormat.PDF);
}
}
catch (Exception e)
{
initializationExcelToPdfThread.Abort();
}
}
public byte[] GetPictureData(string idCard)
{
UserService userService = new UserService();
User u = userService.GetByIdCard(idCard);
string path = CommUtil.GetUserPic(u.User_PhotoLocation);
using (FileStream fs = new FileStream(path, FileMode.Open))
{
byte[] byteData = new byte[fs.Length];
fs.Read(byteData, 0, byteData.Length);
return(byteData);
}
}
/// <summary>
/// 点击裁剪按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Click(object sender, RoutedEventArgs e)
{
//创建文件夹
CreateDir(CommUtil.GetUserPic());
ImageDealer.CutImage();
/*
* string newFileName = photoName.Replace(".jpg", ".gif");
*
* if (PicZipUtil.GetPicThumbnail(CommUtil.GetUserPic() + photoName, CommUtil.GetUserPic() + newFileName, 50))
* {
*
* photoName = newFileName;
* }*/
this.Close();
}
