using System; using System.Data; using System.Data.SqlClient; using DataLinkMesWork; using System.Collections; using System.Collections.Specialized; //using SystemFramework; namespace bizFacade { /// /// 电子看板信息系统 /// public partial class BaseDataSystemMES { /// /// 计算工位产量 /// /// @班次代码 /// @工位节拍 /// @当前时间 /// @工位产量 static public void OpNameCount(int shiftCode,int opNameTime,DateTime currentTime,out int opNameCount) { //exec 电子看板_工作时间与班次_工作时间 1,45,'2011-11-30 13:11:00', @工位产量 out opNameCount = 0; string procedureName; procedureName = "电子看板_工作时间与班次_工作时间"; SqlParameter[] thisParmsSql = new SqlParameter[4]; thisParmsSql[0] = new SqlParameter("@班次代码", shiftCode); thisParmsSql[1] = new SqlParameter("@工位节拍", opNameTime); thisParmsSql[2] = new SqlParameter("@当前时间", currentTime); thisParmsSql[3] = new SqlParameter("@工位产量", opNameCount); thisParmsSql[3].Direction = ParameterDirection.Output; DataAccess.ExecuteStoredProcedure(procedureName, ref thisParmsSql); opNameCount = Convert.ToInt32(thisParmsSql[3].Value); } } }