public static DataTable LayThongTin_KhoThuoc()
{
DataTable dataTable =
new Select().From(LStock.Schema).OrderAsc(LStock.Columns.IntOrder).ExecuteDataSet().Tables[0];
if (!dataTable.Columns.Contains("Stock_category_Name"))
dataTable.Columns.Add("Stock_category_Name", typeof(string));
foreach (DataRow drv in dataTable.Rows)
{
if (drv["Stock_category"].ToString() == "0") drv["Stock_category_Name"] = "Kiểu kho thuốc";
if (drv["Stock_category"].ToString() == "1") drv["Stock_category_Name"] = "Kiểu kho vật tư";
}
dataTable.AcceptChanges();
return dataTable;
}
public static DataTable LayThongTinThuoc()
{
DataTable m_dtDrugDataSource =
new Select().From(LDrug.Schema).OrderAsc(LDrug.Columns.DrugName).ExecuteDataSet().Tables[0];
if (!m_dtDrugDataSource.Columns.Contains("UnSignedDrug_Name"))
m_dtDrugDataSource.Columns.Add("UnSignedDrug_Name", typeof(string));
foreach (DataRow dr in m_dtDrugDataSource.Rows)
{
dr["UnSignedDrug_Name"] = Utility.UnSignedCharacter(dr["Drug_Name"].ToString());
}
m_dtDrugDataSource.AcceptChanges();
return m_dtDrugDataSource;
return m_dtDrugDataSource;
}
private void ActionObject(action vAction)
{
try
{
if (grdObject.CurrentRow == null && (vAction == action.Update || vAction == action.Delete)) return;
switch (vAction)
{
case action.Normal:
dtObject = new Select().From(LObjectType.Schema.Name).ExecuteDataSet().Tables[0];
grdObject.DataSource = dtObject;
break;
case action.Delete:
if (
LPatientInfo.CreateQuery().WHERE(LPatientInfo.Columns.ObjectType,
Utility.Int32Dbnull(grdObject.GetValue("ID"))).
GetRecordCount() > 0)
{
Utility.ShowMsg("Danh mục đang được sử dụng. Không được xóa");
return;
}
if (Utility.AcceptQuestion("Thực hiện xóa " + grdObject.GetValue("sName"), "Thông báo", true))
{
new Delete().From(LObjectType.Schema.Name).Where(LObjectType.Columns.Id).IsEqualTo(
Utility.Int32Dbnull(grdObject.GetValue("ID"))).Execute();
grdObject.CurrentRow.Delete();
grdObject.UpdateData();
}
dtObject.AcceptChanges();
break;
default:
var oForm = new frmObjectTypeList_AU();
oForm.vAction = vAction;
oForm.drList = Utility.GetDataRow(dtObject, LObjectType.Columns.Id, grdObject.GetValue("ID"));
oForm.dtList = dtObject;
oForm.ShowDialog();
break;
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
