/// <summary>
/// 获取挂号类型(TYPE_CODE,TYPE_NAME,PY_CODE,WB_CODE,PRICE)
/// </summary>
/// <returns></returns>
public DataTable GetRegisterTypeList()
{
string _gs_1_2 = OleDB.Sum("C." + Tables.base_service_items.PRICE, "");
string strWhere_3 = "A." + Tables.mz_reg_type.TYPE_CODE + OleDB.EuqalTo() + "B." + Tables.mz_reg_item_fee.TYPE_CODE + OleDB.And() +
"B." + Tables.mz_reg_item_fee.ITEM_ID + OleDB.EuqalTo() + "C." + Tables.base_service_items.ITEM_ID;
string tb = OleDB.TableName(OleDB.TableNameBM(Tables.MZ_REG_TYPE, "A"), OleDB.TableNameBM(Tables.MZ_REG_ITEM_FEE, "B"), OleDB.TableNameBM(Tables.BASE_SERVICE_ITEMS, "C"));
string strsql = OleDB.Table(tb, "", strWhere_3,
"A." + Tables.mz_reg_type.TYPE_CODE,
"A." + Tables.mz_reg_type.TYPE_NAME,
"A." + Tables.mz_reg_type.PY_CODE,
"A." + Tables.mz_reg_type.WB_CODE,
"A." + Tables.mz_reg_type.VALID_FLAG,
OleDB.FiledNameBM(_gs_1_2, "PRICE"));
strsql += OleDB.GroupBy("A." + Tables.mz_reg_type.TYPE_CODE, "A." + Tables.mz_reg_type.TYPE_NAME, "A." + Tables.mz_reg_type.PY_CODE, "A." + Tables.mz_reg_type.WB_CODE, "A." + Tables.mz_reg_type.VALID_FLAG);
return(OleDB.GetDataTable(strsql));
}
