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); } }