| | |
|---|
| | | string[] s1 = Array.ConvertAll<string, string>(str.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[] |
|---|
| | | //string s1 = string.Format("'{0}'", str.Replace(",", "','")); |
|---|
| | | |
|---|
| | | string sql = @"select B.wo_code, B.eqp_code,B.time_start,B.time_end, 'S' status , B.alloc_qty,D.partname as part_name |
|---|
| | | string sql = @"select B.wo_code, B.eqp_code,B.time_start,B.time_end, 'S' status , B.alloc_qty,D.partcode as part_code,D.partname as part_name,T.name as uom_name |
|---|
| | | from TK_Wrk_EqpAps B |
|---|
| | | left join TK_Wrk_Man C on B.wo_code=C.wo_code |
|---|
| | | left join TMateriel_Info D on C.materiel_code=D.partcode |
|---|
| | | left join TUom T on D.uom_code=T.code |
|---|
| | | where B.eqp_code in @eqpcode |
|---|
| | | and convert(varchar(100),B.Time_Start,21)>=@startdate and convert(varchar(100),B.Time_End,21)<=@enddate order by time_end"; |
|---|
| | | dt = DapperHelper.selectlist(sql, new { eqpcode = s1.ToArray(), startdate= startdate + " 00:00:00", enddate= enddate + " 23:59:59" }); |
|---|
