| | |
| | | ",å®¡æ ¸æ¥æ,ä¿®æ¹äºº,ä¿®æ¹æ¥æ,å
³é人, å
³éæ¥æ,HEmpID" + |
| | | ",HEmpNumber,HEmpName,èåç³»æ° HEmpRate,åºæ¬å¤©æ° HBaseDays,åºæ¬å·¥æ¶ HBaseTimes,å çå·¥æ¶ HOverTimes,请åå·¥æ¶ HLeaveTimes,å çå¤©æ° HOverDays,请åå¤©æ° HLeaveDays,è¿å°æ¬¡æ° HLateQty" + |
| | | ",å
¬åº HOutForComQty,ç§åº HOutForEmpQty,å
¬åºæ¶é´ HOutForComTimes,ç§åºæ¶é´ HOutForEmpTimes,è¿å°æ¶é´ HLateTimes,æ©éæ¬¡æ° HEarlyQty,æ©éæ¶é´ HEarlyTimes" + |
| | | ",æ·å·¥å¤©æ° HAbsentDays,ä¸å HAMTimes,ä¸å HPMTimes, 表ä½å¤æ³¨ HRemark,HRestFlag,HSchClassID FROM h_v_Pay_WorkTimesBillList where 1 = 1 "; |
| | | ",æ·å·¥å¤©æ° HAbsentDays,ä¸å HAMTimes,ä¸å HPMTimes,HCTPrjID,HCTPrjNumber,HCTPrjName,HWorkTypeID,HWorkTypeNumber,HWorkTypeName,HPayMoney,HMoney" + |
| | | ",表ä½å¤æ³¨ HRemark,HRestFlag,HSchClassID FROM h_v_Pay_WorkTimesBillList where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Pay_WorkTimesBillList"); |
| | | objJsonResult.code = "0"; |
| | |
| | | return objJsonResult; |
| | | } |
| | | #endregion |
| | | |
| | | /// <summary> |
| | | /// æ°å¢åæ®-ä¿åæé® |
| | | ///åæ°ï¼string sqlã |