/// <summary>Hàm lấy Object từ dữ liệu kiểu chuỗi.
/// </summary>
public static object GetObjectFromPLString(string data, FWPLDataType dataType)
{
switch (dataType)
{
case FWPLDataType.BOOL:
if (data == String.Empty)
return null;
else if (data == "Y")
return true;
else if (data == "N")
return false;
break;
case FWPLDataType.DOUBLE_NUMBER:
return double.Parse(data);
case FWPLDataType.INT_NUMBER:
return long.Parse(data);
case FWPLDataType.TEXT:
return data;
case FWPLDataType.DISPLAY_DATE:
return HelpDateExt02.ParseDisplayDate(data);
case FWPLDataType.LONG_TIME:
return HelpDateExt02.ParseLongTime(data);
case FWPLDataType.SHORT_TIME:
return HelpDateExt02.ParseShortTime(data);
default:
break;
}
return null;
}
/// <summary>Hàm lấy chuỗi tương ứng dataType để lưu
/// </summary>
public static string GetPLStringFromObject(object data, FWPLDataType dataType)
{
if (data == null) return "";
switch (dataType)
{
case FWPLDataType.BOOL:
if (data.ToString()=="True" || data.ToString() == "Y" )
return "Y";
else if (data.ToString() == "False" || data.ToString() == "N")
return "N";
break;
case FWPLDataType.DISPLAY_DATE:
return HelpDateExt02.ToDisplayDateString((DateTime)data);
case FWPLDataType.DOUBLE_NUMBER:
return "" + data;
case FWPLDataType.TEXT:
return data.ToString();
case FWPLDataType.SHORT_TIME:
return HelpDateExt02.ToShortTimeString((DateTime)data);
default:
break;
}
return "";
}
public static bool SetThamSo(string TenThamSo, object GiaTri, FWPLDataType dataType)
{
try
{
DatabaseFB db = DABase.getDatabase();
DbCommand dbUpdate = null;
if (TonTaiThamSo(TenThamSo))
{
dbUpdate = db.GetSQLStringCommand("update fw_tham_so_ung_dung set gia_tri=@giatri where ten_tham_so=@thamso");
db.AddInParameter(dbUpdate, "@thamso", DbType.String, TenThamSo);
db.AddInParameter(dbUpdate, "@giatri", DbType.String, HelpMultiDataTypeField.GetPLStringFromObject(GiaTri, dataType));
}
else
return false;
db.ExecuteNonQuery(dbUpdate);
return true;
}
catch (Exception ex)
{
PLException.AddException(ex);
return false;
}
}