| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | using System.Data; |
| | | using System.Windows.Forms; |
| | | using System.Drawing; |
| | | using System.Data.SqlClient; |
| | | using System.Net.Sockets; |
| | | using System.Net; |
| | | using SyntacticSugar.constant; |
| | | |
| | | namespace Pub_Class |
| | | { |
| | |
| | | public static DateTime XFCurEDate; |
| | | public static DateTime KQCurBDate; |
| | | public static DateTime KQCurEDate; |
| | | |
| | | public static bool check; |
| | | public static int HCheckStatus; |
| | | public static string sSQLInfo; |
| | | public static string sErrInfo; |
| | | |
| | | |
| | | |
| | | public enum Enum_BillStatus : int |
| | | { |
| | |
| | | { |
| | | ClsSqlHelper oCn = new ClsSqlHelper(); |
| | | DataSet Ds = new DataSet(); |
| | | |
| | | try |
| | | { |
| | | Ds = oCn.RunProcReturn("Select GetDate() as CurDate", "xt_xtgnb"); |
| | | switch (iType) |
| | | { |
| | | case 0: |
| | | case TimeConstant.TIME_OF_THE_MONTH: |
| | | return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("yyyy-MM-dd"); |
| | | case 1: |
| | | case TimeConstant.TIME_OF_THE_HOUR: |
| | | return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("HH:mm:ss"); |
| | | case -1: |
| | | case TimeConstant.PRECISE_TIME: |
| | | return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("yyyy-MM-dd HH:mm:ss"); |
| | | default: |
| | | return "1900-01-01"; |
| | |
| | | Ds = oCn.RunProcReturn("Select GetDate() as CurDate", "xt_xtgnb"); |
| | | switch (iType) |
| | | { |
| | | case 0: |
| | | case TimeConstant.TIME_OF_THE_MONTH: |
| | | return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("yyyy-MM-dd"); |
| | | case 1: |
| | | |
| | | case TimeConstant.TIME_OF_THE_HOUR: |
| | | return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("hh:mm:ss"); |
| | | case -1: |
| | | |
| | | case TimeConstant.PRECISE_TIME: |
| | | return Convert.ToDateTime(Ds.Tables[0].Rows[0]["CurDate"]).ToString("yyyy-MM-dd HH:mm:ss"); |
| | | default: |
| | | return "1900-01-01"; |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | // 读取列宽datagridview |
| | | public static void GetGridView(DataGridView oGrd, string KeyItem, string AppPath) |