private void SetControlPositionInReport(Report.ReportQZ report, int groupID) { report.xrLabelMemo.Location = GetLabelPoint("Memo", groupID); report.xrLabelPDate.Location = GetLabelPoint("PDate", groupID); report.xrLabelDDate.Location = GetLabelPoint("DDate", groupID); report.xrLabelUserName.Location = GetLabelPoint("UserName", groupID); report.xrLabelNamNimh.Location = GetLabelPoint("NamNimh", groupID); report.xrLabelPID.Location = GetLabelPoint("PID", groupID); report.xrLabelMDate.Location = GetLabelPoint("MDate", groupID); report.xrLabelType.Location = GetLabelPoint("Type", groupID); report.xrLabelTimes.Location = GetLabelPoint("Times", groupID); report.xrLabelDuty.Location = GetLabelPoint("Duty", groupID); report.xrLabelVID.Location = GetLabelPoint("VID", groupID); report.xrLabelBirthday.Visible = true; report.xrLabelBirthday.Location = GetLabelPoint("BDate", groupID); if (report.xrLabelBirthday.Location.X == 0 && report.xrLabelBirthday.Location.Y == 0) { report.xrLabelBirthday.Visible = false; } report.xrCustomerName.Visible = true; report.xrCustomerName.Location = GetLabelPoint("CustomerName", groupID); if (report.xrCustomerName.Location.X == 0 && report.xrCustomerName.Location.Y == 0) { report.xrCustomerName.Visible = false; } report.xrCountry.Visible = true; report.xrCountry.Location = GetLabelPoint("Country", groupID); if (report.xrCountry.Location.X == 0 && report.xrCountry.Location.Y == 0) { report.xrCountry.Visible = false; } visaEntities DataContextP = new visaEntities(); TB_Position pageSize = DataContextP.TB_Position.FirstOrDefault(p => p.FName == "PageSize" && p.FGroupID == groupID); if (pageSize != null) { report.PageWidth = Convert.ToInt32(pageSize.FX); report.PageHeight = Convert.ToInt32(pageSize.FY); } else { report.PageWidth = 3000; report.PageHeight = 2100; } if (groupID == 1) { report.Font = new System.Drawing.Font("Times New Roman", 10); } else { report.Font = new System.Drawing.Font("Times New Roman", 12); } }
private static string GetVisaNumberString(string FirstLetter, int NumberLenght, ref int i) { string finalQZID = FirstLetter + ("0000000" + i.ToString()).Substring(NumberLenght); visaEntities visaORM = new visaEntities(); var isUsedObj = visaORM.QZKC.FirstOrDefault(q => q.FIsUse == true && q.FQZID == finalQZID); if (isUsedObj != null) { i++; return(GetVisaNumberString(FirstLetter, NumberLenght, ref i)); } return(finalQZID); }
System.Drawing.Point GetLabelPoint(string LabelName, int GroupID) { int X; int Y; visaEntities visaORM = new visaEntities(); TB_Position pModel = visaORM.TB_Position.OrderByDescending(p => p.FCreateDate).FirstOrDefault(p => p.FName == LabelName && p.FGroupID == GroupID); if (pModel == null) { MessageBox.Show(LabelName + "未设置位置数值"); return(new System.Drawing.Point(0, 0)); } else { X = (int)pModel.FX; Y = (int)pModel.FY; return(new System.Drawing.Point(X, Y)); } }
private void btnRestore_Click(object sender, RoutedEventArgs e) { if (String.IsNullOrEmpty(txtRestorePath.Text)) { System.Windows.MessageBox.Show("请选择还原路径"); return; } try { using (var visaORM = new visaEntities()) { string sql = @"use master RESTORE DATABASE [QZ] FROM DISK = N'" + txtRestorePath.Text + "' WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY , REPLACE "; int rowCount = visaORM.ExecuteStoreCommand(sql); } System.Windows.Forms.MessageBox.Show("数据还原成功"); } catch (Exception err) { Log.WriteLog.WriteErorrLog(err); System.Windows.Forms.MessageBox.Show(err.Message); } }
private void btnBackup_Click(object sender, RoutedEventArgs e) { if (String.IsNullOrEmpty(txtBackupPath.Text)) { System.Windows.MessageBox.Show("请选择备份路径"); return; } try { using (var visaORM = new visaEntities()) { string sql = @"BACKUP DATABASE [visa] TO DISK = N'" + txtBackupPath.Text + "' WITH NOINIT , NOUNLOAD , NAME = N'Visa Back', NOSKIP , STATS = 10, NOFORMAT "; int rowCount = visaORM.ExecuteStoreCommand(sql); } System.Windows.Forms.MessageBox.Show("备份成功"); } catch (Exception err) { Log.WriteLog.WriteErorrLog(err); System.Windows.Forms.MessageBox.Show(err.Message); } }