cyf
317 lines
9.9 KiB
C#
317 lines
9.9 KiB
C#
using System.IO;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Drawing;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Windows.Forms;
|
|
using Microsoft.Win32;
|
|
using System.Management;
|
|
using System.Net;
|
|
using System.Globalization;
|
|
using System.Data.SqlClient;
|
|
using CommonLib;
|
|
using DevExpress.XtraPrinting;
|
|
using DevExpress.XtraPrinting.Preview;
|
|
using DevExpress.Utils;
|
|
using DevExpress.XtraEditors;
|
|
using DevExpress.XtraGrid;
|
|
using DevExpress.XtraGrid.Columns;
|
|
using DevExpress.XtraGrid.Views.Base;
|
|
using DevExpress.XtraGrid.Views.Grid;
|
|
using DevExpress.XtraGrid.Views.Grid.ViewInfo;
|
|
|
|
|
|
|
|
namespace Ls
|
|
{
|
|
public class sysstr
|
|
{
|
|
public static string str1;
|
|
public static string str2;
|
|
public static string showid;
|
|
public static string str3;
|
|
public static string str4;
|
|
public static string str5;
|
|
public static string str6;
|
|
public static string str7;
|
|
public static string str8;
|
|
}
|
|
public class dx
|
|
{
|
|
|
|
public static int SaveXls(DevExpress.XtraGrid.GridControl GridControlPub)
|
|
{
|
|
SaveFileDialog saveFileDialog = new SaveFileDialog();
|
|
saveFileDialog.Title = "导出Excel";
|
|
saveFileDialog.Filter = "Excel文件(*.xls)|*.xls|Excel2007|*.xlsx|PDF文件|*.PDF|RTF文件|*.RTF|HTML文件|*.html";
|
|
DialogResult dialogResult = saveFileDialog.ShowDialog();
|
|
if (dialogResult == DialogResult.OK)
|
|
{
|
|
DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
|
|
if (saveFileDialog.FilterIndex == 1)
|
|
{
|
|
GridControlPub.ExportToXls(saveFileDialog.FileName);
|
|
}
|
|
if (saveFileDialog.FilterIndex == 2)
|
|
{
|
|
GridControlPub.ExportToXlsx(saveFileDialog.FileName);
|
|
}
|
|
if (saveFileDialog.FilterIndex == 3)
|
|
{
|
|
GridControlPub.ExportToPdf(saveFileDialog.FileName);
|
|
}
|
|
if (saveFileDialog.FilterIndex == 4)
|
|
{
|
|
GridControlPub.ExportToRtf(saveFileDialog.FileName);
|
|
}
|
|
if (saveFileDialog.FilterIndex == 5)
|
|
{
|
|
GridControlPub.ExportToHtml(saveFileDialog.FileName);
|
|
}
|
|
DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|
}
|
|
return 1;
|
|
}
|
|
public static int Preview(DevExpress.XtraGrid.GridControl GridControlPub, string prnTitle)
|
|
{
|
|
PrintingSystem ps = null;
|
|
DevExpress.XtraPrinting.PrintableComponentLink link = null;
|
|
ps = new DevExpress.XtraPrinting.PrintingSystem();
|
|
link = new DevExpress.XtraPrinting.PrintableComponentLink(ps);
|
|
ps.Links.Add(link);
|
|
link.Component = GridControlPub;//这里可以是可打印的部件
|
|
string _PrintHeader = prnTitle;
|
|
PageHeaderFooter phf = link.PageHeaderFooter as PageHeaderFooter;
|
|
phf.Header.Content.Clear();
|
|
phf.Header.Content.AddRange(new string[] { "", _PrintHeader, "" });
|
|
phf.Header.Font = new System.Drawing.Font("宋体", 14, System.Drawing.FontStyle.Bold); phf.Header.LineAlignment = BrickAlignment.Center;
|
|
link.CreateDocument(); //建立文档
|
|
ps.PreviewFormEx.Show();
|
|
return 1;
|
|
}
|
|
public static int CopyTitle(DevExpress.XtraGrid.Views.Grid.GridView gridView1)
|
|
{
|
|
StringBuilder stringBuilder = new StringBuilder();
|
|
StringBuilder stringBuilder2 = new StringBuilder();
|
|
foreach (GridColumn gridColumn in gridView1.Columns)
|
|
{
|
|
if (gridColumn.Visible)
|
|
{
|
|
stringBuilder.AppendFormat("{0} ", gridColumn.Caption);
|
|
}
|
|
}
|
|
int[] selectedRows = gridView1.GetSelectedRows();
|
|
int[] array = selectedRows;
|
|
for (int i = 0; i < array.Length; i++)
|
|
{
|
|
int rowHandle = array[i];
|
|
foreach (GridColumn gridColumn in gridView1.Columns)
|
|
{
|
|
if (gridColumn.Visible)
|
|
{
|
|
stringBuilder2.AppendFormat("{0} ", gridView1.GetRowCellDisplayText(rowHandle, gridColumn.FieldName));
|
|
}
|
|
}
|
|
stringBuilder2.AppendLine();
|
|
}
|
|
Clipboard.SetText(stringBuilder.ToString() + "\r\n" + stringBuilder2.ToString());
|
|
return 1;
|
|
}
|
|
|
|
public static string SetRowNb(object sender, RowIndicatorCustomDrawEventArgs e)
|
|
{
|
|
e.Appearance.TextOptions.HAlignment = HorzAlignment.Far;
|
|
if (e.Info.IsRowIndicator)
|
|
{
|
|
if (e.RowHandle >= 0)
|
|
{
|
|
e.Info.DisplayText = (e.RowHandle + 1).ToString();
|
|
}
|
|
}
|
|
return "";
|
|
}
|
|
|
|
|
|
|
|
|
|
public static string SelectRow(DevExpress.XtraGrid.Views.Grid.GridView GridViewpub)
|
|
{
|
|
GridViewpub.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
|
|
GridViewpub.OptionsBehavior.Editable = false;
|
|
GridViewpub.OptionsSelection.EnableAppearanceFocusedCell = false;
|
|
return "";
|
|
}
|
|
|
|
public static string Group(DevExpress.XtraGrid.Views.Grid.GridView GridViewpub)
|
|
{
|
|
if (GridViewpub.OptionsView.ShowGroupPanel == true)
|
|
{
|
|
GridViewpub.OptionsView.ShowGroupPanel = false;
|
|
}
|
|
else
|
|
{
|
|
GridViewpub.OptionsView.ShowGroupPanel = true;
|
|
}
|
|
return "";
|
|
}
|
|
public static string find(DevExpress.XtraGrid.Views.Grid.GridView GridViewpub)
|
|
{
|
|
if (GridViewpub.OptionsFind.AlwaysVisible == true)
|
|
{
|
|
GridViewpub.OptionsFind.AlwaysVisible = false;
|
|
}
|
|
else
|
|
{
|
|
GridViewpub.OptionsFind.AlwaysVisible = true;
|
|
}
|
|
return "";
|
|
}
|
|
}
|
|
public class Ado
|
|
{
|
|
public static string message()
|
|
{
|
|
return Ls.Net.GetLocalHost();
|
|
}
|
|
}
|
|
|
|
|
|
public class contentsAdo
|
|
{
|
|
public static string message()
|
|
{
|
|
return Ls.Reg.GetRegistData("ServerName");
|
|
}
|
|
}
|
|
//注册表访问
|
|
public class Reg
|
|
{
|
|
public static string GetRegistData(string name)
|
|
{
|
|
string registData;
|
|
RegistryKey hkml = Registry.CurrentUser;
|
|
RegistryKey software = hkml.OpenSubKey("AA_LS_Erp V2.0", true);
|
|
if (software == null)
|
|
{
|
|
return "";
|
|
}
|
|
RegistryKey aimdir = software.OpenSubKey("File", true);
|
|
if (aimdir == null)
|
|
{
|
|
return "";
|
|
}
|
|
registData = aimdir.GetValue(name).ToString();
|
|
if (registData == null)
|
|
{
|
|
return "";
|
|
}
|
|
return registData;
|
|
}
|
|
|
|
public static void WTRegedit(string name, string tovalue)
|
|
{
|
|
RegistryKey hkml = Registry.CurrentUser;
|
|
RegistryKey software = hkml.CreateSubKey("AA_LS_Erp V2.0");
|
|
RegistryKey aimdir = software.CreateSubKey("File");
|
|
aimdir.SetValue(name, tovalue);
|
|
}
|
|
|
|
|
|
|
|
public static void SetValue(string keyName, string valueName, object value)
|
|
{
|
|
Registry.SetValue(keyName, valueName, value, RegistryValueKind.String);
|
|
}
|
|
|
|
public static object GetValue(string keyName, string valueName, object defaultValue)
|
|
{
|
|
object obj1 = Registry.GetValue(keyName, valueName, defaultValue);
|
|
if (obj1 == null)
|
|
{
|
|
return defaultValue;
|
|
}
|
|
else
|
|
{
|
|
return obj1;
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
|
|
public class Net
|
|
{
|
|
|
|
public static string GetLocalHost()
|
|
{
|
|
return Dns.GetHostName();
|
|
}
|
|
//获取本地IP地址
|
|
public static IPAddress[] GetLocalIP()
|
|
{
|
|
string name = Dns.GetHostName();
|
|
IPHostEntry me = Dns.GetHostEntry(name);
|
|
return me.AddressList;
|
|
}
|
|
}
|
|
|
|
|
|
public class IO
|
|
{
|
|
|
|
//建目录
|
|
public static bool CreatePath(string strPath)
|
|
{
|
|
try
|
|
{
|
|
if (strPath.Length == 0)
|
|
{ return false; }
|
|
|
|
if (Directory.Exists(strPath))
|
|
{ return true; }
|
|
|
|
Directory.CreateDirectory(Path.GetDirectoryName(strPath));
|
|
return true;
|
|
}
|
|
catch
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
//写文本日志 try catch (Exception ex)
|
|
|
|
public static void WriteLog(string strFile, string strLog)
|
|
{
|
|
try
|
|
{
|
|
if (File.Exists(strFile))
|
|
{
|
|
using (StreamWriter sw1 = File.AppendText(strFile))
|
|
{
|
|
//", DateTime.Now.ToString("yyMMdd-HHmmss")
|
|
sw1.WriteLine("[" + System.DateTime.Now.ToString("yyMMdd-HHmmss") + "]" + strLog);
|
|
sw1.Close();
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (IO.CreatePath(strFile))
|
|
{
|
|
using (StreamWriter sw2 = File.CreateText(strFile))
|
|
{
|
|
sw2.WriteLine("[" + System.DateTime.Now.ToString("yyMMdd-HHmmss") + "]" + strLog);
|
|
sw2.Close();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch
|
|
{ }
|
|
}
|
|
}
|
|
}
|
|
|