public override bool InsertRecipeCollectProfile(BaseProfileDS baseprofile, string recipename, DateTime Starttime, string sPath)
{
//执行sql脚本创建新存储过程并删除旧的存储过程
//1、建表过程(暂时不包含base所属表)
//string sPath = Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory);
//sPath = Path.Combine(Path.Combine(sPath, "config"), "CreateTablesProc.sql");
ExecuteMySqlScript(sPath);
//2、插入数据过程
//执行
long row = ExecuteNonQueryReturnOutParameterValue("CreateTablesProc", CommandType.StoredProcedure, new MySqlParameter[] { new MySqlParameter(@"anaNums", baseprofile.ProcessAnaDataG.Count), new MySqlParameter(@"ovenNums", baseprofile.OvenInfoData.SegNum), new MySqlParameter(@"lineName", baseprofile.ProLine), new MySqlParameter(@"recipeName", recipename), new MySqlParameter(@"productName", baseprofile.ProName), new MySqlParameter(@"baseName", baseprofile.BaseName), new MySqlParameter(@"processName", baseprofile.ProcessTechName), new MySqlParameter(@"ovenName", baseprofile.OvenTechName), new MySqlParameter(@"startTime", baseprofile.StartTime), new MySqlParameter(@"eventFileName", recipename + @"_EventInfo"), new MySqlParameter(@"isControlcode", baseprofile.IsControlCode), new MySqlParameter(@"controlCode", baseprofile.ControlCode) });
//long row = ExecuteNonQueryReturnOutParameterValue("CreateTablesProc", CommandType.StoredProcedure, new MySqlParameter[] { new MySqlParameter(@"anaNums", 12), new MySqlParameter(@"ovenNums", 7), new MySqlParameter(@"lineName", "test"), new MySqlParameter(@"recipeName", "recipe1"), new MySqlParameter(@"productName", "pro1"), new MySqlParameter(@"baseName", "base1"), new MySqlParameter(@"processName", "pro1"), new MySqlParameter(@"ovenName", "oven1"), new MySqlParameter(@"startTime", baseprofile.StartTime), new MySqlParameter(@"eventFileName", "recipe1" + @"_EventInfo"), new MySqlParameter(@"isControlcode", 0), new MySqlParameter(@"controlCode", "1") });
return(true);
}
/// <summary> /// 插入pis基准数据 /// </summary> /// <param name="BaseProfile"></param> /// <returns></returns> public abstract bool InsertRecipeCollectProfile(BaseProfileDS baseprofile, string recipename, DateTime Starttime, string sPath);
public override bool InsertRecipeCollectProfile(BaseProfileDS baseprofile, string recipename, DateTime Starttime, string sPath)
{
throw new NotImplementedException();
}
