public static string Laygiatrithamsohethong(string ParamName, bool fromDB)
{
try
{
string reval = null;
if (fromDB)
{
SqlQuery sqlQuery =
new Select().From(SysSystemParameter.Schema).Where(SysSystemParameter.Columns.SName).IsEqualTo(
ParamName);
SysSystemParameter objSystemParameter = sqlQuery.ExecuteSingle <SysSystemParameter>();
if (objSystemParameter != null)
{
reval = objSystemParameter.SValue;
}
}
else
{
DataRow[] arrDR = globalVariables.gv_dtSysparams.Select(SysSystemParameter.SNameColumn.ColumnName + " ='" + ParamName + "'");
if (arrDR.Length > 0)
{
reval = Utility.sDbnull(arrDR[0][SysSystemParameter.SValueColumn.ColumnName]);
}
}
return(reval);
}
catch
{
return(null);
}
}
/// <summary>
/// ham thuc hien phan biet trai tuyen hay la dung tuyen
/// </summary>
/// <param name="vClinicCode"></param>
/// <returns></returns>
public static bool DiscorrectLinePatientExam(string vClinicCode)
{
DataTable dataTable = new DataTable();
dataTable = SPs.DetmayGetClinicCode(vClinicCode).GetDataSet().Tables[0];
if (dataTable.Rows.Count > 0)
{
SqlQuery q = new SqlQuery().From(SysSystemParameter.Schema)
.Where(SysSystemParameter.Columns.SName).IsEqualTo("ACCOUNTCLINIC");
if (q.GetRecordCount() > 0)
{
SysSystemParameter objParameter = q.ExecuteSingle <SysSystemParameter>();
if (objParameter.SValue.Equals(vClinicCode))
{
return(false);
}
else
{
return(true);
}
}
else
{
return(true);
}
}
else
{
return(true);
}
}
public static string GetThanhToan_TraiTuyen()
{
string sPaymentFlow = "";
SqlQuery sqlQuery = new Select().From(SysSystemParameter.Schema)
.Where(SysSystemParameter.Columns.SName).IsEqualTo("TRAITUYEN");
SysSystemParameter objSystemParameter = sqlQuery.ExecuteSingle <SysSystemParameter>();
if (objSystemParameter != null)
{
sPaymentFlow = objSystemParameter.SValue;
}
return(sPaymentFlow);
}
public static string GetThamSo_ThuTu()
{
string thamso = "THANG";
SqlQuery sqlQuery =
new Select().From(SysSystemParameter.Schema).Where(SysSystemParameter.Columns.SName).IsEqualTo(
"STT_KHAM");
SysSystemParameter objSystemParameter = sqlQuery.ExecuteSingle <SysSystemParameter>();
if (objSystemParameter != null)
{
thamso = objSystemParameter.SValue;
}
return(thamso);
}
public static SysSystemParameter Laythamsohethong(string ParamName)
{
try
{
SqlQuery sqlQuery =
new Select().From(SysSystemParameter.Schema).Where(SysSystemParameter.Columns.SName).IsEqualTo(
ParamName);
SysSystemParameter objSystemParameter = sqlQuery.ExecuteSingle <SysSystemParameter>();
return(objSystemParameter);
}
catch
{
return(null);
}
}
public static void Capnhatgiatrithamsohethong(string ParamName, string _value, string sdesc)
{
try
{
if (Utility.DoTrim(ParamName) == "")
{
return;
}
DataRow[] arrDR = globalVariables.gv_dtSysparams.Select(SysSystemParameter.SNameColumn.ColumnName + " ='" + ParamName + "'");
if (arrDR.Length > 0)
{
arrDR[0][SysSystemParameter.SValueColumn.ColumnName] = _value;
arrDR[0][SysSystemParameter.SDescColumn.ColumnName] = sdesc;
globalVariables.gv_dtSysparams.AcceptChanges();
new Update(SysSystemParameter.Schema).Set(SysSystemParameter.SValueColumn).EqualTo(_value).Set(SysSystemParameter.SDescColumn).EqualTo(sdesc).Where(SysSystemParameter.SNameColumn).IsEqualTo(ParamName).Execute();
}
else
{
SysSystemParameter newItem = new SysSystemParameter();
newItem.FpSBranchID = globalVariables.Branch_ID;
newItem.SName = ParamName;
newItem.SDesc = sdesc;
newItem.SValue = _value;
newItem.IMonth = 0;
newItem.IYear = 0;
newItem.IStatus = 1;
newItem.IsNew = true;
newItem.Save();
DataRow newrow = globalVariables.gv_dtSysparams.NewRow();
newrow[SysSystemParameter.FpSBranchIDColumn.ColumnName] = globalVariables.Branch_ID;
newrow[SysSystemParameter.SNameColumn.ColumnName] = ParamName;
newrow[SysSystemParameter.SDescColumn.ColumnName] = sdesc;
newrow[SysSystemParameter.SValueColumn.ColumnName] = _value;
newrow[SysSystemParameter.IYearColumn.ColumnName] = 0;
newrow[SysSystemParameter.IMonthColumn.ColumnName] = 0;
newrow[SysSystemParameter.IStatusColumn.ColumnName] = 1;
globalVariables.gv_dtSysparams.Rows.Add(newrow);
globalVariables.gv_dtSysparams.AcceptChanges();
}
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi cập nhật giá trị tham số hệ thống:\n" + ex.Message);
}
}
public void Init()
{
try
{
SysSystemParameter obj = THU_VIEN_CHUNG.Laythamsohethong(_pName);
if (obj != null)
{
txtValue.Text = obj.SValue;
lblDesc.Text = obj.SDesc;
}
else
{
_paramName = "UNKNOWN";
}
}
catch (Exception)
{
throw;
}
}
public static void Capnhatgiatrithamsohethong(string ParamName,string _value)
{
try
{
if (Utility.DoTrim(ParamName) == "") return;
DataRow[] arrDR = globalVariables.gv_dtSysparams.Select(SysSystemParameter.SNameColumn.ColumnName + " ='" + ParamName + "'");
if (arrDR.Length > 0)
{
arrDR[0][SysSystemParameter.SValueColumn.ColumnName] = _value;
globalVariables.gv_dtSysparams.AcceptChanges();
new Update(SysSystemParameter.Schema).Set(SysSystemParameter.SValueColumn).EqualTo(_value).Where(SysSystemParameter.SNameColumn).IsEqualTo(ParamName).Execute();
}
else
{
SysSystemParameter newItem = new SysSystemParameter();
newItem.FpSBranchID = globalVariables.Branch_ID;
newItem.SName = ParamName;
newItem.SValue = _value;
newItem.IMonth = 0;
newItem.IYear = 0;
newItem.IStatus = 1;
newItem.IsNew = true;
newItem.Save();
DataRow newrow = globalVariables.gv_dtSysparams.NewRow();
newrow[SysSystemParameter.FpSBranchIDColumn.ColumnName] = globalVariables.Branch_ID;
newrow[SysSystemParameter.SNameColumn.ColumnName] = ParamName;
newrow[SysSystemParameter.SValueColumn.ColumnName] = _value;
newrow[SysSystemParameter.IYearColumn.ColumnName] = 0;
newrow[SysSystemParameter.IMonthColumn.ColumnName] = 0;
newrow[SysSystemParameter.IStatusColumn.ColumnName] = 1;
globalVariables.gv_dtSysparams.Rows.Add(newrow);
globalVariables.gv_dtSysparams.AcceptChanges();
}
}
catch(Exception ex)
{
Utility.ShowMsg("Lỗi khi cập nhật giá trị tham số hệ thống:\n"+ex.Message);
}
}
public void Insert(string FpSBranchID,string SName,string SDataType,string SValue,int IMonth,int IYear,short IStatus,string SDesc)
{
SysSystemParameter item = new SysSystemParameter();
item.FpSBranchID = FpSBranchID;
item.SName = SName;
item.SDataType = SDataType;
item.SValue = SValue;
item.IMonth = IMonth;
item.IYear = IYear;
item.IStatus = IStatus;
item.SDesc = SDesc;
item.Save(UserName);
}
public void Update(long Id,string FpSBranchID,string SName,string SDataType,string SValue,int IMonth,int IYear,short IStatus,string SDesc)
{
SysSystemParameter item = new SysSystemParameter();
item.MarkOld();
item.IsLoaded = true;
item.Id = Id;
item.FpSBranchID = FpSBranchID;
item.SName = SName;
item.SDataType = SDataType;
item.SValue = SValue;
item.IMonth = IMonth;
item.IYear = IYear;
item.IStatus = IStatus;
item.SDesc = SDesc;
item.Save(UserName);
}
