public bool InsertComponentTray(LotCustomerModel model) { bool isBool = false; try { _errorMsg = string.Empty; IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); isBool = serverFactory.CreateILotComponentTrayEngine().InsertComponentTray(model); } catch (Exception ex) { _errorMsg = ex.Message; } finally { CallRemotingService.UnregisterChannel(); } return(isBool); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool InsertComponentTray(LotCustomerModel model) { int count = 0; bool isBool = false; using (DbConnection dbconn = db.CreateConnection()) { dbconn.Open(); DbTransaction dbTrans = dbconn.BeginTransaction(); try { StringBuilder sbSql = new StringBuilder(); sbSql.Append("INSERT INTO dbo.POR_COMPONENT_TRAY_LIST "); sbSql.Append(" ( TrayName ,TrayValue ,LotNumber ,LineKey ,LineName ,PackageNumber ,Number ,Color ,PsKey ,SubPowerlevel ,WorkOrderNo ,PatrNumber ,GradeName ,CreateTime,VirtualCustomerNumber,IsFlip,IsPack)"); sbSql.Append(" VALUES "); sbSql.Append("(@TrayName ,@TrayValue ,@LotNumber ,@LineKey ,@LineName ,@PackageNumber ,@Number ,@Color ,@PsKey ,@SubPowerlevel ,@WorkOrderNo ,@PatrNumber ,@GradeName ,@CreateTime,@VirtualCustomerNumber,@IsFlip,@IsPack)"); SqlParameter[] parameters = { new SqlParameter("@TrayName", SqlDbType.VarChar, 50), new SqlParameter("@TrayValue", SqlDbType.VarChar, 50), new SqlParameter("@LotNumber", SqlDbType.VarChar, 50), new SqlParameter("@LineKey", SqlDbType.VarChar, 50), new SqlParameter("@LineName", SqlDbType.VarChar, 50), new SqlParameter("@PackageNumber", SqlDbType.VarChar, 50), new SqlParameter("@Number", SqlDbType.VarChar, 50), new SqlParameter("@Color", SqlDbType.VarChar, 50), new SqlParameter("@PsKey", SqlDbType.VarChar, 50), new SqlParameter("@SubPowerlevel", SqlDbType.VarChar, 50), new SqlParameter("@WorkOrderNo", SqlDbType.VarChar, 50), new SqlParameter("@PatrNumber", SqlDbType.VarChar, 50), new SqlParameter("@GradeName", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.VarChar, 50), new SqlParameter("@VirtualCustomerNumber", SqlDbType.VarChar, 50), new SqlParameter("@IsFlip", SqlDbType.VarChar, 50), new SqlParameter("@IsPack", SqlDbType.VarChar, 50) }; parameters[0].Value = model.TrayText; parameters[1].Value = model.TrayValue; parameters[2].Value = model.LotNumber; parameters[3].Value = model.LineKey; parameters[4].Value = model.LineName; parameters[5].Value = model.PackageNumber; parameters[6].Value = model.Number; parameters[7].Value = model.Color; parameters[8].Value = model.PsKey; parameters[9].Value = model.SubPowerlevel; parameters[10].Value = model.WorkOrderNo; parameters[11].Value = model.PatrNumber; parameters[12].Value = model.GradeName; parameters[13].Value = DateTime.Now.ToString(); parameters[14].Value = model.VirtualCustomerNumber; parameters[15].Value = model.IsFlip; parameters[16].Value = model.IsPack; DbCommand com = db.GetSqlStringCommand(sbSql.ToString()); //初始化command for (int i = 0; i < parameters.Length; i++) //参数填充 { db.AddInParameter(com, parameters[i].ParameterName, parameters[i].DbType, parameters[i].Value); } count = db.ExecuteNonQuery(com); //执行 if (count > 0) { isBool = true; } dbTrans.Commit(); } catch (Exception ex) { dbTrans.Rollback(); throw ex; } finally { dbTrans.Dispose(); dbconn.Close(); dbconn.Dispose(); } } return(isBool); }