帮忙将下面的php语言转换成c#
程序员文章站
2024-04-03 11:32:16
...
phpc#
下面这些转换成C#,该怎么转?
class Application_Model_Checknote{
private $db;
private $incheck='in_check';
private $outcheck='out_check';
private $table=array('check_office'=>'patient_check_office','out_check'=>'patient_out_check',
'in_check'=>'patient_in_check','check_note'=>'patient_check_note','check_note_lab'=>'patient_check_note_lab',
'check_note_item'=>'patient_check_item_note','check_note_lab'=>'patient_check_note_lab');
private $type=array('in_check'=>'住院','out_check'=>'门诊');
private $case=array('in_check'=>1,'out_check'=>0);
private $kind=array('心电'=>0,'B超'=>0,'彩超'=>0,'检验'=>1,'放射'=>2,'CT'=>2,'MRI'=>2,'CR'=>2,'DR'=>2,'DX'=>2,'MR'=>2);
public function __construct(){
}public function getCheckList($icno){ return array_merge($this->getOutCheck($icno),$this->getInCheck($icno));}private function getOutCheck($icno){ return $this->getCheck($this->outcheck, $icno);}private function getInCheck($icno){ return $this->getCheck($this->incheck, $icno);}private function getCheck($type,$icno){ $data=array(); $outsql="SELECT b.s_kind,a.n_serial,a.s_check_sn,a.s_check_name,CONVERT(varchar(100),a.d_check_time,23) as d_check_time FROM ".$this->table[$type]." as a, ".$this->table['check_office']." as b WHERE ( a.s_office_check = b.s_code ) AND ( a.s_ic_no = '".$icno."' ) AND ( a.s_charge_mark = '1' ) "; $res=$this->db->query($outsql); if(count($res)>0){ foreach($res as $r){ $data[]=array('i'=>$this->case[$type],'type'=>$this->type[$type],'checksn'=>$r['s_check_sn'],'kind'=>$r['s_kind'],'k'=>$this->kind[$r['s_kind']], 'serial'=>$r['n_serial'],'checkname'=>$r['s_check_name'],'checktime'=>$r['d_check_time']); } } return $data;}