using System;
|
using System.Data;
|
using System.Data.OleDb;
|
using System.IO;
|
using System.Runtime.Serialization.Json;
|
using System.Text;
|
using System.Text.RegularExpressions;
|
|
namespace GTech.Solution.Api.Common
|
{
|
public static class ConvertUtil
|
{
|
#region Basic
|
public static string errMsg = "";
|
public static int toInt(string str, int def)
|
{
|
return ConvertUtil.toInt(str, def, 0);
|
}
|
|
public static int toInt(object obj, int def, int t)
|
{
|
int ret = def;
|
try
|
{
|
ret = Convert.ToInt32(obj);
|
}
|
catch (Exception)
|
{
|
ret = def;
|
}
|
return ret;
|
}
|
|
public static string NVL(object obj)
|
{
|
string ret = "";
|
try
|
{
|
ret = Convert.ToString(obj);
|
}
|
catch (Exception)
|
{
|
ret = "";
|
}
|
return ret;
|
}
|
|
public static DateTime toDatetime(object obj, int fix)
|
{
|
DateTime dt = DateTime.Now.AddYears(fix);
|
try
|
{
|
dt = Convert.ToDateTime(obj);
|
if (dt.Year == 1)
|
dt = dt.AddYears(2000);
|
}
|
catch (Exception)
|
{
|
|
}
|
finally
|
{
|
if (dt == null)
|
dt = DateTime.Now.AddYears(fix);
|
}
|
return dt;
|
}
|
|
public static string IFEmptyToDefault(this string s, string _default)
|
{
|
string v = s;
|
if (string.IsNullOrEmpty(v))
|
{
|
v = _default;
|
}
|
return v;
|
}
|
|
public static bool TryToBool(this string s, bool _default)
|
{
|
bool v = _default;
|
if (s == null || !bool.TryParse(s, out v))
|
{
|
v = _default;
|
}
|
return v;
|
}
|
|
public static int TryToInt(this string s, int _default)
|
{
|
int v = _default;
|
if (s == null || !int.TryParse(s, out v))
|
{
|
v = _default;
|
}
|
return v;
|
}
|
|
public static long TryToLong(this object s, long _default)
|
{
|
long v = _default;
|
if (s == null || !long.TryParse(s + "", out v))
|
{
|
v = _default;
|
}
|
return v;
|
}
|
|
public static T JsonParse<T>(string jsonString)
|
{
|
DataContractJsonSerializer ds = new DataContractJsonSerializer(typeof(T));
|
MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(jsonString));
|
|
return (T)ds.ReadObject(ms);
|
}
|
|
public static DataTable getTableFromXls(string fileName, string range, string sheetname)
|
{
|
string connStr = "";
|
if (fileName.IndexOf(".xlsx") >= 0)
|
{
|
connStr = "Provider=Microsoft.Jet.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
|
}
|
else
|
{
|
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
|
}
|
|
string sheetna = "Sheet1";
|
if (!sheetname.Equals(""))
|
{
|
sheetna = sheetname;
|
}
|
string sql = "select * from [" + sheetna + "$" + range + "]";
|
|
OleDbDataAdapter da = new OleDbDataAdapter(sql, connStr);
|
DataSet ds = new DataSet();
|
try
|
{
|
da.Fill(ds, "datatable");
|
errMsg = "";
|
return ds.Tables[0];
|
}
|
catch (Exception ex)
|
{
|
errMsg = ex.Message;
|
return null;
|
}
|
}
|
|
public static int safeToInt(object anysome)
|
{
|
if (anysome == null) return 0;
|
else if (string.IsNullOrEmpty(anysome.ToString()))
|
{
|
return 0;
|
}
|
else
|
{
|
int data = 0;
|
string sdata = anysome.ToString();
|
if (sdata.Contains("%"))
|
{
|
sdata = sdata.Replace("%", "");
|
try
|
{
|
data = int.Parse(sdata) / 100;
|
}
|
catch { data = 0; }
|
}
|
else
|
{
|
try
|
{
|
data = int.Parse(sdata);
|
}
|
catch { data = 0; }
|
}
|
return data;
|
}
|
}
|
|
public static double safeToDouble(object anysome)
|
{
|
if (anysome == null) return 0.0;
|
else if (string.IsNullOrEmpty(anysome.ToString()))
|
{
|
return 0.0;
|
}
|
else
|
{
|
double data = 0;
|
string sdata = anysome.ToString();
|
if (sdata.Contains("%"))
|
{
|
sdata = sdata.Replace("%", "");
|
try
|
{
|
data = double.Parse(sdata) / 100.0;
|
}
|
catch { data = 0; }
|
}
|
else
|
{
|
try
|
{
|
data = double.Parse(sdata);
|
}
|
catch { data = 0; }
|
}
|
return data;
|
}
|
}
|
|
public static DateTime safeToDatetime(object anysome)
|
{
|
if (anysome == null || string.IsNullOrEmpty(anysome.ToString())) return new DateTime(1900, 1, 1, 0, 0, 0);
|
else
|
{
|
DateTime dt = new DateTime(1900, 1, 1, 0, 0, 0);
|
try
|
{
|
dt = DateTime.Parse(anysome.ToString());
|
}
|
catch { dt = new DateTime(1900, 1, 1, 0, 0, 0); }
|
return dt;
|
}
|
}
|
|
public static string safeToString(object anysome)
|
{
|
string val = "";
|
try
|
{
|
val = double.Parse(anysome.ToString()).ToString();
|
}
|
catch
|
{
|
val = anysome.ToString();
|
}
|
return val;
|
}
|
|
public static DataTable createDataTable(string[] tts)
|
{
|
DataTable data = new DataTable();
|
foreach (string pi in tts)
|
{
|
DataColumn dc = new DataColumn(pi, typeof(string));
|
dc.Caption = pi;
|
data.Columns.Add(dc);
|
}
|
return data;
|
}
|
|
#endregion
|
|
#region DateTime Tool
|
public static DateTime? SafeToConvertDatatime(string datetime)
|
{
|
DateTime? result = null;
|
try
|
{
|
if (!String.IsNullOrEmpty(datetime))
|
result = DateTime.Parse(datetime);
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return result;
|
}
|
#endregion
|
|
internal static object SafeToDecimal(string txtMinOperationVolume, string v, out object message)
|
{
|
throw new NotImplementedException();
|
}
|
}
|
}
|
